Hi Baqir Hussain 

I'm not understand your question but this is the principle that Sage X3 uses with GRNI in purchasing

1. When you receive stock that you purchase  -  a journal code STKRE is used. The journal will Debit your Purchase Account & Credit the GRNI Account.  These impacted accounts are set in  Accounting Codes

2. When you process the invoice from the supplier for goods received above, a journal code PIN is used. The journal will Credit the Creditors Control & Debit the GRNI & Tax account. And that closes the GRNI transaction.

3. If there is a purchase price variance, a journal will be created at invoice impacting the  GRNI account as well.

I hope that clarifies  & answers your question.

If it does please click on Verify answer

Hello BAKIR, indeed SAGE has specific queries for RNI, NRI and DNR, check SQL Requester/Query. And also specific reconciliation for GRN and Supplier Invoices, you need to configure this in accounting.

There is a training session in SAGE U where they deal with this, not sure if it is financials or distribution role.

Also on the Internet you find a couple of partners with relevant posts about this, like:

How to Setup Automatic Matching to Reconcile RNI in Sage X3 (rklesolutions.com)