Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GP 2010 Integration Manager - Issue with cash receipt : Apply-to document is using a wrong currency

Posted on by 14,849

We are running an cash receipt on integration manager , and the whole part is ok until it reaches the apply part where we get an error "Apply-to document XXXXXXX is using a wrong currency"

it is weird since there is no currency at this point

your feedback is greatly appreciated

best Regards

*This post is locked for comments

  • RE: GP 2010 Integration Manager - Issue with cash receipt : Apply-to document is using a wrong currency

    I am having the same issue with non functional currency on GP 18.3

    I cannot believe the feature is available in GP but not Integration Manager. That is unbelievable. Can someone please let me know how to get this to apply to the particular invoice and amount I want instead of using auto apply?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2010 Integration Manager - Issue with cash receipt : Apply-to document is using a wrong currency

    I'm running GP 2013 R2 and running into this exact same issue.  Based on what i'm reading, doesn't look like Microsoft has resolved this with any updates to 2013.  Am I missing anything?  3rd party solution or post import SQL code is the only answer?

  • PAR 63 Profile Picture
    PAR 63 on at
    RE: GP 2010 Integration Manager - Issue with cash receipt : Apply-to document is using a wrong currency

    Very late to this trail but I have been battling with this issue for over 18 months.  IM will allow you to integrate and apply multi-currency transactions if you use the AUTO APPLY setting on the Cash Apply>>Option tab in the Destination Mapping window.

    IM will not, however, allow you to apply to a specific invoice directly for MC transactions.  

    We had a macro written to help with the apply after the event.  Our team post thousands of cash receipts at any one time and it is such a time consuming process - I can't believe that it has never been developed after all these years.  In a multi-currency environment this is a key function.  GP allows the apply in the software but IM doesn't - neither does SmartConnect - we tried that too.  There is a 3rd party module from iCAN called MASS APPLY for Receivables and also for Payables and they were looking to develop the MC side of their module.  I never got a chance to look at it as our systems are being replaced.

  • Suggested answer
    Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    RE: GP 2010 Integration Manager - Issue with cash receipt : Apply-to document is using a wrong currency

    Hi,

    As per the ReceivablesManagement.pdf, it essentially states that you can't apply unposted Multicurrency Receipts/Transactions...(and this is what you are doing with Integration Manager...creating Unposted Receipts).  You must post them first.

    In either GP2013R2 or GP2015 (I can't remember which), this has changed so that you can apply an MC transaction at the time of entry/creation.

    (So the previous suggestion by Redbeard was "spot-on"...try entering and applying the Receipt directly in GP, and the error would have come up  :)   ).

    Thanks,

    Justin

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,849 on at
    RE: GP 2010 Integration Manager - Issue with cash receipt : Apply-to document is using a wrong currency

    Hello Martin

    Not really, we ended up customizing since there was we couldn't find a solution for the above.

    Regards

  • MartinFishlock Profile Picture
    MartinFishlock 10 on at
    RE: GP 2010 Integration Manager - Issue with cash receipt : Apply-to document is using a wrong currency

    Hello,

    I am also getting the error when trying to apply non-native currencies.

    Did you manage to find a solution to this issue?

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,849 on at
    RE: GP 2010 Integration Manager - Issue with cash receipt : Apply-to document is using a wrong currency

    Dear

    I am still stuck with this and everything seems to be in order regarding the destination mapping and the source files,

    if anyone has any feedback regarding this issue, it would be very much appreciated.

    Regards

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: GP 2010 Integration Manager - Issue with cash receipt : Apply-to document is using a wrong currency

    Interesting - many companies do not use Multicurrency functionality and therefore think it can safely be ignored completely.  Since you are getting this specific error, I would strongly recommend attempting to enter the document, which generates this error by hand.  If you don't get an error when entering this document by hand, then there is likely a problem with your data source or multicurrency setup.  Wrong Currency implies the error is with the data being entered in your currency field.

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,849 on at
    RE: GP 2010 Integration Manager - Issue with cash receipt : Apply-to document is using a wrong currency

    Thanks fr your input ,

    but i am using the currency ID (it is NOT set to "Use Default") and it is "Use source field" since my cash receipt transactions are of many currencies.

    Regards

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: GP 2010 Integration Manager - Issue with cash receipt : Apply-to document is using a wrong currency

    A.K.

    If you are getting a specific error like "Apply-to document XXXXXXX is using the wrong currency" you likely are unintentionally or incorrectly defining a Currency ID for the transaction.  The default setting for Cash Receipts Destination Mapping is as follows:

    If you accidentally clicked on this field and scrolled to another setting, this would cause such an error.  You will notice in transaction windows, you tab through the currency field, and Z-US$ defaults.  If you have specifically disabled this field, by selecting "Use Constant" and leaving it blank, this might also cause this type of error.  Check this field value in your integration and ensure it is set to "Use Default". 

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans