Skip to main content
Solved

RNI report and RNI Account varience

  • December 29, 2021
  • 3 replies
  • 435 views

Forum|alt.badge.img+9

Dear experts,

From June 2021 onwards, there was a difference between the Goods received Not yet invoiced (GRNI) report for the inventory part and the GRNI-Inventory part Account . 

 

GL Balance

   25,379.35

GRNI Report

   24,319.75

Difference

     1,059.60

 

The reason for this difference was the below voucher. 

 

 

 

Could anyone of you suggest the possible reasons for this issue and the way to resolve it? Thanks in advance. 

Best answer by Rasika Lakmal

@XitThejaG when you receive a PO receipt, it will credit the M10 posting and until you invoice the receipt, the receipt will appear in the RNI report. Once you create a manual supplier invoice, it will debit the M18 posting and purchase receipt will disappear from the RNI report as the close date is updated in the receipt. In this scenario, M10 + M18 = 0  and it’s the reason why the receipt is not showing in the RNI as there is no balance and closed date is updated. However, if user manually updates the close date in receipt without creating a manual supplier invoice, there won’t be M18 posting creating and M10 value move forward and balance will appear in GL. This is the one of the scenario that can be happened but there can be more.  

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

3 replies

Rasika Lakmal
Superhero (Customer)
Forum|alt.badge.img+18
  • Superhero (Customer)
  • 214 replies
  • Answer
  • December 29, 2021

@XitThejaG when you receive a PO receipt, it will credit the M10 posting and until you invoice the receipt, the receipt will appear in the RNI report. Once you create a manual supplier invoice, it will debit the M18 posting and purchase receipt will disappear from the RNI report as the close date is updated in the receipt. In this scenario, M10 + M18 = 0  and it’s the reason why the receipt is not showing in the RNI as there is no balance and closed date is updated. However, if user manually updates the close date in receipt without creating a manual supplier invoice, there won’t be M18 posting creating and M10 value move forward and balance will appear in GL. This is the one of the scenario that can be happened but there can be more.  


Forum|alt.badge.img+13
  • Hero (Employee)
  • 150 replies
  • December 30, 2021

Hi @XitThejaG,

As Rasika mentioned there may be not posted vouchers in the hold table which is relevant to M10 & M18 postings. Additionally I suggest you to check on M14 posting also as it should goes to same account when we are matching GL balances with report. 

 

Also please check the postings (M189 & M187) relating to PO chargers if your customer update PO chargers in the Purchase order.  Above report not shown details relating to PO chargers. If you have matched PO chargers also to the same account it may cause for difference between GL and report. 

Best Regards

Narmada

 


Forum|alt.badge.img+9
  • Author
  • Sidekick (Partner)
  • 87 replies
  • March 9, 2022

@Rasika Lakmal  and @Narmada  Thanks a lot for your support.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings