How to filter record with spesific criteria

Business Central/NAV Developers Forum
1

Dear All,

I am creating report using Sales Shipment Header and Sales Shipment Line

Sample data from Sales Shipment Line

Item Qty

A 50

A -50

B 75

C 50

I only want to see B and C, as these records don’t have any balance record.

A has been canceled (Undo Shipment), therefore A should not appear in my report.

Please help

2

Why not do sumation of quantity on basis of Item so It will knock out the reversed qty and then put a filter in report for not showing zero quantity.