We have a customer in Germany that requires .xml reporting for invoices. We tried using a .rdl report from IFS to generate the .xml successfully. However, the report shows our Parent US company name on it and not our subsidiary from Europe. Even though the invoice is for the other Company (FR200)in IFS. How do we update/fix the .rdl to have the Europe company name on the report instead of US?
Best answer by william.klotz
View original
+21
HI
Have you verified the subsidiary name is exposed in the Invoice “RDL” file? It could be the subsidiary name is available but not placed in the report layout. It’s also possible the subsidiary name isn’t exposed in the underlying PL/SQL code and would need to be retrieved and exposed in the underlying “*.RDF” file which contains the Oracle package.
If you find you have to modify the PL/SQL code of the invoice report to add the name to the XML output you would use something like this Xml_Record_Writer_SYS.Add_Element(xml_,'COMPANY',company_); to write the data out and include it in the XML file.
We’ve customized many of the built-in reports from IFS over the years some are simply just an update to the layout to expose a new data field others we have to add code to to the underlying PL/SQL code to and add the new data to the XML and data model so we can expose the new field in the layout.
The first step is to see if the underlying data you need is already retrieved in the P:L/SQL code and just not sent to the XML and exposed to the report designer.
If you do not have experience modifying the built-in reports and their underlying PL/SQL code you may want to reach out to IFS or an IFS partner to get assistance with the implemenation.
Regards,
William Klotz
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
