Need help with Pick List calculations

68 Views

Hello,

i have a serious problem with the calculations in the pick list.

I try to rebuild the function for the calculation of "Open to Pick" and "Available to Pick".

I have found this entry in the SAP Business One 2007 help:

Open to Pick:

<the number of the ordered items per order line> u2013 (<delivered items per order line> + <released items in other pick lists>)

so i tried this (i know this is not valid SQL, i have chosen this representation to keep it simple)

RDR1.Quantity - ( RDR1.DelivrdQty + (select sum(RelQtty) from PKL1 T0 inner join RDR1 T1 on BaseObject = '17' and OrderEntry = DocEntry and OrderLine = LineNum where T0.PickStatus = 'R' and ItemCode = 'xx'' and AbsEntry <> 'xxx') - PKL1.PickQtty)

But this does not work correctly

For "Available to Pick" i tried this:

(SELECT OnHand from OITW where ItemCode = 'xx'' and WhsCode = 'xxx") - PKL1.PickQtty

There is also an error in this calculation.

Can someone tell me, how this two fields are calculated ?

It isn't visible in the Report and the values are not saved in the database.

Thank you very much for all your help.

Regards,

Mario