Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 468

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?

  • Suggested answer
    BCgs Profile Picture
    BCgs 468 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.

  • 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
    DAnny3211 Profile Picture
    DAnny3211 9,274 Moderator 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,

    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
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 13,070 Moderator 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.

  • Suggested answer
    BCgs Profile Picture
    BCgs 468 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

  • BCgs Profile Picture
    BCgs 468 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
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 13,070 Moderator on at
    RE: Opening entries for inventory with bins enabled?

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

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans