Skip to Content
author's profile photo Sebastian Hagen
Sebastian Hagen

Query - Goods receipt PO with serial no and bin location

Posted on Feb 27, 2017 at 10:59 AM 306 Views

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

goods-receipt-po-with-sn-bin.png (44.8 kB)
SAP Business One
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Muttia Khayyat
    Muttia Khayyat
    Posted on Jul 22, 2019 at 01:50 PM

    Hi Seba,

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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Sam B
    Sam B
    Posted on Jul 23, 2019 at 06:59 AM

    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,

    Add comment
    10|10000 characters needed characters exceeded