Selecting specific rows where credit/debit balance does not equal zero

[ppr (Peter Preuss)]

in general you can do it by grouping the data on SKU Or Item ID

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

When processing the group members we would suggest to check some more requirements e.g. handling when not the exact opposite amount is to handle (when this can happen) like
5,-5,3,-2 → we assume 3,-2
5,-3,-2 → we assume no tows to keep

some you can implement some more specifics e.g finind pairs by mathing the closest opposite amount, or taking oldest first…