on 12-02-2013 3:10 PM
Hi
i have a problem in posting the excise invoice for dealer
PO base rate- 160 including excise
PO vat-12.5%
when i do migo for 615 qty & capture the invoice by changing the excise value as per invoice with mrp indicator flagged the entries as follows
Stock account - 83087.24
Gr ir clearing - 83087.24
while i do miro, with tax code different from PO, here tax code(excise + vat ) the entries were
vendor account- 127927
Gr ir clearing - 83087.24
material account- 15312.76
cenvat clearing- 15312.76
input vat- 14214.10
why the material account is hitting? why the GR IR amount is lower than the PO base price
Hi,
From ur data
vendor account- 127927
Gr ir clearing - 83087.24
material account- 15312.76
cenvat clearing- 15312.76
input vat- 14214.10
Below calculation should occur please check it
Vendor Account | 124,382.52- |
Vendor-Materials-GR/IR Clear | 86,237.76 |
Material Account | 12,162.24 |
Provisional liability-Vendor-CENVAT | 11,808.00 |
Provisional liability-Vendor-CENVAT | 236.16 |
Provisional liability-Vendor-CENVAT | 118.08 |
Input VAT credit | 13,820.28 |
while simulation any pop message is coming like Price change more than....
Regards
Shiva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thanks for all your help,
I found that the base rate of PO is not included excise, because of this it is hitting the material amount
For dealer scenario to work PO rate should include Excise, here client is not considering the excise.
Rs 160 is excluding excise, hence the material account is hitting
Now problem is that they can not reverse the MIGO or can not change the rate in PO/Sch Agreement since period is closed. they dont want a entry to hit material account,
please advise what is the corrective action
can we pass JV as-
Credit Material account
Debit consumption account
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you don't want to hit material account.
There are two way to fix this
1. Cancel the goods receipt and invoice receipt in current period and change the price and do MIGO and MIRO again.
2. You can pass through a JV entry...
Note: Posting current period is little bit in risk. Better you can go for JV adjustment.
Hi
thanks for your reply
the base value at migo is -98400
& same is copied to miro amount
if i change the value in miro no material amount is hitting but reducing the credit to vendor account
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
screen shot not being uploaded from yesterday,Please find the conditions as follows, getting it from double clinking the miro amount in miro screen
one thing i want to clear is client is using the scheduling agreement not PO, rest data is all same
kindly help me to understand why the material account is hitting
Cn Ty | Name | Amount | Crcy | Per | U | Condition Value | Curr |
p000 | Gross price | 160 | INR | 1 | L | 98400 | INR |
Net including Price | 160 | INR | 1 | l | 98400 | INR | |
P&F1 | P&F % | % | 0 | INR | |||
P&F2 | P&F value | INR | 0 | INR | |||
P&F3 | P&F QTY | INR | 1 | L | 0 | INR | |
Net1(Price+Disc+P&F)) | 160 | INR | 1 | L | 98400 | INR | |
FRC1 | FR Qty | INR | 1 | L | 0 | INR | |
FRB1 | FR Value | INR | 0 | INR | |||
JEXC | IN Manual Excise | % | INR | ||||
Net2(Price+Freight)) | 160 | INR | 1 | L | 98400 | INR | |
Net Value Inc Tax | 160 | INR | 1 | L | 98400 | INR | |
JOCM | In Cotroi | % | INR | ||||
SKTO | Cash Discount | 0 | % | 0 | INR | ||
Actual Value | 160 | INR | 1 | L | 98400 | INR | |
JEXS | Taxes On PO | 25982.52 | INR | 25982.52 | INR | ||
Copy of Net2 | 160 | INR | 1 | L | 98400 | INR | |
Total PO Value | 202.25 | INR | 1 | L | 124382.5 | INR |
Hi ,
Per your statement - its the scenariuo
task | Value |
Stock net value | 98,400 |
Excise | 25,983 |
Total PO Value | 124,383 |
Please prepare an Excel sheet and see - you will find what went wrong -
task | Value |
PO Scenario | |
PO Net Stock Value | |
Excise | |
Tax | |
Total Po Value (to pay to vendor) | |
GR Scenario | |
Stock Value DR | |
GR IR Cr clearing | |
IR | |
Vendor | |
GRIR | |
Excise | |
Tax |
regards
manu
You GR/IR clearing account is perfectly showing in MIRO.
Because In GR time you GR/IR clearing account credit the same amount.
You can see the details in PO condition tab.
1. The material accounting hit because you price has been changed after GR (before MIRO). You can see the changes log in ME23N, in environment-item changes.
2. Or may be for material comes into excise.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i think you have to manually change the value in MIRO to the one in basic field and also use the same tax code in MIRO as in PO
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.