AR: Invoices balance is doubled during the cash receipt process

(0) Share

Report

Posted on by Community Member

I have a client that continuously having the same issue in AR. The AR sub-Ledger does not tie back to GL due to an over applied SOP documents. When trouble shooting I always find out that the invoice balance is doubled in the apply window, and when generating the historical aging the invoice is showing negative balance due to the over apply of cash. I have been un-applying it , reconcile the customer and then apply the cash back. I would like to know what would be the root cause of this issue , it happening every month now and it costing them a lot of money and it is time consuming to find the SOP invoices that is causing the discrepancy.

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

soma 24,410 on at

Like (0)

Report
Copy link

Link copied!

We need to clarifying the your issue with more detail. Can you provide the answer for below questions?

1. Is this happens for particular customer invoice?

2. Are you applying the sales documents with using any other 3rd party product/customization? or manual applying process?

Your reply is much appreciated.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

It happens randomly multiple customers. The Client have a special situation where they upload the sales and cash receipt and apply records through an integration then they run the reconcile utility to adjust RM20101 current transaction amounts. The integration uploads both Invoices and Cash receipts to work tables , They are a high volume companies ( 10 K transaction a day per transaction type ) so applying it manually is not possible . The Apply records get inserted to RM20201 using insert SQL statement. After the SOP and Cash receipt batches are posted they run the reconcile utility in sales and that takes care of adjusting the amounts.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report
Copy link

Link copied!

I think, this problem was happens for national account customers(Parent & Child relationship customers). If I am correct, then the issue should be in your "Apply Sales Documents SQL insert query" . You need to verify/correct the SQL query and try again.

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

They do use the National accounts process, I checked the SQL query and their is nothing wrong with it. the applied amount when inserted matches the original invoice amount. their is no logical explanation that why the invoice amount doubles and only in the apply tables.

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,633 Moderator on at

Like (0)

Report
Copy link

Link copied!

I'll bet you 5 bucks it has to do with the integration. I would run an integration, then have a look at the table values prior to posting, and then look at them again after posting, then once again after posting and Reconcile. Perhaps that will help pinpoint where the issue is occurring.

Was this reply helpful? Yes No