Hi there, I'm trying to bring an optional text field in to financial reporter from Adagio G/L. I see that it is available, with a description of "OPTXT1", but I can't seem to get a formula to work. Has anyone used this one in a report?

Thanks

Hi Holiday,

The general syntax for printing the Optional Text 1 field on a financial statement would be:
=GLAMT({account},"OPTXT1")

Where account is the single account number - or account-department pair if you use departments. You can enter the account-department and "OPTXT1" directly into the formula, or use a cell reference to get the value from a different location. If you copy this formula to your sheet and replace {account} with an example of one of your accounts that has optional text, it should work. Then you can go from there.
=GLAMT("1000","OPTXT1")
=GLAMT("4000-100","OPTXT1")

If the Account key refers to more than one account, or multiple account-department pairs, then this formula will not give a result because it is not possible to summarize text from multiple accounts. It all depends on how you are using the formula.

Thanks very much!