picklist fulfilment percentage

[Former Member]

hi all

I would like to be able to access the fulfilment percentage that you see on the pick and pack manager for an order on sales orders. basically, I want to have a formatted query that will allow the sales person to see what the fulfilment percentage is with a query. is this possible? if so, how can I do this?

kindly advise.

thanks!

prem

[Former Member]

Prem,

It is possible with a Stored Procedure. First, the stored procedure needs to identity all open line details (RDR1.LineStatus='O') where pick ticket is not created (RDR1.PickStatus='N')

Then you evaluate above data and check if Items are available (OITW.OnHand - OITW.IsCommitted) and determine percentage.

[kothandaraman_nagarajan]

Hi,

Your requirement is not clear. Please explain with an example.

Thanks & Regards,

Nagarajan