Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Available vs. On Hand

(0) ShareShare
ReportReport
Posted on by

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.

*This post is locked for comments

  • Karthik Sellamuthu Palanisamy Profile Picture
    1,202 on at
    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

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Featured topics

Product updates

Dynamics 365 release plans