A/R Report Showing Incorrect Payment for Customer

Question

On the AR is it showing a payment of 935.28 and an outstanding invoice of 467.64 but shows a credit on their account of 467.64 ONLY on the AR not on their customer account view - it shows zero. A prepayment was done in the amount of $467.64 and it was applied to the invoice. The invoice is still showing as outstanding. When I pull various reports, AR, GL for Unearned Revenue, Cash Account, Customer Transaction Report - it will not allow me to click to see detail or original entry. I have done a search for the 935.28 amount and nothing comes up. 
 
 I have not found anymore like this as of yet.

Best Business Strategies · Answer

If you don't have a credit memo out there, I would suggest running Data Verification (DV). File > Data Verification 
 Turn back to period 1 and create a backup. DO NOT WRITE OVER THIS ORIGINAL BACKUP if you have to run DV again. 
 If you get a lot of errors corrected, run it again. If you do run it the second time and get more new errors restore the ORIGINAL back up and call us for data repair support. You do have data corruption and it will need to be professionally repaired.

Best Business Strategies · Answer

$467.64 x 2 is your $935.28. It looks like something was entered twice.

StephenC · Answer

You could also try these steps from knowledgebase article ID: 14025 . 
 Before trying any of these steps MAKE A NEW BACKUP! If something goes wrong, restoring a backup is often the only way to undo the effects. 
 
 Section I: The Amount Paid on the invoice has a negative amount 
 
 On the receipt that pays the invoice uncheck the Pay box for the invoice in question 
 Recheck the Pay box for the same invoice 
 Verify the receipt now has a positive amount 
 Click Save 
 
 Section II: Delete and recreate the entries 
 
 Delete the receipt and then the invoice following Article ID 10834: How to delete a transaction Note: If the invoice cannot be deleted, skip to Section III below . 
 Reenter the invoice. 
 Reenter the receipt. 
 
 Section III: Run the Integrity Check, Invoice/Payment Sync Tests 
 
 Run the Invoice/Payment Sync Test and select Accounts Receivable . See Article ID 10147: How do I run the Invoice/Payment Sync Test for Accounts Receivable? 
 
 Section IV: Unpost all journals and run Data Verification 
 
 Unpost all journals. See Article ID 14900: How to unpost and repost journals 
 Perform the Data Verification test. See Article ID 10788: How do I load, access, and run Data Verification? 
 Verify the invoice is corrected. 
 Post all journals again, or change the posting method to Real-Time. See Article ID 10138: How can I change my company's posting method?

Sage 50 US

A/R Report Showing Incorrect Payment for Customer

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING