For what it is worth: A returned container is a sale (back) from the customer to the firm. In fact, to get the figures right it would make sense to see and account the process as two way traffic: Sale to customer: sales order and sales invoice Returned container: purchase order and purchase invoice (credit note for the customer)
On payment, customer pays the total of plus sales minus purchase (credit note) and all is well. If you say the numbers do not show up, do you mean in inventory? (Is the number of containers in stock correct?) Are the containers marked as tracking articles? If you have a positive number for sales, it just could be that not all containers that were sold are returned? Thus, there is an x number of containers out there not yet returned. (The amount on the income account for sold containers should match that number, divide by price per item and see if that gives a realistic figure of containers out in the filed) Hth, Paul 2010/8/4 Armaghan Saqib <[email protected]> > On 08/04/2010 04:42 AM, Mike Mylonas wrote: > >> Hope someone can point me in the right direction. >> >> I will explain the situation in full, but please ask if you need more >> information. >> >> We ship produce in special containers, which we charge the client for, >> when they return the containers we issue a credit for them. Some >> clients bring the containers with them at order time, so we process >> these as time of raising the invoice. >> >> What our people have been doing is on the invoice put the cost of the >> individual items in, and the number of containers. If the client >> brought containers with them, they enter another line with the number of >> containers listed as a negative figure, which gives us a correct invoice >> total. >> >> What we are finding is that these negative figures are not showing in >> our trial balance at all, but the positive figures are. This means that >> we cannot rely on the income statement. >> >> > Which accounts are not being updated in trial balance? Inventory, expense? > > The accounting of return handling is not correctly done in the standard > sql-ledger. I have fixed these issues in ledger123 github version. > > So I shall recommend to use the github version and see if it sorts out your > issue. > > Important: take backups before upgrade esp. before running the cogs > reposting procedure. > > regards > Armaghan > -- > http://www.ledger123.com/ > > > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
