A/R Report Showing Incorrect Payment for Customer

SUGGESTED

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.

  • 0
    SUGGESTED

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

  • 0 in reply to Best Business Strategies

    No. It was not entered twice.  The actual payment entry is not showing in Received Money - It is a file corruption per Sage

  • 0 in reply to WWJD2874
    SUGGESTED

    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.  

  • 0
    SUGGESTED

    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

    1. On the receipt that pays the invoice uncheck the Pay box for the invoice in question
    2. Recheck the Pay box for the same invoice
    3. Verify the receipt now has a positive amount
    4. Click Save

    Section II: Delete and recreate the entries

    1. 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.
    2. Reenter the invoice.
    3. 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

    1. Unpost all journals. See Article ID 14900: How to unpost and repost journals
    2. Perform the Data Verification test. See Article ID 10788: How do I load, access, and run Data Verification?
    3. Verify the invoice is corrected.
    4. 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?

  • 0 in reply to Best Business Strategies

    We already spoke to Sage Tech Support.  After everyone is logged out we are to call them back.  They are going to make a backup and said the file/transaction has to be created.  When you try to click on the transaction from any module it states that you cannot view.  I went back to each received money posting and the transaction is missing. 

  • 0 in reply to StephenC

    It will not allow us to view the entered transaction at all. 

  • 0

    We have this happen at least once per year and it is almost always connected to a Prepayment.  Running the Data Verification for A/R has always fixed it for us.  I suggest starting it at the end of the day or when there is a time that no one needs to be on the system because it can take a long time to finish.