System Currency Problem

[Former Member]

Good Day,

I please require some assistance regarding the display of system currency.

Please have a look at the screenshot below at the highlighted parts.

What you can see is that in the Balance Due (LC) there is a zero balance which is fine. In the column Balance Due (SC) there is an amount which really should be zero. In the column Cumulative Balance (SC) there is a zero balance which is correct.

So the problem is that when I zero the Balance Due (SC) column the Cumulative Balance (SC) column goes into a negative and when printing the Trial Balance it displays that amount.

My question is how do I get all three columns mentioned to a zero balance? When running the conversion differences it zeroes the Balance Due (SC) column but the Cumulative Balance (SC) column goes into a negative.

I raised an incident with SAP Support and they said that I should rather ask the question on the forums.

[EricAlo]

Hey Quinn,

In the accounting process where you have a different functional currency and reporting currency, you should remeasure your foreign currency accounts first GL and BP. You do this by running the exchange difference tool.
Next step is to translate your functional currency to reporting currency. In SA, you do this by running the conversion difference to update your Balance Sheet system currency using the rate on balance sheet date.

This should zero out the system currency if the LC and FC is zero.

[JerushaLala]

Hi Quinn

Have you tried the exchange rate differences under financials? I always try it out in a test company before deploying on the live.

https://help.sap.com/saphelp_sbo900/helpdata/en/45/114b7529fc4805e10000000a1553f6/content.htm

Exchange Rate Differences

When you maintain foreign currency (FC) business partners and/or accounts, SAP Business One conducts all related bookkeeping in FC. Since you also conduct the bookkeeping system in local currency (LC), SAP Business One expresses every FC transaction in LC according to the FC exchange rate on the date of transaction. Daily fluctuations in FC exchange rates may cause mismatches between the balances in LC and FC.

The Exchange Rate Differences function periodically recalculates the LC and FC balances according to the exchange rate on the day the differences are calculated.

SAP Business One provides recommendations for executing automatic journal transactions for exchange rate differences in FC business partners and accounts, correct to a given date. The Exchange Rate Differences function reconciles the FC card balance and the LC balance, considering the fluctuation in the FC exchange rate.

Regards,
Jerusha