Skip to main content
Question

Inventory part barcode report does not have shop order number?

  • June 5, 2020
  • 4 replies
  • 259 views
S
Do Gooder (Customer)
Forum|alt.badge.img+8

We are trying to customize the Barcode Label report which can be executed from the Shop Order screen:

 

The problem is when looking at the database to see the database view INVENTORY_PART_BARCODE, it does not contain the shop order number.  I am a little confused why this key information is missing.  Does anyone know how to link back to the shop order number for a report like this one?

    N

    4 replies

    durette
    Superhero (Customer)
    Forum|alt.badge.img+19
    • durette
    • Superhero (Customer)
    • June 5, 2020

    I think this is the JOIN you want:

     

    SELECT ipb.*, soo.order_no

      FROM inventory_part_barcode ipb

      JOIN shop_order_operation soo

        ON soo.barcode_id = ipb.barcode_id

       AND soo.contract = ipb.contract;
     

    If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
    S
    Do Gooder (Customer)
    Forum|alt.badge.img+8
    • svrmhuebner
    • Author
    • Do Gooder (Customer)
    • June 5, 2020

    Hello Durette, thanks for the information, but for some reason when using the join barcode_id and contract, I am not getting correct shop orders to line up.  Could this be a IFS bug? Thanks, Mark

    I
    Hero (Partner)
    Forum|alt.badge.img+9
    • IC-LukaszP
    • Hero (Partner)
    • June 9, 2020

    Hi,

    Is the manufactured Part on your SO header Lot Tracked? If it is, you may find connection between Barcode ID and SO through “Lot/Batch” tab on SO. 

    Key: contract, part_no, lot_batch_no. It might be many (barcode id’s) to one (so) relation, in case:

    a) using many lots per order

    b) having std pack size smaller then lot size (highly possible)

    BR, Lukasz

    Lukasz Pietrzak || Lead Business Consultant at InfoConsulting
    E
    Sidekick (Customer)
    Forum|alt.badge.img+10
    • Ed22
    • Sidekick (Customer)
    • March 7, 2025

    Hello, I have simillar question. I need add in INVENTORY_PART_BARCODE_REP column FROM TRANSPORT_TASK_LINE_EXTENDED, or TRANSPORT_TASK, and also some columns FROM RECEIPT_INFO it is possible? Because only common colums´which have this two tables is part_no, but I think that is not sufficient

    Terms & ConditionsCookie settingsAccessibility statement