Material account hitting while posting Excise Invoice for dealer

[Former Member]

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 

[Former Member]

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

[Former Member]

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

[former_member183424]

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.

[Former Member]

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

[former_member183424]

Can you check your condition tab in PO?

Can you post the screen shot?

[Former Member]

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

[former_member183424]

Here I can see the total amount 124382.5,

Then how the stock account is calculated

Stock account - 83087.24

Gr/ir clearing -   83087.24

There are must be some hidden charges.

[former_member182489]

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

[former_member183424]

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.

[ajitkumar]

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