Sales Order Quantity - On hand field development

[former_member284149]

Hi,

I am basically production planning consultant working on a reporting requirement for client.

I need to develop a custom field 'Sales Quantity -On Hand' in custom report for production shop floor supervisor.

Sales Quantity -On Hand gives the production supervisor a snap shot of what are sales requirements for a material and what is the stock i am having on hand.

I wonder if I can get this field by subtracting sales order quantity and un-restricted stock from MMBE.

i.e Sales Quantity - On Hand = Sales Order quantity - Un-restricted stock from MMBE.

I just want to check with the sales experts in this forum whether above formula satisfy my requirements?

Also, from above formula i need to consider only those sales orders which are not delivered / PIG.

Could someone please through some light on my requirement by giving sales table name and fields for above formula ?

Look forward for reponse

Regards

Seshu

[Former Member · Accepted solution]

Take a help of Table MSKA - Sales order Stock.It will help you.

Best Regards,

Ankur