Query - Goods receipt PO with serial no and bin location

[former_member233738]

Dear experts,

i need a query to get some additional information to the goods receipt PO:

Fields:

- DocNum (goods receipt PO)

- item code (from item lines)

- manufacturer serial no (from SN transaction protocol)

- bin location (from SN transaction protocol)

Can somebody help me with this query over the virtual tables?

Thanks and kind regards,

Sebastian

[former_member610331]

Dear Sebastian Hagen,

So to understand your need, you need a query to get additional information from Goods Receipt PO and how do you wish to use collected data? For example, do you wish to place it in a text file, or some field within Sap Business One?

Regards,

[former_member565526]

Hi Seba,

If you got this query, pls share it with me.