Skip to Content
0
Apr 25, 2018 at 12:12 AM

I need some B1 Query help regarding OPKL and ORIN

315 Views Last edit Apr 25, 2018 at 12:13 AM 2 rev

Hi,

On the OPKL (Pick List) table - I have these two UDF's:

U_Picker

U_Packer

These UDF's also exist on the ORIN (AR Credit Memo) table.

I need to develop the below report:

+++++++++++++++++++++++++++++

Variable selection: U_Packer and date range:

+ Packer

+ No. Orders Picked

+ No. Lines Picked

+ No. Items Picked

+ No. of credits - Orders

+ No. of credits - Items Qty

+++++++++++++++++++++++++++++

Can the OPKL and ORIN tables be joined - and if so, how would I go about doing this?

Cheers

Rick