Another RMS accounting weirdness

This isn't the first time something like this has happened.

Customer orders a ton of stuff on several different occassions. Five work orders. Customer wants everything delivered at one time. No problem.

Today's the day. We're invoicing all five orders with a tender type of 'on account'.

9:47:14AM - TR #1 - $1,171.00 9:48:52AM - TR #2 - $268.00 Previous Balance = $1,171, New Balance = $1439. 9:51:32AM - TR #3 - $1,096 Previous Balance = $1,439, New Balance = $2535.

So far, so good. Now for the weirdness:

9:51:54AM - TR #4 - $497 Previous Balance = $1439, New Balance = $1936 !!!ALARM!!! WHERE DID THE 'New Balance = $2,535' FROM TR #3 GO? 9:53:47AM - TR #5 - $699 Previous Balance = $1936, New Balance = $2635 !!!ALARM!!! STILL MISSING $,1,096 FROM TR #3 9:56:01AM - Account Payment $3,371 (correct total of all five invoices) All five transactions are shown with correct reference #s and invoice amounts. Payment is applied correctly to all invoices. Payment amount matches invoice amount exactly in all five cases. !!!ALARM!!! Previous Balance = $2,635, Payment = $3,317, New Balance ($1,096)

This is just wrong, Wrong, WRONG! And it is REALLY difficult to explain to the customer that they don't really have a credit balance when they have a receipt that shows quite plainly that they do.

If you look the the customer properties, the balance is $0 and everything adds up. If you run an A/R Detail report for this account #, everything adds up.

SO WHY AM I HANDING THE CUSTOMER A RECEIPT THAT SHOWS A BOGUS CREDIT BALANCE OF OVER $1000!!!

TOTALLY UNACCEPTABLE.

To make matters worse, the technical rep from my RMS 'partner' (man, I hate that term) is recovering from a bicycle accident and hasn't been available for weeks. I have a STACK of nonsensical RMS errors like this for which I am anxiously awaiting an expert opinion.

Not a good start to my Friday.

Any wisdom you might offer would be greatly appreciated.

Tom -- Stop fishing for e-mail

The last transaction (TR #5 in my example) was done on register 2. The others were all done on register 1. The payment was taken on register 1. The receipt for the Account Payment shows all five transactions with the correct Invoice Amount and the correct Payment applied to each.

The problem seems to have occurred between transactions 3 & 4. Both transactions were performed on the same register. Both transactions show the Previous Balance from TR #2. Somehow - and I would love to hear a decent explanation of this one - TR #3 didn't get applied to the account properly. Strangely, the customer properties account information shows the correct balance of $0 with accurate running balances after every transaction and everything. It's just the receipts that don't add up.

Tom

I've had this as well, RMS shows balances due for ALL store accounts (company-wide tender balance) not just this customer so I took this off the receipts. Very stupid IMO that it does this. I think this is what your seeing.... The statements work OK but the receipts are useless to show account balance.

HI... does anyboy know something about this?. I have a client who has the same problem. We checked in the database and everything seems fine, all the transactions are there. But for some odd reason when you see the balance on the receipt and in RMS Manager there are transactions missing, I thought (perhaps a little bit naive of my part) that becuase my client is using R

1.2071 if I upgrade him to R.13R with the latest hotfix that probolem or bug would be solved. Unfortunately that was not the case. So please if anybody know someth> I've had this as well, RMS shows balances due for ALL store accounts

invoices appeared, as they should have?

| Database | Customer | Account Into tab

open invoices appeared, as they should have?

Balance > > > > ($1,096)