web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Currency ID missing fo...
Microsoft Dynamics GP (Archived)

Currency ID missing for SOP documents

(0) ShareShare
ReportReport
Posted on by Alicia Berglund 1,144

We have recently created an integration into GP for Sales Order Invoices.  We are populating the currency ID field on all documents.  Once the documents post the currency ID gets dropped in the SOP30200 table.  This is causing an issue when trying to apply cash receipts to open documents.  The documents do not show when accessing the apply window during cash receipt entry, however they are available when access the 'Apply Sales Doc' window directly.  Has anyone run into this?  Do you know if there is a bug?  A fix?

Thanks!

*This post is locked for comments

I have the same question (0)
  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Currency ID missing for SOP documents

    There is a must question in here, what type of integration are we talking about .. ? eConnect ?

  • Alicia Berglund Profile Picture
    Alicia Berglund 1,144 on at
    RE: Currency ID missing for SOP documents

    Hi, sorry.  We are using web services.

  • Suggested answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: Currency ID missing for SOP documents

    Hi Alicia!

    So I just want to make sure I am understanding this issue correctly. You create an Invoice in SOP and post it. When you go to create the Cash receipt you try to apply it to the invoice prior to posting the cash receipt. However if you post the Cash receipt and then go to the Apply Sales Documents window you are able to pull up the Cash receipt and apply it to an invoice that was already posted.

    If this is correct I believe that you are running into Quality issue 68836 "Cannot apply functional currency cash reciepts prior to posting when the Currency ID in the RM20101 table does not match the Currency ID on the cash reciept (RM10201 table) even though both are considered 'functional curr" What happens with this quality issue is that the Currency ID of the Cash receipt is not matching the Invoices as it is not being populated correctly when it is being created. This quality issue currently set to be fixed in Dynamics GP 2015 when it is released however we currently do not have a date set in stone for the release to my knowledge.

    The current work arounds for this issue are located below.

    1. Post the cash receipt and apply it as you already are.

    2. Enabled Multicurrency if it is not already enabled and run check links. (This should set the currency correctly for the cash receipt)

    Please let us know if you had any additional questions or if this does not resolve the issue.

    ~Thomas Newcomb

    ------------------------

    Dynamics GP Support

    ------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans