Skip to main content
Question

Problems with CF

  • February 19, 2025
  • 3 replies
  • 78 views

Forum|alt.badge.img+10
  • Sidekick (Customer)

Hello,

 

how can I add new CF in INVENTORY_PART_BARCODE_REP table? I want add new CF which is located in TRANSPORT_TASK, however I cant find any common key for this two tables?

 

Thanks

3 replies

Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • February 19, 2025

Sorry, its CF in TRANSPORT_TASK_LINE_EXTENDED and the final table is INVENTORY_PART_BARCODE_REP


PhillBronson
Hero (Customer)
Forum|alt.badge.img+11
  • Hero (Customer)
  • February 19, 2025

The tables ending in `_REP` are created through IFS Developer Studio report creation process. If you need to add custom fields then here is APPS10  documentation (based on your tag) https://docs.ifs.com/techdocs/foundation1/040_administration/250_operational_reporting/130_custom_fields_in_reports/default.htm
 

IFSCloud 24R2 documentation Custom Fields in Reports - Technical Documentation For IFS Cloud

 

While this doesn’t answer your question directly, you would have to use this process to understand the report model. This will let you know if you can add the fields from TransportTaskLine


 


Forum|alt.badge.img+10
  • Hero (Partner)
  • February 19, 2025

The barcode report (INVENTORY_PART_BARCODE_REP) is used to print a label to put on an inventory item or the container holding it. It’s intended to follow the stock item around, which of course can be moved several times by different transport tasks. Therefore, it doesn’t make sense pulling data from the transport task line to the barcode label.

What are you trying to achieve here? Printing of a document with barcodes to accompany a transport task or something?