Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Available stock | Warehouse Shipment

Posted on by 10

Hello,

We are using Microsoft Business Central since 1 February. We ship around 3500-4000 items each week, divided over 1000-1300 sales orders.

Something that confuses us and takes a whole lot of time is the fact there's no availble stock visible creating a warehouse shipment.

One warehouse shipment could contain 60-100 sales orders. After we create the warehouse shipments, we go to Pick Worksheets and create warehouse picks.

Unfortunately, the availability of stock is visible at the moment we create a warehouse picks. This means that once we notice we can't pick the goods, we need to delete all items from the pick worksheet, go back to the warehouse shipment, delete the related sales order from the warehouse shipment, and go back to the pick worksheet again. 

It feels like the visibility of the available stock comes too late for our company. We would like to see the availability of stock at the moment we create a warehouse shipment.

Is there anyone who has found a decent solution for this?

Kind regards,

Bryan
Topa Bathroom Products

  • Bryan - Topa Profile Picture
    Bryan - Topa 10 on at
    RE: Available stock | Warehouse Shipment

    Exactly, we want to inform customers in advance. We don't want warehouse shipments sitting open. Our goal is to have all warehouse shipments done at the end of each day. I will check the appsource if there's any product that meets our requirements.

  • RustyAustralis Profile Picture
    RustyAustralis 198 on at
    RE: Available stock | Warehouse Shipment

    We don't do close to your volume, but took modified based on some great public blogs to create warehouse shipments per destination: this can consolidate multiple orders going to a single destination. As part of that we actually subscribe to events that check if item has a reservation, is in stock, whether the lot reserved is blocked or not and ignores it on the warehouse shipment if so. I think we are similar to you that we want to advise customers order is being prepared and don't want open warehouse shipments sitting open. That said if our customisation isn't productised. There appear to be some good appsource products now that do this. 

  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,892 Super User 2024 Season 2 on at
    RE: Available stock | Warehouse Shipment

    In your example, why do you want the Item removed from the Warehouse Shipment?  The demand for that Item to be shipped has not gone away.  It should remain on a Warehouse Shipment until it has been processed or until the demand for the Item has been cancelled.  The Pick Worksheet will let you know when your inventory is available to process some or all of that Warehouse Shipment line.

    The system by default will suggest Picks for the oldest lines first, so having the Item remain on the Warehouse Shipment will keep the system informed of the delay in processing the order.

  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,892 Super User 2024 Season 2 on at
    RE: Available stock | Warehouse Shipment

    It sounds like you are trying to create a Pick(s) for an entire Warehouse Shipment so that the whole shipment is processed in one pass.  I want to ensure you know you can ship multiple times from a single Warehouse Shipment, as the Quantity to Ship will be filled in based on the Item Picked.

    You don't have to Pick everything on the Warehouse Shipment to process a shipment.  The system will create Posted Sales Shipments which represent what was shipped on any given day.

    There are also options for setting the "Shipping Advice" on a Customer to allow for Partial or Complete shipments.  This can help restrict your warehousing activity, but can also hurt cash flow if you have Items available but don't ship and invoice them because of a backordered item.

    It would be a good idea to reach out to your Business Central partner to dive into your specific scenarios and determine the best settings/process for your business.

  • Bryan - Topa Profile Picture
    Bryan - Topa 10 on at
    RE: Available stock | Warehouse Shipment

    No, we do not have customizations. Maybe I haven't been fully clear. I will try to explain myself a little better.

    I created an example. I created a warhouse shipment for a sales order, please find below overview.

    pastedimage1682944646631v1.png

    So far so good. However, our first issue is that there's 0 overview for us whether this goods can actually be shipped. There's no stock information at all.

    Another colleague of us is moving to the pick worksheet module in BC. He finds out this goods can't be shipped. 

    pastedimage1682944745005v2.png

    This is the aspect we don't understand. We would like to have stock / availability information at the moment the warehouse shipment is created. 
    This is an easy example with just one pick-line. Imagine there are 100-200 pick-lines. If something can't be picked, you want it to be removed out of the warehouse shipment. So you got to delete all lines in the pick worksheet, move to the warehouse shipment, delete the specific sales order whcih can be shipped/picked, and do this proces again.

    I hope this is more clear now.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Available stock | Warehouse Shipment

    Do you have any customizations in your system?

    I find this behavior a bit odd because the whole idea behind the warehouse pick process should be that it should only present you with the warehouse picks have sufficient inventory to fulfill the pick.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans