Hi all
Is there a way to get this report into Excel, rather than a PDF? We don’t have the business reporter function ready yet and I can’t interrogate this report if it’s in PDF format.
Thanks
Best answer by Ruchintha Samararatne
View original
This topic has been closed for comments
Hi
As I’m aware, there’s no clear direct way to achieve your requirement from IFS applications side, unless you have the database level access or may be the business reporter function as you have suggested.
But, having said that, I can suggest you a workaround which you can try yourself and see whether it works or not. But it definitely has some manual work to be done.
- Generate the report
- Go to Report Archive
- Find the correct result key record.
- RMB → Get Xml Data and save the xml data file.
- Try to import that to excel (You may need to do some data cleansing steps)
Try this and see whether if that helps!
Please note that this workaround is suggested only to extract the data for reconciliation purpose. Not an official export into excel.
We just went the full quick report route and select the info from the Report Archive
Here is the SQL to make it quick for you (V9 UPD13):
SELECT rep.result_key,
rep.row_no,
rep.part_no,
rep.description,
rep.company,
rep.contract,
rep.vendor_no,
rep.arrival_date,
rep.order_no,
rep.line_no,
rep.release_no,
rep.receipt_no,
pr.receipt_reference,
rep.qty_to_invoice,
rep.buy_unit_meas,
rep.qty_to_invoice_conv,
rep.cost,
rep.unit_meas,
rep.value,
po.currency_code,
rep.to_date,
rep.part_type,
rep.invoicing_supplier,
rep.invoicing_supplier_name,
rep.normal_block,
rep.shipping_date,
rep.exchange_block,
rep.price_difference_block,
rep.trans_based_block,
rep.order_type
FROM inst1app.purchase_receipt_rep rep
LEFT JOIN inst1app.purchase_receipt_new pr
ON rep.order_no = pr.order_no
AND rep.line_no = pr.line_no
AND rep.release_no = pr.release_no
AND rep.receipt_no = pr.receipt_no
LEFT JOIN inst1app.purchase_order po
ON po.order_no = rep.order_no
WHERE rep.result_key = '&[-C-BL]Result_Key'
ORDER BY rep.result_key ASC, rep.row_no ASC
Comments:
Enter Result Key of GRNI Report from Report Archive
Steps to import the xml into excel:
Userlevel 7
+21
Hi
Have you considered creating a report definition plug-in to produce an Excel output of the Received Not Yet Invoiced. There is documentation in the IFS F1 foundation documentation. Here's a link to a discussion about the Excel Plugin and how to go about creating and using it.
Regards,
William Klotz
Thanks, everyone. I’ve managed to get it working through a mix of the points above and help from my IT department. Thank you all very much.
Hi
Have you considered creating a report definition plug-in to produce an Excel output of the Received Not Yet Invoiced. There is documentation in the IFS F1 foundation documentation. Here's a link to a discussion about the Excel Plugin and how to go about creating and using it.
Regards,
William Klotz
This is the correct answer, once you get it working it’s the nicest solution by far.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.