Reconciling Received Not Invoiced Account to RNI Report

We have a discrepancy between our RNI Account in the GL and the RNI Report from month end performed by Supply Chain. We suspect that the difference is on the GL side, but it is a dollar amount that does not match one transaction. It's likely the combination of a few. Anyone have some good tips for finding out what caused it and identifying the records? Thank you!

Find more posts tagged with

Accepted answers

All comments

unknown

I'm not sure it's good but I am finalizing a process to reconcile our RNI account to our report. We have variances all the time and it has been nearly impossible in the past to reconcile. High level I compare the RNI report from the current month to the RNI report from the prior month. I run a query on GLTransactionDetail for the RNI account for the current month (make sure you include the PO number in the query). Then I do a compare to find the variances. It is all formulated so it doesn't take too long to do anymore. Feel free to reach out if you have more questions.

Stace Webley

That would be much appreciated. My email is patrick.webley@confluencehealth.org. Would you mind sending your query and steps for comparing the account and reports?

unknown

I would like the query and steps also. My email is jhines@vanwerthealth.org.

Thank you!

lawrence-miloscia

May I ask you to please send me your query and steps as well? Thank you very much.

E-mail: lawrence.miloscia@ehmchealth.org

connie-heitman

I also would like your query (and steps, but I think I understand for the most part). Thank you so much for sharing! connie.heitman@promedica.org

unknown

Can I get the query and steps as well? Thanks.

unknown

Hi All - I haven't built out instructions yet but was planning on doing that when I reconcile January as I need to build the instructions for internal use anyway. I plan to finish this up by mid next week and as soon I have have everything written up, I will share with everyone.

Stace Webley

Thank you very much!

jcaron

Thank You. Can you add me to your list for distribution jcaron@northernlight.org?

debbisue-kimbler

Please include me as well. debbisue.kimber@christushealth.org

unknown

My email is jack.jackowski@phhs.org

kiara-sonza

Thank You! Can you add me to your list for distribution as well stafol@childrens.com

onyia-godwin

Please include me as well godwin.onyia@bhb.bm

jennie-granberg

Thank you Kate. I would be interested in this information as well. jennie.granberg@bellin.org

Stace Webley

There is so much interest on this topic that I bet we could get an enhancement request to go a long ways. I'd be happy to write it up and share it here for votes. Any ideas people would be willing to share on what they'd like to see in the application for this function?

andy

Agreed, based on the responses definitely seems like at the minimum it should be a topic for an Ask The Experts session. Could submit it as a question for the upcoming Core Financials session next Thursday Feb. 24th, but it might be beyond scope of that call since this is more in the realm of Matching.

unknown

Hi - I actually have a meeting setup with Infor to review what I have done so they can determine if it is something they can build into their code/process. This conversation is what initiated that meetings so great job everyone!

unknown

HI All - quick update since I haven't gotten this out to you yet. I was sick this week so I'm a bit behind. I have completed the documentation and have my co-worker following the steps to make sure it makes sense to someone other than myself and that I didn't miss anything. I will send it out via email early next week to everyone who included their email on the thread.

unknown

Please include me too at kbyrnes@kh.org and thank you!

unknown

Please include me. angie_iley@valleymed.org. I'll distribute to the application analysts. Thank you.

unknown

Good Afternoon Everyone,

Below are some tools and queries that I provide to clients when trying to reconcile RNI accounts. In my experience there are 2 portions to this reconciliation:

1) Verifying the amounts produced by the PO System ReceivedNotInvoiced month-end accrual job for non-inventory items:

To verify the amounts produced by the month-end accrual job you will need to compare the ReceivedNotInvoicedReport output to the GeneralLedgerTransactionDetail. Filter out the Inventory items on the ReceivedNotInvoicedReport output and it should match to the amounts posted to the GL for the month-end accrual. To isolate the RNI transactions on the GeneralLedgerTransactionDetail create a report with the filter shown below. You will need to replace the "<RNIAccount>" value with your organizations RNI account. You can further filter the list by entering the post date for the specific period you are attempting to reconcile.

(FinanceCodeBlock.GeneralLedgerChartAccount = "<RNIAccount>" and Reference = "ReceivedNotInvoiced")

2) Reconciling the amounts posted by the PO and AP Systems for Unmatched Inventory items:

As Inventory items are received during the month they will post the RNI account from the PO System. These amounts will eventually be cleared by the AP System when an Invoice is matched to the Receipt. To isolate the amounts posted to the RNI account for inventory items create a report on the GeneralLedgerTransaction Business Class with the filter shown below. You will need to replace the "<RNIAccount>" value with your organizations RNI account. You can further filter the list by entering the post date for the specific period you are attempting to reconcile.

((FinanceCodeBlock.GeneralLedgerChartAccount = "<RNIAccount>" and System = "PO" and Reference != "ReceivedNotInvoiced") or (FinanceCodeBlock.GeneralLedgerChartAccount = "<RNIAccount>" and System = "AP"))

The balance in the GL Account should equal the balance of the non-inventory transactions in Step 1 plus the Net Balance of the transactions in Step 2.

connie-heitman

Hi John! Your steps determine each part of the GL transactions, but the account balance should tie to the RNI report and that is where we have issues. We have determined the non-inventory items on the report match the month end entry produced by the PO system, but we have differences between the change in the report for inventory items and the entries in the GL account. Kate has provided her steps to systematically compare changes in the report to the GL transactions. Any other suggestions?

gtesche

Sorry for the late response, but if you wouldn't mind sharing with me as well, I'd appreciate it. gtesche@pennstatehealth.psu.edu

unknown

Kate, Can you send me the completed documentation? Somehow I missed it. Thanks. jack.jackowski@phhs.org

Prakash Shrestha

Maybe you have already discovered but I just wanted to share my findings that the differences between the GL and the report are mainly caused by: 1. Catchweight items not dropping off the report even after clearing the GL and 2. Timing: There are some transactions where the AP entry to clear the RNI occurs within the current period but the matching that happens to drop those lines from RNI occurs in the next GL period. So, they stay in the report even when the GL is whole.

lisa-cox2

Shrestha, thanks for reactivating this discussion. We are able to tie out our non-inventory RNI to our RNI accrual report, but we are having problems with a large and growing balance in the inventory transactions in the GL that aren’t being relieved by the AP entries. These amounts don’t tie to the inventory items in the RNI report. Supply Chain has been unable to provide a report that ties out to the inventory postings in our RNI account. This has become an audit issue. Do you have any suggestions on how to resolve this issue?

Copyright © 2025 Infor. All rights reserved.