web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Opening entries for in...
Small and medium business | Business Central, N...
Suggested answer

Opening entries for inventory with bins enabled?

(0) ShareShare
ReportReport
Posted on by BCgs 470

I am just importing our inventory however all of the stock lives in existing locations/bins in our current warehouse management system.

I had planned to do the opening entries with the Item Journal, however you cannot select the bin the stock lives in and when you pick the warehouse location you get the error..."You cannot use the location 01 because it is set up with Direct Put-away and pick. Adjustments to this location must therefore be made in a Warehouse Item Journal"

I then go to "Warehouse Item Journal" however all of the stock needs to be put into an adjustment zone/bin (then i guess manually move it to the bin location?).

What is the best practice for opening inventory when you have the warehouse set up like this?

I have the same question (0)
  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,209 Super User 2025 Season 2 on at
    RE: Opening entries for inventory with bins enabled?

    You should be able to specify the bin code in warehouse item journal.

  • BCgs Profile Picture
    BCgs 470 on at
    RE: Opening entries for inventory with bins enabled?

    I think i am nearly there however the stock is not showing in the warehouse but it is showing in the bin?

    So i have...

    - Created a "Warehouse Item Journal" as that allows the Zone/Bin, and "Register" the stock into the correct Zone/Bin.

    - I go into the "Bin Contents" and the stock is there which is great

    - However when i look at the item on it's own it says there is 0?

    How do i have stock in a bin at a location that does not show up as stock against the Item?

  • Suggested answer
    BCgs Profile Picture
    BCgs 470 on at
    RE: Opening entries for inventory with bins enabled?

    Sorted it - So the changes needed posting on the item journal

    - So go to "Item Journal" and "Calculate Warehouse Adjustments" (you need to add in the reference from before) and then post the data there and the inventory will appear on the Item.

    Link here for reference - docs.microsoft.com/.../inventory-how-count-adjust-reclassify

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,209 Super User 2025 Season 2 on at
    RE: Opening entries for inventory with bins enabled?

    If the Bin Content and Inventory do not match, it means your warehouse and inventory module has issue. Chance is you are missing some steps on your business process.

    Go to Item Journal and run the Calculate Warehouse Adjustment.

    It will give you suggestion on how to adjust your inventory module.

  • Karan Mehta Profile Picture
    Karan Mehta 8 on at
    RE: Opening entries for inventory with bins enabled?

    Hello,

    i'm at this place and i'm stuck.

    I get the Lot number error whenever i'm trying to upload it.

    Can you tell me the process which you followed it for the uploading of item along with Inventory (In bins)

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,382 on at
    RE: Opening entries for inventory with bins enabled?

    hi

    look this

    community.dynamics.com/.../convert-inventory-to-location-bins

    DANiele

  • Karan Mehta Profile Picture
    Karan Mehta 8 on at
    RE: Opening entries for inventory with bins enabled?

    Hello Daniele,

    Thank you but the link does not solve my purpose.

    Let me elaborate, I hope this will help you where i'm stuck -

    I'm uploading the inventory with Lot Numbers via Config Package. Warehouse Item Journal.

    I'm able to see & fill everything related to Location, BINS etc. what i'm not seeing is Lot Numbers.

    Now if i want to upload the inventory along with Lot numbers. What method i should opt ? Am i wrong in choosing Warehouse item journal ?

    Regards

    Karan

  • Suggested answer
    BCgs Profile Picture
    BCgs 470 on at
    RE: Opening entries for inventory with bins enabled?

    From what I remember what i ended up doing was the process I had for doing adjustments.

    Do a huge "Warehouse Item Journal" to essentially register the items into the physical warehouse.

    Then do an "Item Journal" and "Calculate Warehouse Adjustments" and that then registers the items that show in the bins as being in actual stock.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,401

#2
Sumit Singh Profile Picture

Sumit Singh 2,692

#3
YUN ZHU Profile Picture

YUN ZHU 1,935 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans