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?
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;
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
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.