Microsoft Dynamics GP (Archived)

Cannot apply cash receipts to open invoices after updating to GP2013 SP2 (12.00.1570)

(0) Share

Report

Posted on by Community Member

After updating to GP 2013 SP2 (version 12.00.1570) client cannot apply a cash receipt to open invoices.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

DinB 3,951 on at

Like (0)

Report

What happens when you try to apply? do you get any errors?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

You enter the cash receipt info then click on the Apply button and the Apply Sales Documents window opens but it doesn't show any of the open invoices to apply the payment to. You don't get any error message -- just get an empty window.

Was this reply helpful? Yes No
DinB 3,951 on at

Like (0)

Report

Can you check some of those unpaid Invoices in Inquiry?
Inquiry >> Sales>> Transaction by Document

What are the values in "Origin" column? OPEN or HIST?
Do they have amounts in "Amount Remaining" column?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Open. No.

Was this reply helpful? Yes No
DinB 3,951 on at

Like (0)

Report

Click on one of the Invoice in that Inquiry window and Click on "Amount Remaining" link to open "Applied From Credits" window. If there are already applied payments for that Invoice, it will be listed there. are there any?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

None of the open invoices appear on the Apply Sales Documents window.

Issue is due to no currency id being formatted in my RM10201-RM Cash Receipts Work table. The open invoices in the RM20101-RM OPEN table have a currency id (Z-US$). Client does not use multi-currency. If I put a currency id in the RM10201 work record then the open invoices appear. How do I get a currency id in the RM10201 work record without turning on multi-currency?

Was this reply helpful? Yes No
DinB 3,951 on at

Like (0)

Report

I see! Following forum has similar issue discussed. It has something to do with the new feature in GP 2013.
community.dynamics.com/.../122481.aspx

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

I spoke with Microsoft Support. It is a bug that has not be fixed yet. The workaround is to apply the payment on-account first. Then go to the Apply Sales Document window to apply.

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

When you updated to GP2013 the requirement for Cash Reciepts changed, not only there but also in the use of Multicurrency, so watch there as well.

You can only apply cash reciepts to an invoice that has the same Currency ID attached.

We learned this the hard way when we found that one of the sources for Invoices coming into Recievables was not populating the Currency ID in their transactions and leaving it blank.

We have had to create a script that we run every hour on the OPEN Transactions to populate the Currency ID for this client, since they only do one currency this works pretty well. If yo understand the SQL Tables, you can make this fix work pretty easy

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

The link noted in a prior reply, referrs to the case I noted as well. I am not sure but the script might be there as well.

Was this reply helpful? Yes No