Skip to main content
Question

Copying a field from one report to another


Forum|alt.badge.img+7

Is it possible to copy a field called shipment id from collective invoice report to normal invoice report and how ? I havent had the chance to work on reports that often so I could really use some guidance from the experts here 

3 replies

ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14
  • Hero (Customer)
  • 222 replies
  • April 7, 2022

Hello @amrflynn 

I do not know if I understood your question clearly.

What kind of report are referring to? IFS reports out of the box? Crystal or quick reports?

 


Forum|alt.badge.img+7
  • Author
  • Sidekick
  • 31 replies
  • April 7, 2022
ZTC ZTC JGOTA wrote:

Hello @amrflynn 

I do not know if I understood your question clearly.

What kind of report are referring to? IFS reports out of the box? Crystal or quick reports?

 

the ones we make in IFS Report designer


Forum|alt.badge.img+8

Hi,

I don’t know about copying but you can add a custom field fetching the shipment ID and then display that on the report layout

1. Make sure custom fields are enabled for the report


2. Find out what LU:s are connected to the report and decide where to put your custom field (block_xpath column = elements in the left tree in Report Designer)

select * from report_lu_definition_tab where report_id = 'CUSTOMER_ORDER_IVC_REP'


3. Add the custom field to the LU and fetch shipment ID with appropriate code. Make sure "Enable on Report" is ticked 

4. Open Report Designer, connect to your IFS Server and the custom field should be available to place on the layout


BR
Johan 


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