I just discovered an AR problem from last year where a customer made a payment at a store last year and it does not appear in HQ. I checked the Payment table at the store and in HQ, and the payment is only in the store database. On the account tab of the customer, it appears at the store, but not at HQ.
How can I fix this and how could this have happened?
Whoa!
I also found another issue in the same account. The opposite also occurred. An account payment shows up in HQ (different amount, different date) but does not appear in the store database, even thought there is a journal receipt for that store in the HQ database.
Now I am really confused.
Hi Jason
We found this same problem with one of our customers and it was down to regional settings with people not using the US date format. Are you outside the US?
Microsoft have admitted to us it is a bug and is "pending bug resolution", we still do not have a date as to when it will be fixed.
I can provide you with a workaround if you like but it is pretty > Whoa!
I need the workaround. I found another customer with the same problem. I spend half a day making a statement manually so we could resolve the issue with the customer.
Thanks for any help you can provide.
At this point, I am wiling to live with the discrepancy. I am just going to zero the accounts and start new ones for these customers.
What I really want is to find out WHY it happened so I can maybe avoid it in the future.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.