Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP(ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting. New visitors, please click here!
Loc: Orlando, Florida USA
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