Skip to main content
Solved

Local currency costs not calculating correctly on profitability


Forum|alt.badge.img

Our base currency is ZAR, and so our inventory costs are calculated in ZAR.

When doing a service order for a foreign customer (USD), the costs are coming through incorrectly.  As an example, this item has a cost of ZAR 106.3938.  We are selling it for USD 9.59.

The since the service order is in USD, Acumatica should be taking the ZAR cost and converting it into USD, to compare apples with apples for profitability :-)  But it takes the nominal value of 106.3938 and uses that for the USD cost.

 

Now when I use the toggle button to view the base currency (ZAR) a fictional cost is displayed (the actual cost multiplied by the currency rate):

As a result the profitability is incorrect.  How do I log this as a bug?

Best answer by Anacarina Calvo

Hi @MarciaW

This seems like bug AC-219868 which was solved on Acumatica 2021 R2 Update 12 Build 21.212.0039. Please upgrade to this version or a newer one. 

See release notes for additional information on the error.  https://acumatica-builds.s3.amazonaws.com/builds/21.2/ReleaseNotes/Release_Notes_for_Acumatica_21_212_0039.pdf 

View original
Did this topic help you find an answer to your question?

6 replies

Anacarina Calvo
Pro I
Forum|alt.badge.img+4

Hi @MarciaW

This seems like bug AC-219868 which was solved on Acumatica 2021 R2 Update 12 Build 21.212.0039. Please upgrade to this version or a newer one. 

See release notes for additional information on the error.  https://acumatica-builds.s3.amazonaws.com/builds/21.2/ReleaseNotes/Release_Notes_for_Acumatica_21_212_0039.pdf 


Forum|alt.badge.img
  • Author
  • Varsity I
  • 67 replies
  • May 26, 2022

Thank you so much for your help.


Forum|alt.badge.img
  • Author
  • Varsity I
  • 67 replies
  • July 28, 2022

@Anacarina Calvo do you know if the update will fix historical data or only information going forward?  We are now on Build 21.215.0016 and it seems that details on this particular service order have not changed.


Anacarina Calvo
Pro I
Forum|alt.badge.img+4

Hi @MarciaW 
I believe it will not fix past documents, only new ones. Try deleting the line and adding it again. 
Please create a case if you need help fixing the historical data


sroberts29
Freshman II
Forum|alt.badge.img+1
  • Freshman II
  • 62 replies
  • May 18, 2023

@Anacarina Calvo - it seems a similar issue is in 22r2 update 12 - except the reverse. The Service order is written in the local currency, and a PO written for a foreign vendor is returning the Cost to the order in the local currency - thereby understating cost and affecting the Profitability of the Order. Any other similar issues being tracked?

 


Anacarina Calvo
Pro I
Forum|alt.badge.img+4

Hi @sroberts29 , Please create a case for this 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings