Try running a customer/journal synchronization test. Follow these steps from knowledgebase ID:10042. Do not skip making a backup.

Section I: Access the Integrity Check

Option I: For Sage 50 2018 and newer

1. Change your accounting period to Period 1, refer to Article ID 11440 (How do I change the accounting period?) in Related Resources for assistance.
2. Select Help, Support Utilities, and then click Integrity Check.
3. Click Backup.
4. Give your backup a name, choose where you would like to save it, and then click Save.
5. Click OK in the box that tells you the size of the backup.

Option II: For Sage 50 2013 through Sage 50 2017

1. Change your accounting period to Period 1, refer to Article ID 11440 (How do I change the accounting period?) in Related Resources for assistance.
2. Select Help, Customer Support and Service, and then click Integrity Check.
3. Click Backup.
4. Give your backup a name, choose where you would like to save it, and then click Save.
5. Click OK in the box that tells you the size of the backup.

Option III: For versions prior to Sage 50 2013

1. Close Sage 50
2. Right-click Sage 50 icon, and then click Properties.
3. Place after the last character on Target field, enter a blank space, add -i, click Apply, and then OK.
4. Launch Sage 50 with the icon you just modified.
5. Change your accounting period to Period 1, refer to Article ID 11440 (How do I change the accounting period?) in Related Resources for assistance.
6. Click File, and then click Integrity Check.
7. Click Backup.
8. Give your backup a name, choose where you would like to save it, and then click Save.
9. Click OK in the box that tells you the size of the backup.

Section II: Run the Customer/Journal Sync Test

1. Select Reindex Files box, select Customer from the Reindex File List, and then click OK.
2. Go back to the Integrity Check, click Continue.
3. Select Reindex Files box, select Jrnl Header from the Reindex File List, and then click OK.
4. Go back to the Integrity Check, click Continue.
5. Select Reindex Files box, select Jrnl Rows from the Reindex File List, and then click OK.
6. Go back to the Integrity Check, click Continue.
7. Select Customer/Journal under the Data Synchronization Tests section, and then click OK.
8. When the tests have finished, changed back to your current accounting period.
9. Verify that your issue has been resolved.

StephenC, thanks for the reply.  I actually tried all of that yesterday afternoon.  Those exact steps in fact.  Unfortunately it did not resolve the issue.  Sage Representative is telling me to call in to speak to somebody....unfortunately, I've tried multiple times and the wait time are outrageous and even though I've requested a call back, nobody has done so in 4 days.  Customer Support is extremely frustrating at time.

It is the beginning of August, Maybe you have a receipt posted for later in the month of August.  Dates are very important in Sage 50.  The history you are looking at in the maintain customer file is for August 31st where the receive money is as of today. 

I would look at the customer management tab.  Pull up the customer and see what is posted to the clients account. 

Thanks for the reply!  The issue has been going on since I realized it a few weeks ago.  I checked the customer management tab and it has the accurate information, same as "Receive Money".  All reports are accurate.  The inaccuracy is in the "Maintain Customer" field.  For whatever reason, it continues to show an inaccurate balance.  The good thing is I don't look up past due in that field, but it can cause a problem with one of my employees.  I've instructed everybody to not use the customer field to look at balances.  None-the-less, there is an issue and I would feel better having it resolved.

Look what I found..

• Can I enter a another customer beginning balance amount for a customer that it was incorrectly entered for?
• How do I change customer beginning balance amount?

Incorrectly entered amount on customer record 

Section I: Enter new balance

Yes, you can add another amount into Customer Beginning Balances to get the correct amounts.

Section II: Change amount manually

1. Click Maintain, Customers/Prospects
2. Select the appropriate customer from the drop-down list beside Customer ID
3. Select the History tab
4. Click Customer Beginning Balances
5. Go to the invoice that was entered incorrectly change amount
6. Click Save
7. Click Save on customer record
8. Verify customer beginning balances are now correct

Please forgive my ignorance, but I'm not sure what this article telling me to do.  I've reviewed all receipts and invoices for this year and also checked the accounts to which they were entered.  I do not see any incorrect amounts or applications.

Just to add some more information....When I go to do a quotation or invoice, the system advises me if the customer is over credit limit and by how much.  When I get the "over credit limit" pop up, its using the inaccurate amount rather than the correct number.  Just wanted to provide some more information.

Editing the beginning balance would solve the problem is the general ledger was right and the accounts receivable reports were wrong. Since you're trying to resolve a difference between the customer record and the A/R reports, it won't help.

If the sync test didn't fix it, and you're sure it's not a date discrepancy (If your current period is still set to July, make sure the report is dated 7/31/18)  then I would recommend you keep trying to get in touch with Sage support. Remember that they will only call back once. If you miss that call, I don't know how you're supposed to know that you didn't get it, but that's Sage's policy. You could try the Live Chat option too. Depending on which release you are using it will either be the last menu on the right when in the main Sage 50 window or go to the Help menu > Sage Support > Live Chat.

I can help you with data repair too, but that's usually a minimum of $500. It doesn't sound like the issue is urgent enough to take that step yet. But feel free to contact me if it is.

Thanks for the reply.  I will try and contact Sage Support again today.  I tried the Live Chat and they are the ones who gave me the instructions to run the Integrity Check and Journal Sync, just like you recommended.  I appreciate your help and feedback and will update the thread once I get this cleared up.  Thanks again.

Did you ever get assistance, DanMan21?