Solved

Incorrectly entered currency rate - how to correct affected customer invoices

  • 5 August 2021
  • 6 replies
  • 315 views
M
Rank
Userlevel 3
Badge +4

Hi,

We have an issue that the currency rate was incorrectly entered and all customer invoices for one day are now registered with wrong rate. The customer invoices have also been transferred to GL so it is not possible to just change rate on the customer invoices any longer.

Have anyone had same issue and could this possibly be fixed in the database tables? 

Or is the only way to make RMAs and new invoices...that will be quite some job so would very much appreciate some fast response to my question if someone has some ideas.

 

Thanks in advance,

Marika Solgård-Olli 

icon

Best answer by AkilaR 5 August 2021, 10:52

View original
Marika
This topic has been closed for comments

6 replies

AkilaR
Rank
Userlevel 6
Badge +11

Hi @Marika Solgård-Olli ,

You can use Currency Rate Correction functionality available under Correction Invoices in Customer Invoice RMB to correct the wrongly created currency rates. This will create a new Customer Invoice with correct Currency Rate you provided during the process.

Hope this will help.

Regards,

Akila

M
Rank
Userlevel 3
Badge +4

Hi, 

Thank you for such fast response. This alternative is greyed out.

I went to where you suggested but can not change the rate here.

Can you look at the screenshot below please.


Regards,
Marika

 

Marika
AkilaR
Rank
Userlevel 6
Badge +11

Hi @Marika Solgård-Olli ,

This field is use just to display the Original Currency Rate. Please use Currency Rate field in Correction Invoice section. Update the new/correct currency rate in there and Click OK. Then system will create a new Correction Invoice with correct Currency Rate.

Hope this will help.

 

Regards,

Akila

M
Rank
Userlevel 3
Badge +4

Hi Akila,


Thanks a lot for the help! It solved our problem. All invoices fixed now.

 

Regards,
​​​​​​​Marika

Marika
M
Rank
Userlevel 3
Badge +4

Hi,

Notice that for some parts we also have cogs wrong due to that the receipts of these trading goods were received with wrong currency rate and then they were sold. Is there a similar way to correct the unit cost of stock transactions?

Regards,
Marika

Marika
AkilaR
Rank
Userlevel 6
Badge +11

Hi @Marika Solgård-Olli ,

As per my knowledge only possible way to correct the receipt transaction is cancelling the Receipt and receiving again with the correct Currency Rate. But in your case since you have already used those inventory in Customer Orders, it is also not possible. It will require data repair or migration to correct the Part Cost. But it will not correct the already done transaction. 

Hope this will help.

Regards,

Akila

Terms & ConditionsCookie settings