cancel
Showing results for 
Search instead for 
Did you mean: 

Diff in Total tax in PO & MIRO

former_member184631
Contributor
0 Kudos

We have multiple line items in a PO with a tax liability of 5% on each line item

Total tax amount calculation in PO

Step1) 5% tax calculation

Step2) Rounding off

Step3) Summing the line item wise tax amount

Whereas during MIRO Total tax amount calculation is ,

Step1) 5% tax Calculation

Step2) Summing the line item wise tax amount

Step3) Rounding off

Due to this a marginal difference ( rounding off diff) gets generated between PO tax amount & Invoice tax amount.

How to handle such scenario so that total tax amount in PO & MIRO remains same.

Accepted Solutions (1)

Accepted Solutions (1)

former_member184631
Contributor
0 Kudos

Hi Al ,

Issue gets resolved by implementing below mentioned correction notes

2538979

2575538

Answers (3)

Answers (3)

former_member184631
Contributor
0 Kudos

Hi All ,

Would appreciate any inputs from your side to resolve this issue.

Thanks in Advance !!

B/r

Sachin

JL23
Active Contributor
0 Kudos

See OSS note 2370366 - Line item wise tax calculation happening even after switching it off in India customization setting - MIRO

Even it is a bug fix, which is actually contrary to your situation, it explains which customizing is responsible to control whether you calculate item wise or total in MIRO

former_member184631
Contributor
0 Kudos

Hi Jurgen ,

We are following UAE taxation procedure whereas this note seems to be fit for Indian scenarios.

But we still implement the same in our sandbox with no changes in Tax calculation process in PO .

Thanks

former_member183424
Active Contributor
0 Kudos

Rounding off for each line item in purchase order is not a correct way. Whatever is happening in MIRO, it is correct. You should configure the same thing for PO.

former_member184631
Contributor
0 Kudos

I have not configured anything for rounding off in PO. Can you pls guide from where I can configure rounding off rule in PO.

former_member183424
Active Contributor
0 Kudos

Then it might have been configured by your previous consultant. There are lot of documents are available in SAP community regarding the rounding off.

Just a note: Before changing anything, kindly consult with business team, your business team might had some scenario, where they required to do the rounding off for line item level.

former_member184631
Contributor
0 Kudos

Hi Dibyendu ,

As per my knowledge , we can round off by using 17 calculation type in the pricing procedure against relevant condition type. I checked the same , there is no alternate condition type formula linked to the pricing procedure

I also check with the respective condition type rounding off rule. It is configured as commercial.

I also check OB90 to identify the rounding off decimal places. there also we have not maintained any entry against our company code.

Apart from this is there any other config where we usually define rounding off rules for purchase order.

I tried to search net before posting but unable to find anything relevant.

Thanks !!

former_member184631
Contributor
0 Kudos

Just to give an insight of exact scenario , pls find below

PO Tax amount

former_member183424
Active Contributor
0 Kudos

You need to investigate why is the tax amount showing 217.38 in purchase order as it should be 217.35 (4347X5%). Can you post screen shot of tax amount for each line items.

former_member184631
Contributor
0 Kudos

Hi Dibyendu ,

System is calculating tax line item wise & round it off before summing the total tax for all items. Due to which this diff is coming.

For ex : below are line items in my PO

This is how PO is currently calculating tax . But i don't know from where I gets control .


former_member184631
Contributor
0 Kudos

Hi Dibyendu ,

In PO , system is calculating tax line items wise & round it off prior summing it up whereas in MIRO , system is calculating tax on gross amount & then round it off. Will explain you with example.

PO Line items are as follow

Calculation is taken place as mentioned below

This is how in PO system is calculating tax & I don't know from where it gets control.

Thanks