Here are some examples of commonly used expressions.
| Purpose | Expression |
|---|---|
| To get a fixed payment due date for an invoice (for example, 30 days from date of invoice). | INVOICE.INVOICE_DATE+30 |
| To get a payment due date for an invoice based on individual customer terms. | INVOICE.INVOICE_DATE+SALES_LEDGER.PAYMENT_DUE_DAYS |
| To calculate what percentage of the Sales Price the Unit Price is. | INVOICE_ITEM.UNIT_PRICE/STOCK.SALES_PRICE*100 |
| To calculate the VAT element of the Aged Balance Variable. | AUDIT_SPLIT.AGED_BALANCE-((AUDIT_SPLIT.AGED_BALANCE*AUDIT_SPLIT.NET_AMOUNT)/AUDIT_SPLIT.GROSS_AMOUNT) |
| To calculate the Gross Unit Price of an invoice item. | INVOICE_ITEM.UNIT_PRICE*(INVOICE_ITEM.TAX_RATE+100)/100 |
| To calculate the Unit Price After Discount on an invoice. | INVOICE_ITEM.UNIT_PRICE-(INVOICE_ITEM.UNIT_PRICE*INVOICE_ITEM.DISCOUNT_RATE)/100 As long as no unit price values equal 0, you can also use the following expression: INVOICE_ITEM.NET_AMOUNT/INVOICE_ITEM.QUANTITY |