Amounts that are reported by ADGET, ADDEBIT, ADCREDIT, ADCRONLY or ADDRONLY are for balances (or period net changes) of accounts. They do not look at individual transaction details within accounts. This is why you need a range of accounts to see a difference, and only when the SmartSheet is Collapsed (summary). If you want to break out transaction details within an account (ie Deposits and Withdrawals for the checking account 1010), then the Financial Reporter is not the correct tool for this. You really want to use GridView or Crystal Reports, and create a report on the GL Transaction Detail file. You would create formulas checking whether the amount is positive or negative and report them in separate columns.

You could use the Drill-down in the Financial reporter on account 1010 and when you see the transaction detail, export them to Excel. In the Excel spreadsheet, you can do debit/credit analysis of transaction details. But not directly in the Financial Reporter.

To describe the Financial Reporter formulas:

ADCREDIT and ADDEBIT report on the credit/debit total amount of the entire range of accounts, otherwise 0.00. If your 3 accounts 1010 to 1030 have a total debit balance of $1,160.19, then ADCREDIT would give a result of 0.00 and ADDEBIT would give 1,160.19.

ADCRONLY and ADDRONLY report the sum of credit/debit balances within the account range. If within your 3 accounts 1010 to 1030, 2 accounts have net Debit balances summing to 1,160.19 and 1 account with a Credit balance of 408.33, then ADCRONLY would give a result of 408.33 and ADDRONLY would give a result of 1,160.19.