Default Bin Item List in Business One

[tylerrajotte]

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?

[jerryjanda]

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

--Jerry

Moderation Lead

[impradeepy]

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