Customer Balance incorrect on Cash Receipts Entry

Posted By tolden over 5 years ago

When in Cash Receipts Entry - the customer balance on the header tab does not always show the correct amount. Mostly seeing it show 0 even though there are open invoices for that account that have a balance on it. Not all accounts and it seems to be random.

I see the knowledgebase article here: https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=17964&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=15693&cmd=displayKC&dialogID=559227&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true

but it seems like this is either when receiving an error (which we are not getting any errors) OR if the balance for an invoice on the lines tab displays 0 or is incorrect (which all of the invoices display when on the lines tab and have the correct balance) yet the Customer Balance on the header still displays 0

In the AR_OpenInvoice table , the "Paid Today" field is empty for the invoices and the invoice does display a balance. And Automatic Recaluclate Aging is set to always.

Sage 100 2017

Thanks for any help anyone is able to advise.

0 Helium over 5 years ago

This likely isn’t much help to you, but …. we see this too. Although it’s a bit annoying, it doesn’t stop us from posting the payment so I just don’t worry about it.

We also have “Always” for the recalculate aging setting. But I don’t know which events trigger that recalculation. I have always assumed that when the balance is incorrect, it is because the events that trigger the recalc haven’t happened between the time an invoice was posted and when I called the customer up in cash receipts.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 BShockley over 5 years ago

Go to the File - Run menu and enter ARWAR4
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tolden over 5 years ago in reply to BShockley

Apparently, our AR manager has been running utility once a week for quite sometime now. So even with that utulity being ran we are having the issue.

Anything else I can try?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 TomTarget over 5 years ago in reply to tolden

That quirk has been around for a long time.

I can create the situation by starting a cash receipt entry batch, selecting a few invoices to pay. Then deleting the batch. Oddly enough, it doesn't always happen. Seems to be random which makes it difficult to track down what is going on.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Customer Balance incorrect on Cash Receipts Entry

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING