on 2022 Apr 22 7:20 PM
I'm currently moving some bins/shelfs around in Business One 9.3 and have run into a problem. We have the physical inventory on the shelf and it can be easily found with a Bin Content Listing Report. However items that are not in stock still have default bins assigned to them for these spots. Is there a way I could look up the items with a default bin of a particular location?
Hi, Tyler Rajotte,
Please use the following query and under the where clause put your warehouse code.
SELECT T0.[BinCode], T1.[DftBinAbs], T1.[ItemCode]
FROM OBIN T0 INNER JOIN OITW T1 ON T0.[AbsEntry] = T1.[DftBinAbs]
WHERE T1.[WhsCode]='001'
Regards,
Pradeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
102 | |
9 | |
7 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.