Supply chain | Supply Chain Management, Commerce

Segregate On-Hand Stock and Sales by Supplier

(3) Share

Report

Posted on by ShyamKanna

Hi Experts,

I hope you're doing well.

Could you please advise how we can include or segregate purchase orders in the on-hand stock report? Our operation team would like to view the current on-hand stock broken down by supplier, along with the respective invoiced prices from each supplier.

Additionally, they would like to see how much stock has been sold to customers, with visibility into which supplier the stock was originally purchased from, including both the supplier's purchase price and the customer's sales price.

Your guidance on how to configure or customize this reporting in the system would be greatly appreciated. Thank you very much in advance.

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (10)

Answers (0)

Laurens vd Tang 4,628 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello ShyamKanna,

To which on-hand stock report do you refer?

Best regards,

Laurens van der Tang

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I am thinking about, how you would link inventory with the parties(customer, supplier), Do you always use Serial number or batch number in your Sales Orders and Purchase Orders?

Was this reply helpful? Yes No
DF-27020831-0 19 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Sohaib, Thank you for your time to responding my query. We do not any serial or batch number tracking non-food and not required for serial number for items. just simple site, warehouse, location and license plate configured for purchase and sales under advanced warehouse management.

Was this reply helpful? Yes No
DF-27020831-0 19 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Laurens , Thanks for the response. I would like to see purchase details on-hand list form which is under stock/inventory management Enquiries and reports On-hand list. or if its any customization options. please advice.

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,803 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

The feature you are asking it is a customization in D365, however I would request you to explore the Inventory Visibility add-on -https://www.youtube.com/watch?v=PoyFxEPpM-M

I dont think so it will fit fully, however please check if this helps you in anywhere.

On-hand stock with Supplier and when sold, you need to the link of the supplier, it is a customization, need a proper design, this cant be closed in this thread.

Was this reply helpful? Yes No
DF-27020831-0 19 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Ramit,

Thank you for taking the time to respond — I truly appreciate it.

I reviewed the Add-in feature as suggested, and I can see how it can be useful in various scenarios. Thanks again for pointing that out.

Was this reply helpful? Yes No
Drew Lencsak 433 on at

Like (0)

Report
Copy link

Link copied!

I agree with Ramit. The only thing I have seen out of the box has some dependencies. For example, if all of your items were batch-controlled, and you utilized Vendor batch numbers which were easily identifiable or using Batch tracing to link back to the vendor, then you could build reports off of that information and get a close approximation to what you need. However, that is typically unlikely as not all vendors have their own unique batch format conventions, etc.

Was this reply helpful? Yes No
DF-27020831-0 19 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Andrew,

I agree with your assessment. We don’t use batch-controlled items, so that approach wouldn’t work in our case.

Thanks for your reply. I'm currently exploring customizations to achieve the functionality we need.

Was this reply helpful? Yes No
Suggested answer

Danny Bilodeau 4,934 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, what you describe is very much like a tracking dimension. If you are going to create an extension, I would suggest using the extensible inventory dimensions. Your developer can build the business logic that you require to inform the dimension correctly.

Once complete, it becomes another inventory dimension just like any other. You can view all on-hand lists using it, you can use it in reservation hierarchy if you want. It can be visible on PO lines, SO lines etc. Very powerful.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/extensibility/inventory-dimensions

Used it for different projects for Pallet types, returnable container type and Supplier. Developper had it working in no time.

Was this reply helpful? Yes No
DF-27020831-0 19 Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi Danny,

Thank you for your response – it's quite interesting to see the customizations achievable through inventory dimensions. It looks both complex and deep, which makes it all the more intriguing. I'll take some time to explore the customization options available through this approach. I really appreciate your input and guidance. Thanks again.

Was this reply helpful? Yes No