Vendor sub-ledger and GL out of balance

(0) Share

Report

Posted on by Shell

We have an issue in D365 where a vendor invoice is posting double the amount of GST to the GST ledger account and increasing the amount posted to the Vendor control account by the doubled GST amount.

Example

Vendor invoice $28.75

Expense $25.00

GST $3.75

The posting in D365 is as follows:

Expense/stock $25.00

GST $7.50

Vendor control $32.50

Vendor Sub-ledger

Vendor transaction $28.75

GST Sub-ledger

GST $3.75

This issue is intermittent, it has happened for a PO invoice, PO/project invoice, Vendor invoice with no PO. Issue has occurred with different users.

Has anyone had this issue before or may what could be causing it.

Thanks

Michelle

Categories:

Financial Management

All responses (16)

Answers (0)

ShahTanuj 330 on at

Like (0)

Report

RE: Vendor sub-ledger and GL out of balance

Hi Michelle ,

Can you please let me know how did you resolve this issue, We are facing the same issue in vendor invoice and not able to replicate in lower environment.

I know its been a long time but It would be really helpful if you can recall and reply on the same.

Thanks

Tanuj
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor sub-ledger and GL out of balance

Hi Michelle,

You are right, MS will ask you to replicate the issue and if you can't it might be difficult for them to help.

Do you have a developer at hand who can help you doing some deeper investigation of the issue?

Maybe a specific modification or configuration that hits only every now and then is responsible for the outcome you see? A developer should be able to have at least a look at that in my opinion.

Best regards,

Ludwig
Shell 10 on at

Like (0)

Report

RE: Vendor sub-ledger and GL out of balance

Hi Ludwig

I haven't been able to find a hotfix that looks the same as this issue.

The reason I haven't logged the issue with Microsoft is because I can't replicate it, it just happens it seems randomly. I suspect Microsoft first question would be how do they replicate it and if I can't they probably won't help past that.

Thanks

Michelle
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor sub-ledger and GL out of balance

Hello Michelle,

I would recommend that you have a look at the available Hotfixes on LCS.

The behavior that you see might be caused by a System bug.

I found some Hotfixes that might fit (see the next link) but you need to double check and investigate with a developer.

fix.lcs.dynamics.com/.../Results;dm=0&v=1_2_8&i=2_1_3_4&ct=1_3_5_4_2_6&ft=1_2_3&cu=&pi=&pm=&pc=&rd=&d=&envId=&permission=&x=0&y=0

If you can't find a suitable fix there, I would recommend that you get into contact with the MS support.

Best regards,

Ludwig
Shell 10 on at

Like (0)

Report

RE: Vendor sub-ledger and GL out of balance

Hi Zvika

Here are screenshots of the voucher, transaction origin showing sub-ledger postings and Vendor transactions

Thanks

Michelle
Shell 10 on at

Like (0)

Report

RE: Vendor sub-ledger and GL out of balance

Hi Ludwig

Yes the variance is shown on the ledger reconciliation reports.

Thanks

Michelle
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor sub-ledger and GL out of balance

Can you also run the ledger reconciliation reports? I wonder if they actually show a variance.

Best regards

Ludwig
ZvikaR 140 on at

Like (0)

Report

RE: Vendor sub-ledger and GL out of balance

Try posting a screenshot of the GL voucher, and a screenshot of the sub-ledger posting from the "Posted VAT" form. Maybe by viewing the specific details of this particular transaction we would be able to tell what is wrong.

It is highly unlikely Dynamics throws off the sub ledger and ledger off balance just like that. Had anything been customized with this?
Shell 10 on at

Like (0)

Report

RE: Vendor sub-ledger and GL out of balance

Hi Zvika

The posted GST inquiry shows correctly, amount origin = $25, calculated GST amount = $3.75, Actual GST amount = $3.75.

It seems to be the GL that has the incorrect posting, the sub-ledgers are correct.

Thanks

Michelle
Shell 10 on at

Like (0)

Report

RE: Vendor sub-ledger and GL out of balance

Hi Daxer

There is no allocation setup on the main account and I can't replicate the issue by doing the same transaction to same main account.

Thanks

Michelle