If I have a difference on the Vendor Sub ledger to GL where sub ledger is more than the GL how can I post a credit note to remove the unwanted payable invoice from Vendor ledger without affecting the GL.
This is most likely the result of direct posting to G/L without using the Vendor. Thus, I would assume it would be more correct to:
- make verification and identify those directly posted G/L entries
- reverse those G/L entries (not Vendor entries via credit-memo!); so at that stage G/L and Vandor ledgers would match
- post entries again using Vendor so both ledgers will continue to match
In addition to what Alexander has mentioned, i would like to add,
There are some cases where posting entries against Vendor is not the practical solution, in that case just to make the ledger balanced, you can also create a dummy G/L Account and post your difference to it. It is not always a good idea but can be worth considering.
But if you can follow what Alexander has mentioned, then it should be all good.
Check whehter users are directly posting in GL account linked to vendor ledger
For correction follow Alexander suggestion
Thank you very much for your kind reply. I will reconcile this and let you know the outcome. Is there any easy way of reconcile the payable to GL in Dynamics GP it has a utility called reconcile to GL which will reconcile all invoices to GL automatically and give us the report.