Calculation of Packing & Excise in PO

[Former Member]

Dear Functionals ,

I have a querry in MM Pricing . i have created the condition type ZPAC (packing & Forwarding) & maintained the conditions in calculation schema in MM Pricing & accordingly Excise related conditions in TAXINN procedure.

As per our client the calculation must be the excise duty some times must include the base price plus the Packing charges & some times with out calculating the packing charges .How the link can be prepared as the condition & excise are maintained in two different pricing procedure .

Pls help to solve the calculation .

Regards,

Suresh.R

[BijayKumarBarik]

Hi,

You need to arrive NET price in Purchase Order which need to flow to tax procedure as u201CBase Priceu201D where BASB condition type play vital role in tax procedure(OBYZ t.code) with routine 362 is assigned in u201CBasTyu201D column.You can manage all by having only one MM pricing procedure.You have following options:

Option-1:

You can add P & F Charge to NET PRICE of Purchase Order and then excise will calculate from NET PRICE where you have following setting in MM pricing

Steps-Couu2014Condition type--Cond Descri--- -

---

From -

---

TO

10----0

---

PB00

---

Gross Price--

---

20----0

---

R000

---

Discount % on Gross

---

10--

---

30----0

---

Subtotal

---

10

---

30-

40----0---ZPAC

---

P & F Charge

---

30--

---

50----0

---

ZFRE

---

Delivery Ch(Fixed)

---

30--

---

60----0

---

TOTAL

---

30

---

50--

Option-2:

With above setting, if P & F Charge NIL, then do not entry any value in ZPAC condition type, so NET PRICE is only Gross price minus discount, then excise will calculate

Option-3:

If business needs, some time P & F Charge will add to NET PRICE of Purchase Order & some other time P & F Charge not added to NET PRICE of PO and that P & F Charge to be capture separate G/L account. In that case create two condition types for P & F Charge, one (ZPAC) for adding to PO NET PRICE & other one(ZPA1) for taking cost separate G/L account. Keep condition category B for condition type ZPA1 in control-1 & select accrual check box in control data-2.In MM pricing (M/08), keep an accrual key with " ZPA1" condition type and assign accrual key to delivery G/L account in OBYC

You can have following setting in MM pricing

Steps-Couu2014Condition type--Cond Descri--- -

---

From -

---

TO

10----0

---

PB00

---

Gross Price--

---

20----0

---

R000

---

Discount % on Gross

---

10--

---

30----0

---

Subtotal

---

10

---

30-

40----0---ZPAC

---

P & F Charge

---

30--

---

50----0---ZPA1

---

P & F Cha.Se

---

30--

---

60----0

---

ZFRE

---

Delivery Ch(Fixed)

---

30--

---

70----0

---

TOTAL

---

30

---

60--

Regards,

Biju K

[Former Member]

Hi,

Both conditions can not work in a single Pricing procedure, for that you need to create two different pricing schema.

Regards,

Manish Jain

[kailas_ugale]

Hi,

You can achieve this by three way

1) the condition on which excise calculate add this condition value in material net price while creating condition,in condition plus/minus sign should be plus .no accrual tick mark in condition and in your pricing procedure account key should be NVV

2) create another condition for which you don't want calculate excise on that condition ,in condition dont mark plus/minus indicator and mark accrual in condition and in your priicng procedure key account key for that condition

3) wrie a ruotin with help of ababper

Regards

Kailas Ugale

[former_member182379]

Hi,

For the excise calculation use the from and to in the pricing

e,g

Base Price : PBXX Step 10

p&F : ZPAC Step 20

Excise : JMOD From 10 TO 20

try this this will solve ur problem for another use different pricing

Base Price : PBXX Step 10

Excise : JMOD From 10

regards,

zafar