We use many built in reports as part of implementation and go lives (such as AR Edit, AR Register, AP Edit, AP Register, Inventory Edit, Inventory Register) to help in balancing. Will these reports ever be updated to show “negative” type documents as negative numbers, and show totals. We have to constantly export to excel and make these changes. I am sure customers have the same frustrations with these reports. Are there any plans to make these reports easier to use?
Why do so many built in reports lack totals and do not show credit memo type activities as negatives?
Userlevel 2
I used the following formulas and they appears to be working in a generic inquiry. Haven’t tried it in a report. I have the Total Aggregate Function and Aggregate functions set to SUM.
=IIf( [ARTran.TranType]='inv',[ARTran.Qty] , 0 )-IIf( [ARTran.TranType]='crm',[ARTran.Qty] , 0 )
=IIf( [ARTran.TranType]='inv',[ARTran.ExtPrice] , 0 )-IIf( [ARTran.TranType]='crm',[ARTran.ExtPrice] , 0 )
I was also originally trying to calculate the margin rather than using the available field Margin.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.