Position Accounts on Financial Statement Based on Balance
Posted by Dee Dutton on Wed, Jul 29, 2009 @ 02:10 PM
Have you ever wanted to separate items on a financial statement based on whether they have a debit or credit balance? For instance, you have a bank account or one intercompany account and you want it to appear on the Asset side if it has a debit balance. Conversely, you want it to appear in the Liability section if it has a credit balance.
In Accpac's Financial Reporter, the "suppress zeroes" ("Z" in the C column) does not work with the FRDEBIT and FRCREDIT functions. Instead, try using the following formula for your Default Spec Row:
IF(FRAMTA("BALP")>0,FRAMTA("BALP"),0)
Ensure you have a "Z" in the C column!