Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / error message (currenc...
Microsoft Dynamics NAV (Archived)

error message (currency code '' does not exist) when posting a sales order that has a prepayment component

(0) ShareShare
ReportReport
Posted on by Eric Dhlembeu 75

We are running Nav2009 R2, and have been using invoice rounding with a precision of 1.00. When you setup prepayments (100%), and post a sales order, you get an error code (currency code '' does not exist). If you put the currency code under currencies, the sales order will post to create a sales invoice, but when you check the  G/L accounts affected, the transaction is posted to (FX realised losses account), which is wrong.

If you remove the invoice rounding (put 0.01) maintain prepayments at 100% and leave out the currency from the currency table, the invoice posts properly, and the correct G/L Accounts are affected.

The setup that we require is one that does not require the LCY currency specified on the currency table. uses 1.00 rounding precision, and uses 100% prepayments.

I have done this in the cronus database and have replicated the error

May someone help us resolve this issue

*This post is locked for comments

  • Eric Dhlembeu Profile Picture
    Eric Dhlembeu 75 on at
    RE: error message (currency code '' does not exist) when posting a sales order that has a prepayment component

    We expect to use sales prepayments, set to 100%, and also invoice rounding of 1.00 for each sales invoice.

    the prepayments should not affect the fx gains and losses account, especially when the LCY currency is used.

    If I use invoice rounding of 0.01, with prepaymet amount set to 100%, the sales prepayments entries are posting correctly to GL accounts. Unfortunately we need to implement sales invoice rounding of 1.00

    When I use invoice rounding of 1.00, the system will request I add the LCY currency to the currency table when I set the customer to 100% prepayment, and this will result in entries being posted to FX gains and losses account which is wrong.

  • Suggested answer
    Miguel Llorca Profile Picture
    Miguel Llorca User Group Leader on at
    RE: error message (currency code '' does not exist) when posting a sales order that has a prepayment component

    Would you mind to explain the result you're expecting? I'm guessing that it's a mix of misconfiguration and an improper solution for your needs.

    Thank you!

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