By using this website, you agree to our Terms of Use (click here)
Hi,
I have this very simple formula,
=IIF( [ARInvoice.DocType]='Credit Memo', [ARInvoice.CuryOrigDocAmt]*(-1), [ARInvoice.CuryOrigDocAmt])
A single table on a GI, ARInvoice. If the document type is invoice, I want the actual amount, if credit memo, then multiply by -1. I have replaced 'Credit Memo' by CM, and tried both cases with and without quotes but none worked.
Thank you for your help (Tim 🙂 )
ARInvoice.DocType is trying to compare itself to the database values, not the values displayed on the screen.
If you run the following in SQL, you can see the possible values:
SELECT DISTINCT DocType
FROM ARInvoice
Here are some of the values:
INV = Invoice
DRM = Debit Memo
CRM = Credit Memo
So replace "Credit Memo" in your formula with "CRM" and see if that works.
Online Members
