Invoice amount more than PO

[Former Member]

Dear experts.

I have created PO and  GRN also done, both are correct but in MIRO i am getting more than PO amount.

Please guide how it is picking more amount in MIRO.

For ref pls find the below screen shot.

PO

GRN

MIRO

Thanks in advance.

[former_member183424]

I can see your GR/IR amount credited as 125610.96 at the time of GR and its also debited 125610.96 at the time of IR. But you've paid to vendor only 118334.28. So the price difference amount has gone to material inventory account (because material stock still there).

And as the transaction/event key EIN and EKG hits at the time of GR, so system adjusted the amount because of price difference (GR/IR and Vendor payment).

[Former Member]

Thank you for your reply,

I could not changed the amount in MIRO, just i had entered the PO number number in MIRO and selected calculate tax tick mark and i was clicked on simulate and the below entries are appearing.

PO and GRn amount should be fetch to the MIRO and my question is why the difference amount

[former_member183424]

Check your PO price changes log.

Go to ME23N, select the line item.

[Former Member]

Dear dev,

I checked there is no changes in PO items, it is showing blank

Regards,

HHC

[former_member183424]

No. You are missing something. As you can see you have the GR/IR credited amount is 125610.96. But it flows in MIRO with different amount.

Can you please share a screen shot of your purchase order history ?

[Former Member]

Thank you for reply

pls find the below screen shot POH

[ajitkumar]

Are you using the same tax code in MIRO as in PO?

the difference seems to be in calculated tax

[Former Member]

Hi Ajit,

Thank you for rerply

Yes i am using same Tax code in PO and Invoice also i.e. P1

I am not getting why difference amount is coming in MIRO,

Regards,

HHC

[former_member183424]

There are something problem in TAX calculation.

At the time of GR, system talking the amount for condition type ZTTX. But at the time MIRO, system is not talking the amount.

[Former Member]

Hi Dev,

As you said may be problem in tax procedure.

Can you assume what are the mistake done in Tax procedure for this difference

Thanks

HHC

[former_member183424]

Sorry. I am little poor about tax procedure. Lets wait for other member's reply.

[Former Member]

Ok, thanks for your reply..

[ajitkumar]

pl check the percentages maintained inside the tax code.

it might've changed between your MIGO and MIRO

[Former Member]

Hi Ajit,

I checked but no changes done in Tax code

Regards,

HHC

[Former Member]

It is not about changes to the tax code but the different rates maintained against the tax condition types (FV11). These rates are taken on the posting dates of MIGO and MIRO. If the rates have changed in the meantime, the tax calculated will be different.

In your PO the non-deductible taxes are 9710.96 whereas it is only 2434.28 in MIRO. The difference in the calculated taxes is going to your stock account.

Check if you are using the right tax code in MIRO and the tax amount actually matches the vendor invoice. If yes, check the tax rates against P1 in FV11.

[Former Member]

Hi,

Thank you for valuable reply..

Same material of another PO,

PO-Non deductible tax is 8248.28,

i have got 1 doubt here 2434.28 only picking in MIRO tax rate (CST against c form)(Pls check both screen shot)

MIRO entries of above PO

Non deductible tax is 8248.28 -2434.28 = 5814 (i need, total 8248.28 tax should come in MIRO tax tab that is we are paying to vendor)

May be i have done wrong tax procedure..what could be changes required in the Tax procedure.

[ajitkumar]

pl check note 1559145

from the note

Q. System does not bring correct excise duty as posted in the excise

invoice.

       A. For TAXINN # Check if the conditions are classified

correctly without any duplicates. The same applies for VAT.

          For

TAXINJ # Check if the appropriate routines such as 354 for BED, 364 for ECS and

SECS are assigned

[Former Member]

Has Part II been posted in J1IEX/MIGO before you are doing the MIRO? Check in J1I7 with your material document number.

[Former Member]

Hi

Thank you for reply

i have seen in MIGO - miscellaneous status is posted and J_1IGRXREF table also having the status posted.

BED AED are zero showing in J1i7

In MIRO tax tab coming 0, after selecting calculate tax tab.

is there anything wrong in tax procedure??

[Former Member]

What tax procedure are you using -TAXINN or TAXINJ? Post a screenshot of your procedure.

