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

Available stock | Warehouse Shipment

(0) Share

Report

Posted on by Bryan - Topa

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

All responses (6)

Answers (0)

Bryan - Topa 10 on at

Like (0)

Report

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 198 on at

Like (0)

Report

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 4,964 Super User 2024 Season 2 on at

Like (0)

Report

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 4,964 Super User 2024 Season 2 on at

Like (0)

Report

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 10 on at

Like (0)

Report

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.

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.

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 32,748 Super User 2024 Season 1 on at

Like (0)

Report

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.