Finance | Project Operations, Human Resources, ...

Vendor balance value wrong displaying

(0) Share

Report

Posted on by mohammed hafeez

115

Dear Team,

I am facing issue with purchase order invoice amount and vendor amount different.

Recently i have created one PO and done invoice also.Please find below screenshots.

2388.pastedimage1590231804845v3.png

Invoice voucher screenshot

1106.pastedimage1590231780025v2.png

Now look into the vendor transaction screenshot

3276.pastedimage1590231862631v4.png

Voucher screenshot

7080.pastedimage1590231887394v5.png

In PO vendor invoice total material payable amount is::10,906,972.00

In vendor transaction total amount is :: 10,878,957.59

In vendor transaction voucher showing total payable amount is ::10,906,972.00

would you please explain why amount showing different.

Thanks in advance

All responses (6)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor balance value wrong displaying

Hello mohammed,

Many thanks for the update.

Can you let us know what AX2012 version you operate exactly and for which country/region?

I am asking this because there are a number of hotfixes listed on LCS that seem to address withholding tax related issues.

Whether those hotfixes apply depends however on the system version that you operate.

Maybe you can check that together with a system admin or development guy yourself on LCS to ensure that what you experience is not due to a system bug.

Best regards,

Ludwig
mohammed hafeez 115 on at

Like (0)

Report

RE: Vendor balance value wrong displaying

Hi,

I will explain more about voucher.

Accounts Payable - Material amount:: -10,906,972.00

TDS Payable- Contract - Company amount::-112,058.00

SGST Recoverable amount::: 840,434.50

CGST Recoverable amount:: 840,434.50

Cost of Project-Sub Contract amount :: 9,338,161.00

vendor transaction screenshot:

Voucher:

I have cross checked all deduction i have found only two deduction GST and TDS (withholding tax ).

for more details::

Vendor transaction list selected one having value mismatch.

And sub ledger ::
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor balance value wrong displaying

Good morning mohammed hafeez,

Just wanted to follow up on this one and ask if you have been able to get this issue resolved in the meantime?

Would be great if you could keep us updated.

Many thanks,

Ludwig
Suggested answer

SouravDam 11,723 on at

Like (0)

Report

RE: Vendor balance value wrong displaying

Hello mohammed hafeez,

Is there any Non-deductible % set in sales tax code which is recorded in this PO?

Looks like; the balance amount of (11019030.00 - 10906972.00) = 112058.00 is representing this non-deductible tax %.

Below screen shot is taken from D365 for your understanding.

If you can share some more detail on it as requested by other members; would be appreciable.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor balance value wrong displaying

Hello mohammed,

What is the AX2012 version that you operate?

Can you share details about the build number?

What I can see from your screenprints is a line for INR 112058, which seems to be responsible for the difference between the invoice total (10,906,972.00) and the invoice amount that you see in the first screenprint (11,019,030.00)

What does this amount represent?

How is it setup and how was it entered?

What is account 252404 to which this amount was posted?

Best regards,

Ludwig
MATTGUO 22,319 Moderator on at

Like (0)

Report

RE: Vendor balance value wrong displaying

Hi,

Does it have coustomization?

I saw the difference: 28014.41 = 10906972.00 - 10878957.59 is same as TDS difference: 28014.41 = 140072.41 - 112058.00.

Could you calculate if it is correct?

Can this case be repeated?

And moved this post to Dynamics AX forum: community.dynamics.com/.../microsoft-dynamics-ax-forum