If we are trying to build a custom report that combines both Inventory and Non Inventory Received not yet invoiced items but are having difficulties. Would it be possible for to provide the logic behind the PDF report in IFS?
Question
Logic behind Received - Not Yet Invoiced Report
This topic has been closed for comments
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?
// 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. //
+21
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.