Open Invoice does not show in Cash Receipts "Apply" screen

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
Hello

Here are the primary points to check

The transaction must be in the open status, in RM20101

In RM20101 CURTRXAM should equal or be less than ORTRXAMT, but not zero

In RM00401, the DCSTATUS should be 2 (which means open)

No associated records for this invoice in RM20201 (Open Transaction Apply)

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Justin Thorp 2,265 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Heather Roggeveen 9,146 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Justin Thorp 2,265 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Don Craig 280 on at

Like (0)

Report

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

Was this reply helpful? Yes No