Skip to main content
Question

Inventory part barcode report does not have shop order number?


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?

4 replies

durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • 529 replies
  • 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;

 


Forum|alt.badge.img+8
  • Author
  • Do Gooder (Customer)
  • 33 replies
  • 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


Forum|alt.badge.img+9
  • Hero (Partner)
  • 48 replies
  • 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


Forum|alt.badge.img+9
  • Sidekick (Customer)
  • 142 replies
  • 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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings