-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Mike,
this is an interesting business scenario. Before we can give any advise we need to know how you wish to process these transactions and how you set up the system. In particular we need to know whether you keep inventory of (empty) containers. If so, for what purpose. Purchase - --------- You buy a container full of product and put it into stock. I don't think that addition stock of the container keeping the product Sale - ----- You sell a product (including the container). Goods issue decreases inventory and increases COGS. Invoice should increase sales and post accounts receivables (unless paid in cash). Return of container - ---------------------- If you don't keep stock of empty containers (and I wouldn't know for what purpose) then you probably use a service number to record the (negative) value of returned containers. The account getting posted is defined in the service product description. This could be the normal sales account, then you should see negative sales or you could define a "sales reduction" account i.e. "Payment for returned containers". My personal feeling is that the last point (account assignment for returned containers) is where your problem is. If so you need to correct this for. No "doctor programs" will cure incorrect configurations. Regards, Bernd On Wed, 04 Aug 2010 20:42:50 +1200 Mike Mylonas <[email protected]> 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. > > Pointers or suggestions on where this issue might be, and more > importantly any solutions, easy or hard. > > Thanks in advance > > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iEYEARECAAYFAkxZgCgACgkQpYU8M8PbPV69lgCdH49Ba03MZ3CG71as/xF1KtvF g7oAnRHRRuZhWdJS2mmNP0NTj2/0Fpmv =OD+H -----END PGP SIGNATURE----- _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
