I seem to remember that there's a way to print the balance of a balance sheet account in the asset section if the balance is a debit or in the liability section if a credit.

Is my memory correct? If so, can someone point me to this feature, an example in a sample spec would be ideal.

Thanks

Steve

GL!BankLOC.SAM

Toggle between fiscal periods 1, 2, and 3 in Fiscal Year 2006.

You may have to UnHide all the rows in the statement and then toggle the periods to get the sample statement working properly.

Got it, thanks. Very cool.

Not being familiar with the functions ADDRONLY or ADCREDIT, is this in the documentation somewhere (Help or Videos)? I'll bet 99% of Adagio users don't know about this, and they should.

Steve

All the functions available in the financial reporter are described in the F1-Help:



Those specific functions have been available since version 1 or thereabouts. They were (are) superseded by GLCREDIT() and GLDEBIT() which are easier to read.

The financial reporter has had a significant upgrade every 8-12 months for almost 15 years. By now it's possible to say:

Hi Andrew

It turns out that in this instance, those functions don't work. The row in question is actually consolidating two GL accounts, and when the balances in the two accounts go in opposite directions, it only reports the one with the higher absolute value instead of the net, which throws the balance sheet out of balance.

I figured out a less elegant way to do it, using an IF statement.

When I asked how I might learn about this and other cool features, I didn't envision having to read in Help how each function works. Those are the rules. What I want is the strategy. Yes, I can ask for a strategy on the forum, and I don't mind doing it. I was just hoping there was some other tool.

Steve

I thought you were asking about the operation of ADDEBIT() and ADCREDIT() and the related functions. It sounds like you needed to use ADDEBIT() rather than ADDRONLY() to make the statement work in your circumstance. Then you wouldn't need the IF() statement.

You'll notice that the sample statement contains a Note about how the "trick" is accomplished. A complete familiarity with the 60 or so statements included in the sample data or posted on www.GreatStatements.com is how to learn about the cool features.

But in my experience, people need a specific problem to solve (as you did), before any of this material becomes very meaningful.

Yes, I probably did want ADDEBIT not ADDRONLY. But the sample spec you pointed to uses ADDRONLY so I went with that one, not realizing what the difference was. Now I understand.

Steve