Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Excise Formula

Hi all,

Can anyone help me in Creating Excise formula.

Which includes

BED 14% of total amount

ECD 2% of BED

SHECD 1% bed

Thanks,

Neetu

replied

Hi Neetu,

Follow this, if you can't do this please let me know.

Tax Formula Setup

1. BED

Formula Output u2013 BED_TaxAmt u2013 TaxAmt

BED_BaseAmt u2013 BaseAmt

Formula Inout - Total

Formula Input - Rate

Formula

BED_BaseAmt=Total

BED_TaxAmt=Rate*BED_BaseAmt

2. ECD

Formula Output u2013 ECD_TaxAmt u2013 TaxAmt

ECD_BaseAmt u2013 BaseAmt

Formula Inout -

Formula Input - Rate - Rate

BED_TaxAmt u2013 BED_TaxAmt

Formula

ECD_BaseAmt=BED_TaxAmt

ECD_TaxAmt=Rate*ECD_BaseAmt

3. SHECD

Formula Output u2013 SHECD_TaxAmt u2013 TaxAmt

SHECD_BaseAmt u2013 BaseAmt

Formula Inout -

Formula Input - Rate - Rate

BED_TaxAmt u2013 BED_TaxAmt

Formula

SHECD_BaseAmt=BED_TaxAmt

SHECD_TaxAmt=Rate*SHECD_BaseAmt

Note: Before doing this, define tax types accordingly as BED, ECD, SHECD

Thanks,

Balaji

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question