Payments & AR discrepancies between stores & HQ

I thought that themost recent round of Hot Fix/Service Pack were supposed to fix this problem?

Did the fix not apply to prior transactions, only future ones?

Is there a fix for the old transactions? I have identified LOTS of accounts that have discrepancies where payments were taken and not applied at HQ.

Any help would be appreciated. I do not want to have to make a bunch of adjustments to fix a problem that never should have existed in the first place.

Tom

Can someone tell me what version (1.3.10XX) fixed this issue?

Would someone be willing to post the SQL to identify the problem accounts. I think I have several affected.

Todd,

Sorry for the delay in updating this topic.

My date format has always been mm/dd/yyyy but I still have quite a few accounts that are not being handled correctly by RMS.

Here's a fairly specific example for one customer:

Invoice #7842, 5/10/2008, $615.99 on account [Store B] Payment #643 of $615.99 taken at [Store C] on 6/9/2008

I can see the Payment receipt in the Journal. Store Operations Manager for Store C does not show any account activity for this customer. HQ does not show any account activity for this customer. The X & Z Reports from Store C on 6/9/2008 show a balanced till at closing.

I have about a dozen accounts like this, all of them within the last few months.

Tom

Todd,

Sorry for the delay in updating this topic.

My date format has always been mm/dd/yyyy but I still have quite a few accounts that are not being handled correctly by RMS.

Here's a fairly specific example for one customer:

Invoice #7842, 5/10/2008, $615.99 on account [Store B] Payment #643 of $615.99 taken at [Store C] on 6/9/2008

I can see the Payment receipt in the Journal. Store Operations Manager for Store C does not show any account activity for this customer. HQ does not show any account activity for this customer. The X & Z Reports from Store C on 6/9/2008 show a balanced till at closing.

I have about a dozen accounts like this, all of them within the last few months.

Tom

Todd, see my answers below.

I have been "fixing" the problem by finding the missing payments then issuing an adjustment from HQ to the store that 'lost' the payment. This seems to be working. I don't know what caused the problem but this seems to be bringing the accounts back into balance.

Tom

It's the payments that are missing, not the sales. The payments appear in the Journal and the X/Z Reports for those days are balanced. The Payments do not appear in the Store Ops databases or in the HQ database.

Yes.

No.

Yes. Did not resolve problem.

Yes. Did not solve problem.