x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 97 subscribers
  • Views 1077 views
  • Users 0 members are here
Browse Forums
Announcements
150
topics
113
replies
General Discussion
5k
topics
13k
replies
Payroll & Tax
631
topics
887
replies
Reporting and Analytics
573
topics
1k
replies
Service Alerts
1
topics
0
replies
Software Development Kit (SDK)
434
topics
671
replies
Year End
83
topics
128
replies
Keri Benton

Cash Receipts Applied, yet still in open AR. Help!

SUGGESTED
Posted By

I generated an invoice for a customer on December 10th and they paid for it immediately via CC ($3,316.91). When I go into their account, it's showing the invoice is both paid AND past due.   When I click on the related transactions it shows the receipt I generated for $3,316.91.  When I double click the receipt, it shows me the transaction. On the left hand side it shows the invoice total as $6,633.82 and the amount paid is $3,316.91.The invoice total is only $3,316.91. What are we doing wrong that a balance is being left behind the scenes? This is very random, but it is happening a few times a month.  Normally, I can offset it on the "Apply to Expenses" side.  This time it won't allow me to do it. Any help the community can give is MUCH appreciated! 

Also, I ran a GL report and all of the accounts that should be hit were hit and the amounts equal.  This one has me confused!

Keri

  • 0
    SUGGESTED

    It sounds like you need to run an Invoice/Payment Sync Test on your accounts receivable. Here are the directions from Knowledgebase ID:22414. MAKE A BACKUP BEFORE YOU DO THIS.

      1. Change your accounting period to Period 1. See Article ID 11440 How do I change the accounting period?, in Related Resources.
      2. Load or access the Integrity Check. See Article ID 10292 Integrity Check Guide, in Related Resources.
      3. Select the Accounts Payable option under the Invoice/Payment Sync Tests section.
        Note: If you need to run the Account Receivable test then select Accounts Receivable
      4. Select an option under the Correction Strategy section, then select OK.

        Note: If selecting a Correction Strategy of Ask Each Time, a window will pop up asking which is correct. The options will be either the invoice is correct or the payment is correct. Look at the options to determine which you should choose then select OK.

    If you are on a current version of Sage 50 you can get to the Integrity Check by going to the Help menu > Support Utilities > Integrity Check.

    If you have had similar problems before, those invoices may pop up on this test too. Make note of every invoice that it corrects so you can check the results when it's done. If you don't like the results you'll need to restore your backup.

*Community Hub is the new name for Sage City