Finance | Project Operations, Human Resources, ...

Vendor Reconciliation Report Have Difference Between Vendor Balance and Ledger Balance.

(0) Share

Report

Posted on by Adhha Adnan

420

Hi All,

When i run the Vendor Reconciliation report.

Notice that some Vendor Balance and Ledger Balance does not tally.

Example: Vendor Balance $5300 Ledger Balance $0 so there is difference of $5300 and vice versa.

Sample Report

I also make some comparison, not too sure with the posting so I could not identify what is the problem.

In addition, I notice some other person also having the same issue but I could not find any solution given.

Appreciate suggestion and solution for my issue here.

I have the same question (0)

All responses (4)

Answers (0)

MATTGUO 22,349 Moderator on at

Like (0)

Report

Hi Adhha Adnan,

There is a reason that the account of posting profile has changed.

Was this reply helpful? Yes No
Adhha Adnan 420 on at

Like (0)

Report

Hi MATTGUO,

From my checking, those transaction that have difference do have changed of profile posting.

In this case, how do we balance out the vendor balance and ledger balance?

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report

The report logic is to select the account from profile posting to reconcile.

Please check if the difference disappear after the account of profile posting is changed to original account.

If so, please ignore the difference. Or reverse these transactions and recreate them in current account, but it seems impossible.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Adhha Adnan,

The transaction details that you shared are opening transactions.

Are they the result from transferring balances to AX?

I have seen companies making those transfers with a special posting profile that is later on 'retired' or sometimes changed.

Do you know if those accounts are still used or are they deactive/put on hold?

From your screenprint above I would expect that not all transactions are related to opening transactions and that people might have change posting profile settings.

Do you know why this has been done?

To get this corrected you could re-establish the posting profile settings from before, correct the postings the same way as they have originally been recorded, change the posting profile again according to your current needs and post things correctly. This involves, however a lot of work and we need to understand first why those changes to the posting profiles have been made.

Would be great if you could find out and clarify.

Thanks,

Ludwig

Was this reply helpful? Yes No