Purchase from a Dealer (Trader)

[Former Member]

Hi,

This is a scenario of purchase from a trader who passes the excise duty from the manufacturer to the customer. The example of the scenario is

Basic Price: 100

Excise Amount passed by trader

BED: 10

Ecess: 0.2

SEcess: 0.1

ACD: 3.02

CST: 2.27 (2% of 100100.20.13.02)

I am using condition type JEXC (with subtotal 5 and calculation type 355) for manual Excise BED and ZADC (copy of JADC) with subtotal 2 for ACD passed by trader. I have used Tax code for Excise Duty and CST 2% but not getting the desired result.

Can anyone provide some idea to resolve this issue?

Thanks in advance

[Former Member]

Hi,

The case where the Vendor passes on duty is called as "Dealer senario / Purchase from dealer" .

There is no additional configuration required apart from may be tax codes.

step 1. : Create PO with Price = Base price + Excise duty

step 2 : select "Zero Excise + actual sales tax" code . eg: 0% excise + 5% Vat

Step 3: In MIGO :

a) Excise Item tab: Change the excise base amount and add manually the excise components.

b)Excise header : Select the "MRP " indicator.

Step 4: Post part 2 - j1iex

Step 5 : Change Base price in MIRO

Regards,

Deepak

[Former Member]

Hi All,

When i post MIRO as mentioned above,

the cenvat clearing account is not triggered instead material account is triggered for duty value. is that correct?

Also please tell me how to enter SCESS value in MIGO excise invoice tab?

Regards,

Sundar

[ajitkumar]

enter the price in PO as basic + ED + Cesses. choose the tax code relavent for excse nil + CST @ 2 %.

during migo, in excise header tab, additional data button , check mark MRP

in the excise item tab enter the base value such that the base value = base price mentioned in the PO less the ed + cess passed on by the dealer ( for e.g is the base price was 100 and the dealer has given ED 12,e cess 2 and S cess 1 , in the migo excise tab enter base as 87, 10 in basic ED, 2 and 1 in cesses )

CST willl be calculated in 100 in this case.

[kailas_ugale]

Hi

its from sap note for Trader

1. Create purchase order and enter net price(inclusive of base value and excise duties)

2. Excise duties not computed. (excise duties = 0) in Po only CStT 2% and all excise condtion with 0 value in po )

. Capture of excise invoice

a) Capturing excise invoice together with goods receipt through transaction MIGO

MRP indicator found in the Miscellaneous TAB popped up when you click on More data button on Excise invoice tab at the header level in MIGO

The excise base value is defaulted as the PO price and the excise duties are zero. The excise base is changed such that the sum of the excise base value and the excise duties remain the same as the PO price. The excise base is reduced by the excise duty value and the differential amount is split amongst the relevant excise duty components.

Hence the material valuation also takes place correctly with the changed amount put as the excise base value. Otherwise this would incorrectly get inflated by the excise duty value also.

b) Capture excise invoice through transaction J1IEX

MRP indicator found on the Miscellaneous tab in J1IEX

The excise base value is defaulted as the PO price and the excise duties are zero. The excise base is changed such that the sum of the excise base value and the excise duties remain the same as the PO price. The excise base is reduced by the excise duty value and the differential amount is split amongst the relevant excise duty components

4. Invoice verification process through MIRO

Regards

Kailas ugale

[Former Member]

Dear Friends,

I already checked and have found the scenario is working fine if we use MRP indicator in J1IEX / MIGO.

But the requirement is we need to capture all the duties in PO as most of the times trader provides the Excise duties & ADC (if applicable) upfront. That's why we want to use the condition types JEXC and ZADC (copy of JADC) in order to put the Excise duties in PO itself and override the calculation being carried out with the tax code and the procedure TAXINN, but not getting the desired result in the calculation of Excise duties and CST.

Can anyone help in providing the solution?

Thanks in advance

[Former Member]

> 
> I already checked and have found the scenario is working fine if we use MRP indicator in J1IEX / MIGO.
> 
>  That's why we want to use the condition types JEXC and ZADC (copy of JADC) in order to put the Excise duties in PO itself and override the calculation being carried out with the tax code and the procedure TAXINN, but not getting the desired result in the calculation of Excise duties and CST.
> 

Is it that you dont want to use Taxinn/tax code to meet your requirement and would like to map the entire process through MM pricing procedure? Moreover i think you are trying to use process as described in note 964190 to meet your requirement. Normally " While procuring from dealers, the dealer's invoicing amount is known at the time of PO creation. This price is taken as the PO price and the excise duties aren't calculated in the PO and hence there is a standard process from SAP as listed above as per SAP note 110456?

For the calculations to work correctly from creation of PO to posting of MIGO and MIRO its better to follow the process suggested by standard SAP else you will have to go for development may be pricing routine in Taxinn.

In case its mandatory to put the values in PO also as you know upfront may be you create statistical condition and put it just for information and rest all the process follow through note 110456.

Regards

Sangeeta

Edited by: Sangeeta Khurana on May 16, 2011 5:49 PM

[Former Member]

Hi Sangeeta

For all above discussion as said, Sap have given standard first or Second stage dealer Scenario,

For the same we have all excise condition Zero and put Cst percentage

At the time of migo, check on MRP indicator take all the excise duty manually

At the time of miro, change the excise condition , put the actual percentage and do the miro.

regard

Nabil

[BijayKumarBarik]

Hi,

If tax procedure working properly, no need to use manual Excise condition type. Check tax procedure & see 362 routine is there in u201CBasTypeu201D column for BASB condition type and routine u201C4u201D is there in u201CCalTypeu201D column for last row which will be u201CNet Price + Excise + Local taxu201D

Now create PO for Dealer Vendor with Base Price as 113.32/- by selecting tax code which is having CST as 2% (Total PO value will be 1115.59)

& then do MIGO, select MRP indicator in miscellaneous tab, Enter Assessable value 100/- as in Excise tab Item level and enter the all excise values BED, ECess , SECess manually, check all values & save the document.

And finally do MIRO ,user proper tax code( tax code in PO & tax code in MIRO must be different),selecting calculate tax check box, edit base value as 100/-enter the amount in header as proposed by the system (1115.59), simulate & post the document.

Regards,

Biju K