Solved

Local currency costs not calculating correctly on profitability

M
Rank
Userlevel 4
Badge

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?

icon

Best answer by Anacarina Calvo 26 May 2022, 10:38

View original

6 replies

Anacarina Calvo
Rank
Userlevel 6
Badge +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 

M
Rank
Userlevel 4
Badge

Thank you so much for your help.

M
Rank
Userlevel 4
Badge

@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
Rank
Userlevel 6
Badge +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
Rank
Userlevel 3
Badge +1

@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
Rank
Userlevel 6
Badge +4

Hi @sroberts29 , Please create a case for this 

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved