"Price include tax" is not taken into consideration in purchase requisition

(0) Share

Report

Posted on by Community Member

Dear All,

In vendor master data, I selected the check box of "Price include tax", and set up tax code as 17%.

I create purchase requisition for this vendor, when I check the "Total amout" of this PR, I noticed that the tax was calculated again.

One example, I want to buy 1 Pcs of item A form vendor V1 with price 100, so the total amount is 100 (include tax amout 17). But in my PR, I found the total amout is 117.

And after I created PO from this PR, I noticed that the checkbox "Price include tax" is clear. So the amout was the wrong value 117, not the right one 100.

I tried to create PO directly for vendor V1 directly, then the checkbox was selected as default.

Please help me!

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

Some screenshots:

1. Vendor master data

2. The tax and amount in PR

3. In purchase order headview (The PO was created from PR)

My AX version: R2 CU6

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Leamon,

How is the sales tax code that results from the combination of the sales tax group and item sales tax group setup?

Can you check how the calculation of the sales tax is setup and whether this might be the issue in your case?

Ludwig

Was this reply helpful? Yes No
okarnaukhov 118 on at

Like (0)

Report
Copy link

Link copied!

I am facing the same issue. Can you share an update on your case?
Thanks

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report
Copy link

Link copied!

you need to check

item sales tax codes and tax group

check vendor setup also

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi all,

I am facing the same issue working on AX 2012 R3 version. Does anyone have any explanation? It seems that the vendor setup only apply to purchase orders, not to purchase requisitions.

Thank you,

Serena

Was this reply helpful? Yes No
Suggested answer

ZvikaR 170 on at

Like (0)

Report
Copy link

Link copied!

I suspect your root cause is in the purchase requisition not inheriting the "price include sales tax" flag from the vendor

Since the PR shows a wrong amount, AND the purchase order is created the flag is not set up.

I verified the mechanism works for creating a PO directly - so I don't think there is anything wrong with your sales tax/item sales tax group/sales tax code configuration.

The focus should be why the PR total is 117 and not 100.

I SUSPECT that since the PR does not have vendor on the header, but it is not a vendor specific entity, it does not inherit the vendor settings - but I did not look into this in detail.

Was this reply helpful? Yes No
MatthewGower 75 on at

Like (0)

Report
Copy link

Link copied!

Has anyone found a solution for this. The VAT codes and groups do not have any settings related to this issue. The vendor master record is setup correctly yet it still calculates the VAT incorrectly.

Was this reply helpful? Yes No
Suggested answer

John Ray Patajo 837 on at

Like (0)

Report
Copy link

Link copied!

Even though Price Include Sales Tax is set-up on the Vendor Data, the PR, with Salas Tax Group and Item Sales Tac Group, as a transactional data, when it is converted to PO, it will set to NO for Inclusive of Sales Tax.

Hoping for a future enhancement for Microsoft regarding this.

Was this reply helpful? Yes No
Ehab_altammam 150 on at

Like (0)

Report
Copy link

Link copied!

Hi ,

i thought it would be helpful to check the code , so i just quick scan the Class PurchAutoCreate_PurchReq ..... that create PO from the PR ....

and found that inclTax is always set to false in this case !!! .... i didn't replicate the fill process or debug the whole process ... but i believe there is a reason why it sets to false

Was this reply helpful? Yes No