Hello!
I currently have a GI that shows all sales within a certain time period. However I am noticing that credits are showing as a positive number. I saw a few ways that you can turn them into negative but my report is built off of ARTran fields.
Is there a formula I can use for this? Here are my current fields in the “Results Grid” tab
Hi there.
Here is what I did. I created a formula that multiplies the memos by a negative 1. I’m not sure if I’m capturing all the DocTypes, but these are the ones we use, so it works for us.
=SUM( iif([ARInvoice.DocType] = 'CRM' or [ARInvoice.DocType] = 'SMC', [ARTran.CuryTranAmt] * -1 , [ARTran.CuryTranAmt] ) )
Hi! You can try =IIF ([ARTran.TranType] = 'CRM', -1*[ARTran.CuryTranAmt], [ARTran.CuryTranAmt])
Where if your line is a credit memo type, then return the negative of CuryTranAmt, else return CuryTranAmt as is.
Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
