When adding the location filter to INVBAL, use 'LOC2'.
This is because an article (ART) can be found in more than one location.
INVBAL is based on the Stock value register (SVR). One article has one stock value register (SVR).
The stock value register (SVR) summarizes stock for each item based on currency, location and other dimensions.
If an article contains stock from 2 different locations, the stock value register (SVR) will have 'MIX' defined in the field: LOC. Therefore when searching with the field: LOC for articles in a specific location, it will not include the articles defined with MIX.
The correct articles will be found using the field: 'LOC2'.