Hello. I had to do a Check Links on "Receivables Open Transaction Files" to remove apply info when the AR clerk encountered a problem entering cash receipt. After the Check Links, an open sales invoice does not show up on the Apply Sales Documents screen for her to select the invoice for payment. It is open because the RM20101.CURTRXAM has the original invoice amount. What can I do to make it show up in the Apply screen?
Thanks in advance.
*This post is locked for comments
Good Afternoon,
I recently came across the exact same problem. It was found that if the transaction is a muli-currency transaction when running checklinks it will only correct the information on the RM Open Table RM20101. When looking into this further I found that the system did not update the Multi-currency table for the transaction MC020102. In order to correct I needed to run a script that updated the ORCTRXAM field by making the same value as the SLSAMNT Field on the same record.
Once the above was done the transaction re-appeared in the Cash Apply screen.
Thanks
Don Craig
Do other invoices show in the apply screen for this customer when selecting the given payment?
Similarly, if you post another cash receipt in EUR, does the invoice show in the apply screen?
(If you can try the above 2 in a test company that has the same data, this might highlight where the problem comes from).
Thanks,
Justin
1.) The functional currency of our company is USD
2.) Currency of the Invoice that does not show up on the Apply screen is EURO
3.) The A/R clerk says Receipt currency is EURO.
Hi
One other thing to try - use the reconcile utilities for Sales. Tools --> Utilities --> Sales --> Reconcile.
Do outstanding document amounts and then current debtor information.
Cheers
Heather
Hi,
Can you tell me:
1.) What is the functional currency of your company
2.) What is the currency on the invoice?
3.) What is the currency of the Cash Receipt?
Thanks,
Justin
Is there anyone out there who can point me to the right direction on why the open invoice is not showing on the Apply screen in cash receipts? Thanks.
Well, the DCSTATUS in RM00401 for the invoice in question is 2. So something else is preventing the invoice to show up in the Apply screen.
Mahmoud. Thank you. I will check out the RM00401 DCSTATUS. I have checked the RM20101 and the CURTRXAM is equal to the original invoice amount ORTRXAMT. And, no open transaction applied to this record because the Check Links removed them.
Thanks again. I will give an update later.
Hello
Here are the primary points to check
Your feedback is highly appreciated,
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,436
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
