Skip to main content
Solved

The Currency Code is not valid in the currency type1 in Company01

  • Oct 3, 2022 9:10 PM UTC
  • 7 replies
  • 1497 views

PMGannon
Sidekick (Customer)
Forum|alt.badge.img+8

We’re getting this error when trying invoice a customer order. It only occurs for this customer. We are able and have been invoicing in USD for all of our other customers and their orders from our company 01. We even cancelled the original customer order, input a new order and tried to invoice the new order. We got the same error. 

 

Any idea what is triggering this or how to solve it? 

Best answer by MMcK

Hi, we got this error when the currency ‘valid from’ date was after the transaction date.  Just backdating the ‘valid from’ sorted the problem.

View original

7 replies

Sahani Wimalaratna
Do Gooder (Employee)
Forum|alt.badge.img+2

Hi @PMGannon,

Can you check the following:

You need to go to the Currency Rates window of Company 01 and Query for Currency Rate Type:1 and add the currency rate of the relevant currency. Additionally, please check the valid from date. An example is shown below.

For example if you are entering a customer order in USD, make sure that valid currency rates are defined for the currency USD.

Kind regards,

Sahani


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • Oct 4, 2022 10:38 AM UTC

Hi @PMGannon 

at first check if it is valid in your company. Then create a currency rate.

For example:

 


cperdue
Hero (Partner)
Forum|alt.badge.img+14
  • Hero (Partner)
  • Oct 4, 2022 11:29 AM UTC

Have you verified the customer UOM?   Is USD your only currency?


PMGannon
Sidekick (Customer)
Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • Oct 4, 2022 12:32 PM UTC

@Link @Sahani Wimalaratna Yes, the currency rate was and is set-up in our company. Thank you for the quick reply though. 


PMGannon
Sidekick (Customer)
Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • Oct 4, 2022 12:43 PM UTC

@cperdue There is no customer uom on the customer order line. We do have other currencies but USD is our primary currency and is working on all of our other orders and invoices. Thank you for the quick reply. 


Forum|alt.badge.img+11
  • Hero (Customer)
  • Answer
  • Oct 4, 2022 12:58 PM UTC

Hi, we got this error when the currency ‘valid from’ date was after the transaction date.  Just backdating the ‘valid from’ sorted the problem.


PMGannon
Sidekick (Customer)
Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • Oct 4, 2022 2:37 PM UTC

@MMcK That was it! Thank you!