on 11-24-2021 12:27 PM
Dear all,
Need to help on query report which gives item warehouse wise stock quantity. SAP Business one HANA
Regards,
Nikunj
Hi Nikun
try
SELECT T0.[WhsCode], T0.[ItemCode], T0.[OnHand] FROM OITW T0 WHERE T0.[OnHand] <> 0 ORDER BY T0.[WhsCode] ASC
regards Lothar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can get this from OIVL table where all stock movement is stored.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.