I have this field In my Sales report and they are working as expected. They consist of Customer no, Item no, uom, salesperson, sales amount, invoiced qty, sales amount(CN), invoiced Quantity(CN).
But when i added Unit Cost, total cost and GP% i get tons of 0 sales amt and invoiced qty. I notice they are probably from adjustment.
How do i filter off those 0 sales amount and qty transaction?
Sales report from value Entries