Topic Options
#50514 - 07/11/16 11:00 AM Accounts ReceivableVersion 9.2A
MEC2531 Offline
New Guy

Registered: 06/24/10
Posts: 7
Loc: Winnipeg, MB Canada
Over the last 8 months we have had staff changes and payments were entered incorrectly. Some payments were entered with order numbers and some with invoice numbers; some have been entered as negative numbers and some positive. In any case many customers' accounts are not balancing and the Overdue Receivables and Aged Trial Balances are totally messed up. Nothing is reconciled - payments are not applied to the correct invoices. One person entered a total payment for several invoices but they are still showing as unpaid because they were not applied to the specific invoices. I also believe that some batches were entered twice because invoices are showing as negative numbers in the Over 90 days overdue column. Is there any way to correct this?

Top
#50522 - 07/11/16 02:33 PM Re: Accounts ReceivableVersion 9.2A [Re: MEC2531]
Bruce Gardner Online   content
Adagio Wizard

Registered: 06/15/04
Posts: 3613
Loc: Toronto ON, Canada
It sounds like you will have to spend some time disentangling the more complex entries.

The starting point (after making a backup) is to locate the situations where there are unapplied Cash receipts that match exactly to invoices (in other words, they should have been applied at the time of entry). Enter a $0.00 Receipt and "apply it" to both the cash receipt and invoice transactions. That will clear up a number of the entries and allow you to focus on the more complex situations.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#50526 - 07/12/16 08:50 AM Re: Accounts ReceivableVersion 9.2A [Re: Bruce Gardner]
MEC2531 Offline
New Guy

Registered: 06/24/10
Posts: 7
Loc: Winnipeg, MB Canada
Thank you - it's a start.

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 86 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30