Question
How to reconcile the Parts GRNI?
Answer
If required, please follow the following steps to reconcile the Parts GRNI figures. This ensures the postings are going through correctly.
Firstly, go to:
Accounts > Purchase Ledger > Reporting
Select the GRNI Tab, and ensure the report is set to ‘Parts Department Receipts’
If needed run the report in the date range specified in the Parts Movements Report and take the Totals from the bottom of the report, or just take the totals for a value from ‘all time’
Now you need to do a Parts Movement Report on every receipt and return in:
Parts > Reporting > Movements
Select ‘Movement Type’ as Receipt and the date range required and click Create Report
Print this to get the total cost value
Then do the same with ‘Movement Type’ Return
Minus the Return value from the Receipt vale to get the balance
This will need to be done for each Parts department under the Accounting Division to reach a total
Then go to:
Accounts > Nominal Ledger > Enquiry
Run an enquiry on the Parts GRNI Nominal for the Accounting Division for your dates, or for all time run the report from 01/01/1900 to 31/12/2068.
From here you will get the balance on the GRNI Nominal.
The balance of the Nominal Enquiry and the Parts Movements report need to match to the GRNI report balance.
If these do not match then you will need to check for journals on the nominal code, and for direct postings from the purchase ledger. These are not recommended for the GRNI nominal.
To check if there are journals posted to the GRNI nominal then in the Nominal Enquiry, select source as ‘Nominal Ledger’.
To check if there are direct postings then the source will need to be changed to Purchase Ledger, and each transaction will need to be checked to see if this was a GRNI posting or if it was as a result of a posting directly from the Purchase Ledger.
Also, you may need to check if any of the GRNIs have been deleted and not surrendered to the correct nominal code.