Mr Mayor
(Member)
10/20/21 01:36 PM
Multi currency tb

I would like to have a multi currency tb since the Accpac Tb is only by functional currency and not source currency

One thought is to have this by net changes but not sure how this is possible via FR

Question 2 will be other than Accpacís GL Comsolidarions module, is there anyone who has a workaround or producing a source currency tb via FR


Jay ConverseAdministrator
(Member)
10/20/21 01:38 PM
Re: Multi currency tb

That's not GAAP.

Mr Mayor
(Member)
10/20/21 11:23 PM
Re: Multi currency tb

We have had a change of currency from local to USD back to local
Most multi national companies prefer reporting in USD whereas the tax authorities say itís supposed to be in local currency

Now we are here


Ettienne
(Member)
10/25/21 05:50 AM
Re: Multi currency tb

That is a simple FR to produce a TB in another currency, the only complexity depends on if you use a fixed exchange rate or transaction exchange rates.

Mr Mayor
(Member)
10/25/21 01:49 PM
Re: Multi currency tb

Considering the rate here is changed once every week and doesnít change much, Iím up for the challenge. The fixed and the transaction rate wonít be that much miles apart Please guide me.

Ettienne
(Member)
10/26/21 05:13 AM
Re: Multi currency tb

Use FRDebit and FRCredit to create a TB:
FRDebit("BALP") and FRCredit("BALP") gives you the debit or credit balance for the current period
FRDebit("NETP") and FRCredit("NETP") gives you the debit or credit net movement for the current period
FRRate will give you exchange rates:
FRRATE(functional currency, source currency, rate type, rate date, option)
=FRRATE("USD","CAD","AV")
=FRRATE("USD","CAD","SP",DATE(2009,10,31))
=FRRATE("USD","CAD","SP",DATEVALUE(FRFISCAL("Start")))

Full details are in the Financial Reporter user guide:
Add-ins > FR > FR Help
Or Sage > Help > Product Documents > Sage 300 [version] > User's Guides > Financial Reporter User's Guide


Mr Mayor
(Member)
10/26/21 11:50 AM
Re: Multi currency tb

thank you so much for this