Incorrect unposted cash amount and aging bucket discrepancy in Collections Management

Symptoms

A

From the Collections Main Window,after clicking on the Unposted Cash link, no transactions is retrieved

Or

B

The Aging Buckets do not reflect the correct / expected amounts.

Reason(s)

Due to network failure, power failure, lost connection, there are instances where the customer summary information is not in synch with the transactional records. To resolve this issue, please proceed as follows:

Resolution

Do not proceed until you have made a Backup of your Microsoft Dynamics GP Database and your Company Database.

Step I

Go to: Microsoft Dynamics GP > Tools > Utilities > Sales > Reconcile > in the Range by Customer ID, select the Customer ID having the issue in the “from” and “to” section> select your reconcile date accordingly > Account Type: All

Step II

Reconcile the customer (debtor) having the issue by completing the outstanding document amounts first and subsequently, the current customer (debtor) information.