Hi Anna

Which version of IFS Apps do you have?

The Collective Invoice is a different report from the normal Customer Order Invoice.  I checked the Document Text admin area and I do not see Collective Invoice in the documents listed, suggesting that it does not accept document text.  Someone else may know better than I do.

If that is the case, then to be honest an easier solution is to create a custom read-only field that assembles the data into a string at the shipment level; then add this to the report using Report Designer - no coding necessary.  Or instead of a read-only field you could implement a persistent field and put the data into that, given that you have already created the function.

Hope this helps.

Same question: Which version of IFS Apps?

I had a look at the source code for the Collective Invoice in Apps10UPD8 and in fact it does collect Document Texts from various places, including the Shipment header. If you check your resulting report XML data, there should be a section called SHIPMENT_DOC_TEXTS.

As Paul said, in Document Text Administration / Documents the Collective Invoice is not listed, but the report source code tells me the system considers Document ID’s 4 (Customer Order Debit Invoice) and 5 (Customer Order Credit Invoice and Customer Order Correction Invoice), so make sure you use an Output Type connected to these Document ID’s.

We are using Apps9 at the moment, but upgrading to 10 soon. Thank you for your suggestions! We’re just confused that the document text connected to the customer orders tied to a shipment, still shows up on the collective invoice but the document text attached to the header of the shipment does not. Great suggestions though. If we can’t get it to work as a document text output we will probably try a read only field so we can pull it into our reports.