Skip to main content
Solved

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

  • October 3, 2022
  • 7 replies
  • 1254 views

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

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.

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)
  • October 4, 2022

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)
  • October 4, 2022

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


PMGannon
Sidekick (Customer)
Forum|alt.badge.img+7
  • Author
  • Sidekick (Customer)
  • October 4, 2022

@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+7
  • Author
  • Sidekick (Customer)
  • October 4, 2022

@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+10
  • Hero (Customer)
  • Answer
  • October 4, 2022

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+7
  • Author
  • Sidekick (Customer)
  • October 4, 2022

@MMcK That was it! Thank you!