Supply Chain Management forum

How to get "Ordered in total" from On hand inventory form D365 Fin&Ops

(0) Share

Report

Posted on by Ali Sajjad

195

Hi,

I want to retreive "Ordered in total" from On-hand inventory of item. On the form it is using display methods.

I was using orderedSum() method present in InventSum table but it turned out to be giving different value than on form.

The reason is when I go in its transactions and filter Receipt on "Ordered", it shows me records and upon calculating the "Qty", it is different than the one showing on the form.

Any way to get the exact value of "Ordered in total"?

Regards,
Ali

3312.pastedimage1593683567005v2.png

0042.pastedimage1593683575849v3.png

Categories:

Development / Customization / SDK

Inventory and warehouse management

Financial Management

All responses (2)

Answers (0)

Suggested answer

Mea_ 60,274 on at

Like (0)

Report

RE: How to get "Ordered in total" from On hand inventory form D365 Fin&Ops

There is a class InventOnHandQty it accepts inventory dimensions to lookup onhand and InventDimParm to say at what level you want to see it. So make sure that InventDimParm is correct because onhand on site level would be different to warehouse level. And it has orderedSum method as well.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: How to get "Ordered in total" from On hand inventory form D365 Fin&Ops

Hi Ali,

Please make sure that you have the new grid control and total features enabled.

Once you have that, do a right mouse click and select 'total this column'.

That's all what you need.

Please see the screenprint below for an example.

Best regards,

Ludwig