By using this website, you agree to our Terms of Use (click here)
Hi all,
I am working on a report that uses ARTran and I want to add up the quantities from each transaction
The issue I am having is that ARTran.Qty is stored as a positive figure regardless of the transaction type where as NetSalesAmount is stored as a positive or negative depending on the transaction type
So what I get is if there is 100 on a invoice and 50 on a credit then the quantity adds up to 150 if I do a SUM on quantity, any suggestions on how to SUM it to 50
I have tried an if statement so if the DrCr is D then multiply by -1 however when summing up the totals the report doesnt calculate this correctly
I would appreciate any suggestions
I think you can just multiply the amount by the field InvtMult to get the correct sign.
You should be doing a SUM of the formula that does the multiplication.
Online Members
