Received - Not Yet Invoiced Report

Hi @DerekD,

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.

1. Generate the report
2. Go to Report Archive
3. Find the correct result key record.
4. RMB → Get Xml Data and save the xml data file.
5. 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

Hi @DerekD ,

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.

This is the correct answer, once you get it working it’s the nicest solution by far.