value in exbs field of j_1iexcdtl is takeing base price not the discounted

[Former Member]

hi

In exbs field of j_1iexcdtl taking base price of a material but exice(bed) is calculated on discounted value of base price. can any body clear me whether value is ok or not. if i need to maintain assesable value at j1iid what value should be?

kaushik

[Former Member · Accepted solution]

make te base price as statistical and ensure that the discounted price is transferred to base price.This will take care of your problem. Check the routines and assign the one appropriate to the discounted price.

regds

Jude

[Former Member · Accepted solution]

hi

Thanks for ur reply but if i make base price statistical then accounting effect will not be there. in accounting base price of the material needs to be posted. is there any standard requirement? which i can assign to discounted value, please inform me.

kaushik

[Former Member · Accepted solution]

Hiii,

Can please alaborate your question or inform your pricing structure based on i will helpout in this -

I am giving example strucute, is this is your pricing

Basic Price 1000

Discount 10% on basic 100

ED on basic 16% 160

ECS on ED 2% 3

HSES on ED 1% 2

In your case base price = BasicEDECS+HSEC or only Basic Price

Please clarify

Regards

Goutham

[Former Member · Accepted solution]

thanks for your reply, you almost got the situation. let me explain you...

base price of material X in 100 INR, qty 10

base value=1000.

discount 10%

sub total after discount 900

BED 14%=900%14=126 INR

In table j_1iexchdtl BED value 126 getting stored properly but exice base value field(exbs) is getting stored with 1000 instead of 900.

Hope i could clear u properly, waiting for your sugession.

kaushik

[Former Member · Accepted solution]

Hi,

Tell me one thing, how can you calculate the ED after discount value. As i know its always on the base price of the material not value after discount.

As per standard behaviour, if you want to store the after discount value in EXBAS then you need to develop a routine to post the value into the field. For that use the alternative calculation type and store the values in KAWRT field

In the program MJ1IINF01

z_1iexcdtl-exbas = excitm-excbase.

excitm-excbase = konv-kawrt

DATA : BEGIN OF excitm OCCURS 30,

excbase LIKE komv-kawrt, "excise base"

Include: MJ1IINTOP

• excise item details for the excise invoice

vbeln_b LIKE vbrp-vbeln, "pro forma no,

posnr_b LIKE vbrp-posnr, "pro forma item

vgbel LIKE vbrp-vgbel, "delivery

vgpos LIKE vbrp-vgpos, "delivery item

aubel like vbrp-aubel,

aupos like vbrp-aupos,

xaubel like vbrp-aubel,

xaupos like vbrp-aupos,

matnr LIKE vbrp-matnr, "material no.

arktx LIKE vbrp-arktx, "material desc.

fkimg LIKE vbrp-fkimg, "invoice quantity

meins LIKE vbrp-meins, "unit

werks LIKE vbrp-werks, "plant

lgort LIKE vbrp-lgort, "storage location

charg LIKE vbrp-charg, "batch

excbase LIKE komv-kawrt, "excise base kursk LIKE vbrp-kursk, "exchange rate

bed LIKE j_1iexchdr-exbed,

aed LIKE j_1iexchdr-exaed,

Rewards if it helps

Regards

Goutham

[Former Member · Accepted solution]

hi

Thank u all, every body have contributed a lot.But specially to Gautam.

kaushik

[Former Member]

Hi Kaushik,

Please check whether the base price condition category has been assigned as H.

In case you want the discounted price to be the excise base price then create a condition type for copy of the dicsounted price and mark the condition category as H so it'll pass on as excise base price but you can mark it as statistical so it'll not go for accounting.

Hope it helps.

Rgds,

Antima

[Former Member]

Use the calulation type 2 - net value in the calc type in your discounted value in your pricing and ensure the copy control to billing also is set up correctly and check your excise table. It should populate it. If the table gets populated then the info flow will be correct in all docs such as excise invoice etc.

If not please do let me know. I will try it out.

regds

Jude