Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Excise (Dealer) need to reflect on MIRO screen

sb_er
Active Participant
0 Kudos

Excise (Dealer) need to reflect on MIRO screen

1) Raise po with tax code z1, condition types JMOP, JEC1, JSEP are made zero(like dummy code)

2) Made excise capture and post J1IEX

3) Done GRN

4) When make MIRO those excise donu2019t reflect in miro screen. Need to get excise in MIRO which has been captured in j1iex, without change tax code in MIRO screen. Please give solution

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

Use the MRHR transaction to copy the excise into invoice which has maintained in J1IEX. Thanking you.

6 REPLIES 6

Former Member
0 Kudos

Hi,

Use the MRHR transaction to copy the excise into invoice which has maintained in J1IEX. Thanking you.

kailas_ugale
Active Contributor
0 Kudos

Hi

1) Raise po with tax code z1, condition types JMOP, JEC1, JSEP are made zero(like dummy code)
2) Made excise capture and post J1IEX
3) Done GRN

2) Made excise capture and post J1IEX

how you capture and post excise invoice before GRN?

steps

1) Create PO ( MARK GR base indicator in invoice tab at item level

2) Do part1 or capture excise here and tick MRP indicator in MIGO

3) Post excise invoice in J1IEX

4) Do MIRO

Regards

kailas Ugale

sb_er
Active Participant
0 Kudos

ALL steps as you told, i done, but Secess dont get post, that line dont come when simulate, what setting need to do, to bring that line

BijayKumarBarik
Active Contributor
0 Kudos

Hi,

For Dealer or Agency Invoice, you need to create PO with one tax code ( onle VAT)& do Invoice with another tax code (matching perfectly tax amount of excise with VAT) .

For Example: You have following Case:

Material Price = 1000/-

Excise Duty = 103/- (JMOP, JEC1, JSEP )

Profit margin for Dealer Agency = 400/-

__________________________________________________

Total =Rs.1503.00

VAT @4% = Rs.60.12

___________________________________________________

Grand Total = Rs. 1563.12

#######################

Create PO for Dealer or Agency Vendor with Base Price as Rs.1503.00 by selecting tax code(only VAT ) which is having VAT as 4% (Total PO value will be Rs. 1563.12)

Now go for MIGO, select MRP indicator in miscellaneous tab, Enter Assessable value 1400/- as in Excise tab Item level and enter the excise values JMOP, JEC1 & JSEP manually, check all values & save the document.

And finally do MIRO ,user proper tax code(matching perfectly tax amount of excise & VAT), checking calculate tax, edit base value as 1400/-enter the amount in header as proposed by the system (Rs. 1563.12), simulate & post the document.

Regards,

Biju K

0 Kudos

Hi Bijay,

In our case  we want to use single tax code, both at the time of PO & MIRO . We have created a  tax code with BED, Cess, HCess & VAT. while creating a PO, we add all the duties in the base value & keep rest other duties as zero. But after saving the PO &doing the GR, the duties get automatically calculated  in the PO itself. Though we have mentioned all these duties in tax code but in PO all are zero. At the time of doing the MIRO with all the excise duties we get balance amount remaining & we are unable to post MIRO

Please provide solution to this.

Regards

Anupam