Allocated Quantity in Sales Order view

(1) Share

Report

Posted on by DM-05060449-0

Hello,

Is there a column for allocated quantity on a sales order?

For example, for some PO's I will allocate stock and some might be short supplied as we do not have stock available.

The only way we can see how much stock was allocated to each line, is by going into item tracking lines to see what stock has been allocated.

We want to personalise our sales order columns so we can see this information on the main page.

Also, we are wanting to know if there is a way to see the available inventory once the reserved quantity has been taken out.

Thank you for your help!

Categories:

Dynamics 365 Sales

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Holly Huffman 6,522 Super User 2025 Season 2 on at

Like (0)

Report
Allocated Quantity in Sales Order view

Good morning, afternoon, or evening—depending on where you are in the world!
Hope you're doing well.

1. Allocated Quantity on Sales Order Lines
Out of the box, Business Central does not include a dedicated “Allocated Quantity” column on the Sales Order line. However, the allocation details are tracked behind the scenes—especially when reservations or warehouse picks are involved.

To surface this data more visibly:

Use the Item Tracking Lines (as you're already doing) to see exact allocations.

Alternatively, personalize the Sales Order line view to include “Reserved Quantity” or “Qty. to Ship”, which can give partial visibility depending on your process.

For more detailed allocation visibility, consider using the Item Availability by Event or Item Availability by Location views. These can be accessed from the Sales Order line via:

Line > Item Availability by > Event / Location / Variant / Timeline
This gives a breakdown of how much is available, reserved, or expected over time.

2. Available Inventory After Reservation
To see available inventory after reservations:

Use the Projected Available Balance field in the Item Availability by Event view. This shows:

Quantity on Hand + Scheduled Receipts - Gross Requirements (including reservations)

This view is especially useful when you want to understand how much inventory is truly available for new orders after accounting for existing reservations.

Summary
While there isn’t a native “Allocated Quantity” column on the Sales Order line, you can get the visibility you need by:

Personalizing the line view with related fields like “Reserved Quantity”

Using the Item Availability by Event view for a full picture of inventory status

Optionally customizing a page extension if you need a dedicated column for allocation

Note: I collaborated with AI to help craft this response and ensure it’s as accurate and helpful as possible.
Hope this helps!

Was this reply helpful? Yes No