Show Credit Memos as Negative Amounts
I am trying to create what I thought would be a simple formula in a GI to show Credit Memos as negative amounts, and all others as positive. Keep in mind there are credit memos that are zero, but I can't seem to get the syntax correct. I was close but the zeros threw it all off. I am using the ARInvoice.DocType and want to make Doc Type of Credit Memo negative for the ARTran.curyTranAmt. I thought this would be simple, but I am clearly doing something wrong and keep getting syntax errors. If there is some kind of document that can assist me with syntax you can point me to, I'm sure I could figure it out.
You can try something like this:
The key is knowing the code for the document type (CRM in this case). The way I find that out is dropping a new field and using the following formula which converts the display value to the code value: