Hi,

With a quick look in to purchase_receipt_rpi, it seems there is long code for selecting inventory part PO lines, taking away already invoiced values (invoice and voucher details checked), substracting returns, considering conversion factors, checking if supplier is representing the company of the site ...etc, and equally long and complex (for my eyes) code for non-inventory parts. It does not seem like an easy job to have IFS identical code in a custom report.

Can I know what you want to achieve by adding both together in one report? 

@AsankaGaru Please find the answer from the customer on above query. 

// This is a request from our Finance and AP department to help with timely month end reconciliation.  Both inventory and non inventory are in the same GL account for us and we also have 10+ companies to reconcile each month.  So currently the have to run 2 reports for each company and combine into excel to reconcile.

Also the PDF report is useless to us so the desire is to have a combined excel report. //

Hi @Praveen Kumarasinghe ,

The received not invoiced report is pretty complex we required a spreadsheet as well so we defined an RPL file to produce the Excel file and we developed a simple Excel template which the RPL file uses.  If you go to report definitions and located the PURCHASE_RECEIPT_REP report you can add the RPL file to the layout.   Choose Excel Layout for the layout title and Other Plugin for the layout type.

You install the Excel template under the Report Layout Templates.

We changed the excel output to be our default layout for this report and you can do that by changing the layout order in report definition screen.   

Regards,

William Klotz

Hi All,

Thanks for the replies.

Regards,

Praveen