Hi Richard. Richard Lyons wrote:
> > > Actually, these are shown as cash not cheque payments, but no matter. This > demonstrates what I'm talking about. The 1010 account now shows > > 07-04-2002 12245 Fred Flintstone 125.00 > 07-04-2002 4421 Fred Flintstone 50.00 > > whereas I would be looking for a single payment of 75.00. (I'm ignoring the > other two amounts shown there at the moment which I assume were someon > playing to try it out). It's clearer if I look at what happens when I pay > the balance due with my cheque for �30.00, after the supplier has invoiced me: > invoice 10001 for 200.00 > invoice 10002 for 138.00 > invoice 10003 for 100.00 > credit note 9994 for 408.00 > > I've set this up on the demo (now runs for me - thanks). If I pay these all > with the same check, I am going to have to enter four separate amounts to > close the four transactions, but the actual amount of the check will not > appear in a checking account listing, just the four separate and quite > different amounts. Yes, this is how it should work. What's missing is a report that subtotals each "source" id. Then you see the check total, but still retain the detail of the fact that checks frequently settle multiple invoices and credit or debit memos. I work with several thousand A/R and A/P transactions a month and each check posted to the cash accounts on the system I use, is broken down to the invoice detail. Some stuff is done in batches, but the detail is the sum of the invoices. Some checks received hit the ledger with 40+ lines. This isn't a problem because I have all of the reports, queries, and file dumps to get back to my source documents. > > > Similarly, if I receive a credit note cancelling a transaction exactly, I > shall have to invent a spurious cheque whose total will be zero, but which > will be used to close two transactions. If you haven't received payment, try just deleting or reversing the invoice. If you've cashed their check, you can issue a credit memo, which they will then "pay" by a reduction on a future check. Or you could issue an A/P check if they want their money back now. Frequently in an ongoing relationship, a credit should sit there open on a customer account until they take it. It might help to think of the position you have with a customer or vendor, because things do just kind of float up and down with the timing of the billing and payments cycle. This might seem confusing, but there will have to be some future cash settlement. > > > OK, the answer has come to me while writing this. I need a 'balancing' or > 'contra' account of type bank which I use to pay suppliers when multiple > items are involved, followed by a single general ledger transaction to debit > that contra bank and credit the real bank. The listing for this contra bank > account (with the running balance column that I have added) will always show > zero balance after each group of transactions. So all I need is to add a > 'total due' to the 'payments' screen, to simplify reconciling my listing with > the supplier's monthly statement. I can do that. I don't see the need for the extra accounts - it really does sound like your issues are more reporting related. I'd see if I could put together some reports or file dumps that will let you subtotal and compare your data to your various bank, customer, and vendor data. I think I could accomplish what you want to do with the source field. Good luck, Steve > > > -- > richard > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Caffeinated soap. No kidding. > http://thinkgeek.com/sf ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Bringing you mounds of caffeinated joy. http://thinkgeek.com/sf
