Skip to Content

System Currency Problem

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.

gaczk.png (294.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 09, 2017 at 01:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded