calculate BED & relevant duties based on value @ PO for a particular vendor

[Former Member]

Dear experts,

Is it possible to calculate excise duties and other relevant pricing elements at purchase order level based on VALUE and capture the same (part1 - MIGO and part11-J1IEX) for a PARTICULAR VENDOR INVOICE?

The business process is like this. First we r receiving invoice from vendor and based on that we r creating PO and do other transaction activities.

We r using ECC6.we r maintaining tax details through tax codes based on percentage and pricing procedure(TAXINJ) is activated and pricing elements are managed through cond.types(gross is value base and others are managed by %).

I find difficulty to capture excise data (cin) through % in j1iex and manual value adjustment is tedious process for multiple line items.

If it is possible, kindly suggest.

Regards,

Vimalan.

[murugan_mgl · Accepted solution]

HI,

Can u throw some more clarity into this issue with ex.

My understanding-

U mean to say u r creating PO based on value(ie-BED-50,ECS-10,SECS-5),THOUGH U HAVE DEFINED IN % IN TAXINJ.

[Former Member · Accepted solution]

thank u for ur reply.

I received invoice from vendor.

I have to enter BED,AED,SED based on value(as per received invoice) at the time of entering po.

I want to know whether the system will allow me enter excise details @ po level and capture those data when I;m doing j1iex.

regards,

s.vimalan

[Former Member · Accepted solution]

Hi

system will allow to enter excise details in J1iex

Vinod

[Former Member · Accepted solution]

dear vinod,

thank u for ur reply. can you explain the detailed procedure.

regards,

s.vimalan

[Former Member · Accepted solution]

thanks all of u

[Former Member · Accepted solution]

This is nothing but Trading process...

u will not know what amount of excise the vendor is passing on u..

just follow the below steps

hi

create material master with HAWA material type..

maintain material chapter id combination in J1ID

create tax code with zero excise and some vat/cst in FTXP

maintain condition records for tax code in FV11

Assign tax code to company code in tax on goods movement

create PO in ME21N with the tax code created.

During MIGO change the base amount

Base amount = Base amount(PO) - Excise(bed, ecess, secess)

enter the bed ecess secess in excise item details

In excise header tab click on additional data (pencil icon) there in miscellaneous tab check mrp indicator

post the document.

in MIRO change the base amount to base amount - excise.

During Purchase the RG23 A reg will Update..

During Sales RG1 willl update..