Skip to main content

Notifications

Announcements

Give Back to the Community this Month
News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Sales should not alway...
Business Central forum
Suggested answer

Sales should not always affect Inventory Balance

(1) ShareShare
ReportReport
Posted on by Rasmus 151
Hi,

If a sale of an item is recorded but the shipment will not be sent out from the warehouse for a long time I would like to still be able to sell (and see) what I have in inventory now.

For instance: I receive a very large order from a customer of 1000 units of an item. I carry 50 in inventory (which is normal for this item). That balance would be -950 and that item will seem like it is out of stock despite there being 50 that could be sold. That sale of 1000 units will be handled separetely with its own purchase order. I would like to see those 50 in stock as they are "Available to Promise"/for sale.

Special order? Location Code?

Thank you for any input!

Kind regards
 
Categories:
Business Central
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 71,232 Super User 2024 Season 2 on at
    Sales should not always affect Inventory Balance
    Hi, hope the following helps.
    Dynamics 365 Business Central: Prevent Negative Inventory
     
    Maybe you could consider Reserve feature.
    Reserve items
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 23,440 Super User 2024 Season 2 on at
    Sales should not always affect Inventory Balance

    There are a few options you can do:

    1. When creating the sales order, also create a purchase order simultaneously to offset the inventory balance to zero. You can do this manually or use the special order function.
    2. Use a blanket sales order instead. Blanket orders are not included in the system’s planning engine for inventory demand, so they won’t impact current inventory availability.
    3. Set up separate locations. You could create the sales order to be fulfilled from a location different from where the 50 units are currently stocked.

     

    Valentin Castravet
    Work: Zander ERP Services
    Blog: Dynamics 365 Business Central Insights
    LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
     

  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,340 Super User 2024 Season 2 on at
    Sales should not always affect Inventory Balance
    You could use out of box BC to achieve this. First you need to allow negative inventory by set the Prevent negative inventory flag to No on the inventory setup page. If the 50 is at location A, and you sell from location B, BC won't touch the 50 cause it's on a different location.
     
    If the 50 on inventory and the sales order is from the same location, you could lock the 50 via reservation on a dummy sales order and BC won't regard the on hand inventory as available. This approach also achieves what you want.
     
     
  • Suggested answer
    Vinayak Vishnu Sagvekar Profile Picture
    Vinayak Vishnu Sagv... 122 on at
    Sales should not always affect Inventory Balance

    Hi Friend,

    I completely agree with both responses above. However, I’d like to ask if you've encountered such scenarios once, twice, or frequently? Customization is suggested to address these situations if the standard functionality doesn’t meet your expected outcomes for special orders or specific orders with locations.

     

    Regards,

    Vinayak Sagvekar

  • Suggested answer
    Ahmad Subhani Profile Picture
    Ahmad Subhani on at
    Sales should not always affect Inventory Balance
    Interesting
    I don't think so you can manage this From Location Code and Special Order. 
    Furthermore, you can't manage it from any change in Costing Method.

    What system is doing doing is totally Logical. It will check the Quantity on the basis of the Sales Order Quantity you Wrote.
     
    If you want to see that Out-of-Stock by 950 or any unique thing, then it requires Customization.
     
    In Standard Process this is totally Logical.
  • Ramesh Kumar Profile Picture
    Ramesh Kumar on at
    Sales should not always affect Inventory Balance

    Interesting question! As I understand it, standard Business Central functionality reserves inventory based on order sequence, accounting method (like FIFO), and costing method.

    If you occasionally need to make exceptions, you could manually remove the reserve from the specific order when needed. However, if you’re looking to build this functionality into the system, it would require a code change. Once an order is created, Business Central generates secondary documents, such as warehouse shipments and picks, which also apply the reserve. To make inventory available, we’d need to remove the reserve from each of these related documents as well.

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

News and Announcements

Give Back to the Community this Month

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Replay: Dynamics 365 Community Call ERP Edition | October 9, 2024

Another great gathering of our Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans