| Hi again, I'm trying to process a customer returning a product to us for a refund, via a Sales Invoice. Accounting is telling me our General Ledger comes out wrong when I do it this way. Could anyone suggest a method for obtaining the desired results? Sales Invoice (input): Record in: 4012--Returns Item 1 part number: 7634950 Item 1 description: Photo album Item 1 qty: -1 Item 1 unit: 1 Item 1 price: 16.00 Item 1 extended: -16.00 Item 1 inventory account: 1510--Inventory * Item 1 income account: 4010--Sales * Item 1 expense account: 5010--Purchases * * these are hidden fields I got from the generated HTML source, but I thought they might be relevant. General Ledger (output): 1) Credit $11.25 to 1510--Inventory [should be 5010] 2) Debit $16.00 from 4010--Sales [invalid] 3) Debit $16.00 from 4012--Returns [invalid] 4) Credit $16.00 to 4012--Returns [correct] 5) Debit $11.25 from 5010--Purchases [should be 1510] Notes: - (3) and (4) cancel each other out; (4) is desired but (3) is not. - (1) and (5) are currently what happens during a sale, but they should be reversed since this is a return. - (2) should not occur since there is no sale. I'd rather not input the GL entries directly, since an invoice gives us the detail about what was returned, etc. Any ideas? -- David Deller Software Development Terry Precision Cycling (800) 289-8379 |