Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Available vs. On Hand

Posted on by Microsoft Employee

First and foremost, apologies if this has been answered before. I'm unsure as to whether or not this is an overall SL issue or an issue with the way our company has set SL up.

We are continuously running into the issue of the Available # for Inventory going negative - which in turn means shippers (SHP-######) are unable to be confirmed.

Our most recent example is the following:

We had 0 of item X ON HAND. There were 10 ON SALES ORDERS. Thus making the AVAILABLE # a (-10). Which in turn meant our Purchasing Agent purchased a quantity of 10.

The item X was received in full (quantity of 10) giving item X a new total of 10 ON HAND. However, upon receipt we noticed that now there were 17 ON SALES ORDERS. Thus making the AVAILABLE # a (-7). 

Because of all of this, if item X is on a shipper, the shipper cannot be confirmed because the AVAILABLE # is a negative number. This makes absolutely no sense to us, since we have 10 ON HAND. All of the items for the shipper are physically available. We cannot understand why systematically we cannot close a shipper, when in reality - everything is available.

Is there a work around to this? Is the way SL has been set-up not correct? Is there something that we can adjust somewhere to correct this situation? We run into this constantly.

Any information, tips, advice, guidance that can be provided would be extremely appreciated.

Thanks so much.

  • RE: Available vs. On Hand

    Hi,

    This needs to be deal with Sales order->Shipment information-> Ship complete option. I assume you have been opted Shipcomplete option hence the partial shipments are not happening in this scenario. Below are the full information:

    Ship Complete defines how the order is to be shipped if the available inventory quantity is less than the order quantity. The choices are: Ship Complete, Backorders Allowed, and Partially Ship-Cancel Remainder.

    ·         Ship Complete — If the available inventory quantity is insufficient to fill an entire order that should ship together (same Requested Date, Ship Via, etc.), no shipment will take place until additional inventory is received to fill the entire order.

    ·         Backorders Allowed — If the available inventory quantity is insufficient to fill the entire order, then a partial shipment will be made and a backorder will be created for the remainder of the order.

    ·         Partially Ship-Cancel Remainder — If the available inventory quantity is insufficient to fill an entire order that should ship together (same Requested Date, Ship Via, etc.), a partial shipment will be made and the order schedule for the remaining quantity will be cancelled (no backorder is created).

    Ship Complete defaults to the Shipping Action entered on the Order Management tab of Customer Maintenance (08.260.00) in Accounts Receivable

    Please let me know how it goes.

    Thanks,

    Karthik

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans