web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Working out available ...
Small and medium business | Business Central, N...
Suggested Answer

Working out available inventory for an order today?

(0) ShareShare
ReportReport
Posted on by BCgs 470

I am trying to work out what available stock i have for a Sales Order i want to put on Business Central, currently i am looking at...

  • item inventory at specific warehouse?

This look at stock up until the point it is invoiced, so that is no good as you might have stock already on sales orders due to go out. (more for accounts)

  • Planning and Inventory reports?

This takes into account all of the sales orders however also the purchase orders that are on the system to, so will show there is stock but it might not be coming in for a month

  • So how do i work out what can ship today?

I need to see available stock in the warehouse minus the sales orders (excluding the purchase orders as they have not arrived yet)

Does anyone have the same issue, as there must be some sort of way to handle this as i would assume this is something fairly common?

I have the same question (0)
  • Suggested answer
    Shan Profile Picture
    Shan 20 on at

    @BCgs I recently came across this thread. I use to use ATP but found a better application.

    In the business apps - search for 'SHORTAGE ON DEMAND ORDERS'

    LINK TO DEVELOPER'S SITE:

    abakion.com/.../

    I just started using the free trail and they have great tutorial videos:

    usedynamics.com/.../

  • Suggested answer
    Shan Profile Picture
    Shan 20 on at

    Have you tried using Available-To-Promise (ATP)?

  • Suggested answer
    BCgs Profile Picture
    BCgs 470 on at

    I just wanted to update as I have come up with the solution for these issues.

    In my opinion availability is a bit of a short coming when using out of the box with Business Central. Typically you would turn Reserve=Always on the admin for each customer then you would allocate the stock to each order. However this gets messy if you need to then amend reserved stock as you have to do this by the item line. Trying to do this with an order with 100s would take ages to update and really unnecessary as the information is just presented wrong.

    What we ended up doing is exposing the reservation table into a menu item so you can access from the search to list everything (and added in additional data like customer name and so on) so we can now see a full list of all the reserved items and the customers they are linked to. This can also be exported to excel to modify the values to publish back with the excel add-in.

    We have also modified the "Sales Reservation" report to take the grouping out so it makes things a lot clearer to understand when filtering. Now we are in a position where we have completely clarity on what stock is available to ship today as we are using the reservations correctly.

    Using this alongside our B2B & B2C website API and the warehouse screen we developed to loop though available orders to split ready to pick and backorders we now have Business Central running absolutely perfect!

  • BCgs Profile Picture
    BCgs 470 on at

    It does seem Business Central is pretty awful when it comes to managing things like orders/backorders/stock.

    We ended up developing some solutions with our web partner who created our Business Central website API integration.

    Essentially all of the information is available on the web services so you can query and process it outside Business Central, things like...

    - Website picking screen - loops through available stock and orders to identify what orders are available to pick on a takeaway style screen that refreshes every 1 minute.

    - Stock reports - view on screen and look at stock/available stock/sales 30/60 days and so on

    - Daily sales - Dashboard to see sales broken down by territory and brands as well as adding in targets to see percentages achieved and so on.

    They are called sequel.co.uk saved us really as we made the leap from Sage 200 to Business Central in the new year and didn't quite realise how limiting the software was in some respects. As technically as the information is there you just need to be able to present it clearly.

  • Anita75 Profile Picture
    Anita75 1,165 on at

    It would be nice if there is some kind of screen with visibility of all orders and lines with some filtering criteria for customer, warehouse etc.

  • BCgs Profile Picture
    BCgs 470 on at

    Hi all, that's fair enough. Just when you have a sales order with 1000 lines it's not really feasible to click on each line to see the info.

    It's frustrating as the information required is on there but you just cant get hold of it.

    Scenario: customer sends you a purchase order that has a 1000 lines on it asking you what can you supply, you can't go through each line and manually fill in the quantity as it would take all day.

    We ended up building a solution to solve this using the web data so we can export the available stock in the warehouse and then lookup the released sales orders with open lines on them to work out "Free stock" and then you have a better understanding of what you actually have available.

  • Suggested answer
    John Ray Patajo Profile Picture
    John Ray Patajo 837 on at

    Inventory levels should be checked per line item.

  • Bryan Tschosik Profile Picture
    Bryan Tschosik on at

    Hi BCgs,

    Also, wanted to make sure you know about the 'Item Availability by' functionality on the Sales Line, or Item card as well.  You can see the different views there.  Not sure if this is what you are looking for, but it may be helpful.   BTW - if any of these answers are helpful, please Verify.

    https://docs.microsoft.com/en-us/dynamics365/business-central/inventory-how-availability-overview

    pastedimage1590070185006v1.png

  • Bryan Tschosik Profile Picture
    Bryan Tschosik on at

    Hi BCgs,

    Sorry for delay here.  It would just be line by line in this case....as you can have many different items on an order.

  • BCgs Profile Picture
    BCgs 470 on at

    Thanks Bryan - that's a huge help, i'll see how I get on with that - is there any way to look at it as the whole order or just line by line?

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

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,572

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 789 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 693 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans