Questions Creating a Simple Condition From Data Field GI - Syntax

I found this on the forums,

https://www.augforums.com/augforums/acumatica-generic-inquiries/formulas-on-generic-inquiry/

Getting better at building these.....

Thank you 🙂

You need to give Acumatica a complete reference to the column you want to work with. The proper syntax for the field you seem to be referencing would be [POTaxTran.CurryTaxableAmt]*.0675. 

Here are some tips to consider as well:

• Use the calculation editor provided by Acumatica to help ensure your syntax is correct. To access, click on the pencil when the focus is on the data field cell.
• Within the editor, you can click on 'Fields' to get a list of every column available in your GI based on the DAC's included on the Tables tab.
• In the schema field column, reference a field that is formatted the way you want your answer to be formatted
• Be sure to enter a column description in the caption column to better describe your data.

I hope this helps get you started.

Cheers.