By using this website, you agree to our Terms of Use (click here)
Hi folks,
I am trying to understand why do that 0.00 appears in my report, and how to remove it. Any ideas?
Hi folks,
I am trying to understand why do that 0.00 appears in my report, and how to remove it. Any ideas?
Greetings folks!
For those of you facing this issue with your reports, here's the solution that worked for me:
=IIf([ARTran.InventoryID]<> Null, [ARTran.CuryTranAmt], '')
Hope this helps other people!
Hi Gustavo, it's good that you solved your own problem, but seeing as you are dealing with what I am sure is a custom report, IMHO, the better way to solve this is to filter the data from the report. In other words add a condition to the Filters tab to exclude any rows with InventoryID is null.
Hi Gustavo, it's good that you solved your own problem, but seeing as you are dealing with what I am sure is a custom report, IMHO, the better way to solve this is to filter the data from the report. In other words add a condition to the Filters tab to exclude any rows with InventoryID is null.
That's also a great way for solving this issue! Thanks a lot!
FYI, my guess is that the extra line is for freight which gets added as the last invoice line if you're using the AR Invoice report.
Online Members
