I have tried using ADCRONLY to return the withdrawals (transfers to checking) from a bank savings account. It consistently returns 0.00. Just for grins, I tried ADCREDIT, which also returns 0.00. Just for more grins, I tried ADDEBIT and ADDRONLY. These two returned the ending balance for the period. Below are the formulas I used (straight from the example in the help file):
=ADCRONLY("GLDATA.BAL",$B9) returns 0.00 (expected $16,000.00)
=ADCREDIT("GLDATA.BAL",$B9) returns 0.00
=ADDEBIT("GLDATA.BAL",$B9) returns $35,572.45
=ADDRONLY("GLDATA.BAL",$B9) returns $35,572.45 (expected $13,018.49)

The value in $B9 is 1010-` and is generated by .RANGE on a Smartsheet report. We retreive using classes as departments. I have tried hard-coding the account in the formulas as =ADCRONLY("GLDATA.BAL","1010:1010") and get the same result. I've also tried, just for grins and since I like to grin, other data fields such as OPEN, CURBAL, etc. Still no luck. Looking at the account data, it blows my mind. But that's probably another question for another thread.

I've tried to give as much info as I can, but I'm sure I left out a critical piece. Any help getting ADCRONLY and ADDRONLY to work is greatly appreciated.

Thanks,

Tim

Just as I hit the submit button, I remembered what I left out.

Below are the software specs:
Quickbooks 2005 Premier Edition for Non-Profits
Adagio FX/Pro v8.0F
Adagio FX Financial Reporter v1.19.61.1243
Windows XP SP2

It would appear that the Account Balance in Account 1010 is $35,572.45 and that is what ADDEBIT and ADDRONLY is returning. If you have other Departments in Account 1010 that correspond to your QB Classes then you might want to try 1010:1010-* in B9

The Financial Reporter does not examine the Posted Detail's in Account 1010 to seperate Debits from Credits.

There are only 2 departments that show up in account 1010 - one is blank, and the other is 31 (General Fund). When I look at the account data in FX, the one with the blank dept. has a value of $34,939.34 and dept. 31 has a value of $633.11 (total of $35,572.45 which is the ending balance as I stated in the original post and you observed in reply). When I look at the transactions for the 2, the blank dept. has transactions that look OK (they are the deposits and withdrawals that I want), but the 31 dept. has 1 transaction in the amount of $50.42, not 633.11. The 50.42 is interest that posted for January. But all this is that question for another thread that I mentioned originally.

If Reporter doesn't look at transaction details, where does it ever get a value for ADCRONLY and ADDRONLY? What use are they? Is there a way to get what I want - the sum of the deposits and withdrawals in an asset (bank) account in a given month?

Oops. Forgot to mention that the 1010:1010-* had no effect. It's been a long day.

If you had a range of Accounts (say 1010:3000) that had different Balances ( some Debits and Some Credits) you would see the behaviour change )

1010:1010-` and 1010:1010-* are the same when you have not selected a specific department

Wow. I can't understand the logic of a function only working on a range of more than one account. If it works for a range of something like 1010:1099, it should also work for 1010:1010, since it is still a range.

But the thing is, I tried it when the report was collapsed and the value of $B9 is 1010:1030-`. Still returned 0.00. 1010:1030 is 3 accounts: checking, savings, and petty cash. Tried hardcoding "1010:1030" which returned $1,160.19. No idea what that represents.

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.

OK, now I see the logic behind the functions. Don't necessarily agree with it, but at least I see it. I guess I'll just have to live with what we have. As far as Crystal Reports, if I remember right from year before last when I was checking out reporting options, I would have gotten it to begin with and been done with it ... except for the gosh-awful price. We're a small church and simply can't afford it. I seem to remember something about GridView but can't place it.

Oh well. Thanks for your help.

Use the .Y specification on your 1010-` Account in a Financial Spec.

On the Cell click Right Button | Tx Details and then the Excel Icon. Once in Excel Sort on the Amount Column.

You might need Adagio FX 8.1B to get this capability