Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by

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

  • Suggested answer
    Thomas Newcomb Profile Picture
    1,810 on at
    RE: Cannot apply cash receipts to open invoices after updating to GP2013 SP2 (12.00.1570)

    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

  • Bill Campbell Profile Picture
    12 on at
    RE: Cannot apply cash receipts to open invoices after updating to GP2013 SP2 (12.00.1570)

    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.

  • Suggested answer
    Bill Campbell Profile Picture
    12 on at
    RE: Cannot apply cash receipts to open invoices after updating to GP2013 SP2 (12.00.1570)

    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

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Cannot apply cash receipts to open invoices after updating to GP2013 SP2 (12.00.1570)

    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.

  • DinB Profile Picture
    3,891 on at
    RE: Cannot apply cash receipts to open invoices after updating to GP2013 SP2 (12.00.1570)

    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

  • Community Member Profile Picture
    on at
    RE: Cannot apply cash receipts to open invoices after updating to GP2013 SP2 (12.00.1570)

    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?

  • DinB Profile Picture
    3,891 on at
    RE: Cannot apply cash receipts to open invoices after updating to GP2013 SP2 (12.00.1570)

    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?

  • Community Member Profile Picture
    on at
    RE: Cannot apply cash receipts to open invoices after updating to GP2013 SP2 (12.00.1570)

    Open. No.

  • DinB Profile Picture
    3,891 on at
    RE: Cannot apply cash receipts to open invoices after updating to GP2013 SP2 (12.00.1570)

    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?

  • Community Member Profile Picture
    on at
    RE: Cannot apply cash receipts to open invoices after updating to GP2013 SP2 (12.00.1570)

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans