05-17-2014 10:30 AM
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.
05-21-2014 12:05 PM
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
05-17-2014 10:43 AM
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).
05-17-2014 11:02 AM
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
05-17-2014 11:08 AM
Check your PO price changes log.
Go to ME23N, select the line item.
05-17-2014 11:17 AM
Dear dev,
I checked there is no changes in PO items, it is showing blank
Regards,
HHC
05-17-2014 11:23 AM
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 ?
05-17-2014 11:31 AM
Thank you for reply
pls find the below screen shot POH
05-17-2014 11:32 AM
Are you using the same tax code in MIRO as in PO?
the difference seems to be in calculated tax
05-17-2014 11:37 AM
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
05-17-2014 11:48 AM
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.
05-17-2014 12:04 PM
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
05-17-2014 12:09 PM
Sorry. I am little poor about tax procedure. Lets wait for other member's reply.
05-17-2014 12:35 PM
05-17-2014 12:36 PM
pl check the percentages maintained inside the tax code.
it might've changed between your MIGO and MIRO
05-17-2014 1:15 PM
Hi Ajit,
I checked but no changes done in Tax code
Regards,
HHC
05-17-2014 4:30 PM
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.
05-17-2014 5:59 PM
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.
05-17-2014 6:22 PM
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
05-18-2014 5:12 AM
Has Part II been posted in J1IEX/MIGO before you are doing the MIRO? Check in J1I7 with your material document number.
05-18-2014 7:38 AM
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??
05-18-2014 8:19 AM
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.
05-18-2014 10:47 AM
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
)
05-18-2014 12:04 PM
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
05-18-2014 12:27 PM
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.
05-19-2014 1:49 PM
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
05-19-2014 8:22 PM
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
05-20-2014 6:36 AM
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.
05-20-2014 10:38 AM
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..
05-17-2014 2:12 PM
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 .
05-18-2014 11:01 AM
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
05-19-2014 2:47 PM
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
05-19-2014 4:51 PM
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
05-21-2014 12:05 PM
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