Hi,
As part of the monthly closing we are reconciliating GRNI report agains GL accounts.
For all our 9 sites we have every month small or bigger differences in these.
Have anyone figured out some easy way to reconcile these, there are so many transactions and therefor it’s difficult to find out where the differences come from.
Any suggestion is welcome as this is something we have been struggeling with since start of IFS, fist in IFS 7.5 and now in IFS 10 upd3.
Regards,
Anna
+9
Hi Anna,
Follow below points and perform the reconciliation to see if this makes a difference in the imbalance between GL and the report.
1. Schedule the report to run after end of play of the last date of the accounting period or any day you want to perform the reconciliation. (i.e. If you want to reconcile GL balance on 26th of November, then the report must be run after the close of business on that date, say mid night on 26th). Also need to use from date as the date before the first receipt and the until date as the date the report is run.
2. On the next business day, first thing in the morning
i. Check whether all the inventory transactions have been transferred and there are no erroneous postings.
ii. All the vouchers are updated to GL.
3. Then get the GL balance on GRNI account before any finance transactions take place such as matching of POs etc. on the next business day.
4. From the GL balance obtained in step, take off any effect of Non GRNI postings such as manual vouchers.
5. This is the balance to compare against the GRNI report ran on the previous day.
When the GRNI report is ran, it takes the current position of the receipts. For e.g. If you run the report on 27th Nov specifying until date as 26th Nov, and if a receipt is matched on 27th Nov by the time the report is run, the item will not be included in the report because at the time of running the report, the receipt is already matched. But as at 26th, from GL point of view this receipt is outstanding. So, there will be a discrepancy between these two figures.
Another example is if you run the report from 01/10/2021 to 31/10/2021 on 27th of November, then what will be shown in the report is the GRNI position on 27th Nov for the purchase receipts in October and not the net change in GRNI position in October.
Thanks & Best Regards,
Peshala
I was struggling with core GRNI report for long time and finally created quick report (SQL query) to present not invoiced receipts accounting-wise (considering voucher date of supplier invoice J vouchers and MPL/0 vouchers from inventory and purchasing).
This query (based on inv_accounting_row and MPCCOM_ACCOUNTING+PURCHASE_TRANSACTION_HIST views) presents all the lines with outstanding balance (grouped by common reference: PO no ^ Line no ^ Release no ^ Receipt no).
You may check this topic as well
The standard reports from IFS have some bugs which were open in IFS8. With scenarios of site moves, it gets more complex.
Hence, I would recommend to follow the solution suggested by Adam. We have also built our own quick reports and deployed robots(blueprism) to perform the reconcilation at month end.
In IFS10, life is more easy - using the matching info. on GL lines, we could extract the balance. But found a bug with milestones. Hope it would be solved soon!!!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
