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
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
Hi John!
As I understand you have already created a case with us here at Microsoft. It seems that you are being affected by Quality issue 68836. This quality issue appears to be fixed in the next GP release. If anyone else receives this issue the main work arounds currently are located below.
1. Post the cash receipt and then apply the cash receipt in the Apply Sales Documents.
Transaction | Sales | Apply Sales Documents
2. Enabled Multicurrency if possible. This will allow for the functional currency to be added to the Cash receipt so you can apply the cash receipt from the "Cash receipt entry" window.
If you have any questions on this information please let me know!
~Thomas Newcomb
------------------------
Dynamics GP Support
------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
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.
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
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.
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
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?
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?
Open. No.
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?
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.