It may also be that your invoice was wrongly captured and posted. Do you capture and post in MIGO? Or capture in J1IEX and refer in MIGO?

MIRO is picking up values in your excise invoice ('0' excise), there is nothing wrong there.

[Former Member]

Hi,

Tax proc- TAXINN..(pls check screen shot)

Captured in MIGO  and posted in J1IEX

JMIQ(BED) ,JEIQ(Edces), JSEQ (SEdces) and JSIQ (SED) i have taken quantity base Condition type. NON-CENVAT excise duties

)

[Former Member]

What does requirement type 952 do?

Is the tax calculation accurate in the PO?

Have a look at the following notes:

1708408 - Non deductible tax calculation and display problem in MIGO

764009 - Incorrect excise account posting for capital goods - MIGO

[Former Member]

Hi,

Thanks a lot i will check the mentioned notes.

Type 952 is 2% against c-form. Tax calculation is accurate, no doubt about that.

Why the Inventory account and Purchase account is appearing in MIRO

Tax + net price we should pay to vendor but in my case in GRN is correct and  while invoice tax price is excluding.

[Former Member]

Hi,

Tax procedure is correct or wrong because JMIQ(BED) ,JEIQ(Edces), JSEQ (SEdces) and JSIQ (SED) i have taken quantity base Condition type. NON-CENVAT excise duties

JMIQ,JEIQ, JSEQ and JSIQ have taken NVV account key (is it right??)

JVCS condtion type account key is JP4,

if i click on calculate tax in MIRO, JVCS tax amount only picking why not other tax amounts like JMIQ, JEIQ JSEQ and JSIQ.

For this reason only other accounts are appearing in MIRO.

I need only, in MIRO all taxes should come with including above all condition type.

Kindly clear me about this

Thanks and Regards

HHC

[Former Member]

They do not appear because they have not been captured in MIGO with the excise invoice. The excise values flow from your Part 2 entries into MIRO. As 0 excise has been captured, only the VAT is getting calculated

[Former Member]

Hi,

Thanks for responding

While GRN captured the excise and while posting in J1IEX am getting information like NO CENVAT AMOUNT TO BE POSTED & NO CENVAT AMOUNT TO BE RESERVED due to this am unable to simulate the excise invoice

I searched in SCN but could not get proper solution.

Sub transaction type GRPO already maintained like BED, AED and SED.

[former_member192897]

Seems you are posting Excise invoice with Non cenvatable Condition types. In this case there will not be any part 2 document. All the duties will get loaded on to the Material during GRN. But, you can still post the Excise invoice. Only thing is there will not be any Excise credit or Accounting document generated..

[Former Member]

Hi,

please check did you assign tax code to the PO  and also check the condition type for tax calculation procedure ,

or

don't click the tax calculation and check the entry before posting .

[Former Member]

Hi,

Thank you for reply

i checked tax code assignment is there in PO, did not click the tax tab then also same problem.

Regards,

HHC

[BijayKumarBarik]

Hi,

Check purchase order creation date (ME23N) and compare the date of invoice creation (MIRO) which causes your concern!

Check different tax rates are available with different validity periods for that single tax code with tax condition type where you have one value in purchase order and another value in during invoice creation.

For restricting invoice more than purchase order value, Refer

https://scn.sap.com/thread/3402410

REgards,

Biju K

[Former Member]

Hi,

Thank you for reply.

Initially i thought invoice amount more than PO cuase number of entries i got, but later i come to know the tax amount is distributing to other G/L accounts like material and purchasing account.

I need to know only why the tax is not accumulating in the MIRO with all above condition types (as stated in above)

The all taxes accumulated in MIRO if i clicked on tax calculation check mark,then almost my issue will be solve.

regards

HHC

[Former Member]

Hi experts,

Finally i found the solution after lot of effort.

I used JMIQ, JEIQ, JSEQ and JSIQ these are quantity base condition type these amounts could not fetching to MIRO. For this i had to maintain the JMIP 0 % and JSIP 0% and both should be appear in PO taxes.

After maintaining the JMIP 0% and JSIP 0% i got the all tax value in MIRO by clicking on Cal Tax tab.

Thank you all for your cooperation.

Regards,

HHC