Question Status

Verified
BABU BASKARAN asked a question on 20 Mar 2017 11:45 AM

Dear All,

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.

Reply
Verified Answer
Alexander Ermakov responded on 20 Mar 2017 3:21 PM

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

Reply
Verified Answer
Rabindra Sah responded on 20 Mar 2017 4:56 PM

Hi Babu,

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.

Reply
Verified Answer
Amol Salvi responded on 20 Mar 2017 9:39 PM

Check whehter users are directly posting in GL account linked to vendor ledger

For correction follow Alexander suggestion

Reply
BABU BASKARAN responded on 21 Mar 2017 7:50 AM

Dear All,

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.

Reply
Verified Answer
Alexander Ermakov responded on 20 Mar 2017 3:21 PM

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

Reply
Verified Answer
Rabindra Sah responded on 20 Mar 2017 4:56 PM

Hi Babu,

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.

Reply
Verified Answer
Amol Salvi responded on 20 Mar 2017 9:39 PM

Check whehter users are directly posting in GL account linked to vendor ledger

For correction follow Alexander suggestion

Reply