My GI is showing some Credits as negative numbers, but a lot more numbers are not negative, showing as positive. I have included the coding to account for negative numbers but it appears to not be consistent across the inquiry.
Page 1 / 1
I noticed your formula is for Invoices created from Sales Order Invoices.
Are you creating Credit Memos from Receivables → Invoices and Memos? if so, those might be the ones showing up as a positive amount because they are a different type...
It appears that those Credit Memos are appearing under the Sales Orders → Invoices and the
Receivables, so is there a way to make those as negative numbers also? They are appearing as positive numbers which is throwing the sales totals out of whack.
I believe you would have to add the ARInvoice types to your formula because the current formula is only switching the sign for SO Invoices.
So, if the ARInvoice.DocType = CRM, you would want to flip the sign on that too.
I hope this helps...
You rock! Added another formula trick to my magic bag. Thank you.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.