JEXP calculation error at header level of sales order

[Former Member]

Hello

I am facing a strange error at the time of sales order creation.

My sales order is having 14 line item and for each line item JEXP i.e.BED is calculating 10% correctly

(Rs 10 for rs 100)

But at header level for all line items collectively JEXP is not getting calculated correctly e.g. Rs 96 for rs 1000.

Have checked pricing procedure and its correct

Please guide me.....

[Former Member]

resolved

Problem was in base price rounding

[Former Member]

Dear Tanveer

Request you to kindly explain a bit,on how this was solved. ED is calculated on Accessable value, NOT on basic price.

How come, here, base price rounding comes into picture? Also, why Rs 96/- at header level & Rs 100/- ( total ED of all line items)?

Rgds

Sumanth.G

[former_member182378]

1. What is the header condition type? and what is the item condition type? (I want to know if they are different)

2. How are you calculating the value of the header condition type? (manual entry?)

3. For the header cond type is calculation type = % or....?

4. If you made the amount 1000 instead of 100, what is the value of the header cond type? and the value of sum of all the item cond types?

[Former Member]

Hi

Header condition and item condition is same and at header level base value for jexp is coming auto. by adding base value of all 14 line items.

Calculation type is %

[former_member182378]

Please do the below 2 actions -

1. create a new sales order, with 1 line item. Check the value of cond type in header and item. Is it correct?

do the same for sales order with 2, 3, 4, 5 line items. and check.

2. In your sales order, with 14 line times, go to each line item, Tab Conditions and check the value of the cond type. Total that.

Maybe one of the line items has value for that cond type = 6. (instead of 10)

Let us know the results.

[Former Member]

Waiting for suggestion to resolve issue....

[Former Member]

Hi Rahul

Thanks for your inputs but we are not using header conditions or group conditions.

in my case assessable value is there but its not calculation 10% of that assessable value....

Have checked the rounding rule and that is also maintained for excise conditions.......

[bsivasankarreddy_reddy]

hi

please check ftxa, ftxp

and also check j1id

[bsivasankarreddy_reddy]

hi

please check ftxa, ftxp

and also check j1id

[Former Member]

everything is ok.....

problem in calculation of 10% in BED

[Former Member]

Hi,

Please check the below example, might helpful in your case to follow the right process:-

Header Condition and Group Condition

What are header conditions?

Header conditions are those which appear in the header level of any sales order. these conditions are to be entered manually and get distributed automatically and the basis for distribution are taken from the NET VALUE of items mentioned at item level.

When we go to the conditions section in a sales order, where the details of pricing is mentioned, here we add these conditions.

Whenever any Header Condition is used, it overrides the PR00 condition type.

Examples of header condition.

- HA00 - % Based Header Condition.

- RB00 - Absolute or numeric value which applies to all items.

- HB00 - Numeric value or Absolute value.

What is the difference between group condition and header condition?

Group Condition: You can use this is feature of a condition type to apply price or discount for a material based on common property.

Header Condition: This is a manual condition which you apply to header (Condition screen) of a sales document. This amount is applicable to all items.

Usage of this feature is to apply price / discount for a specific group of materials.

1. You maintained a discount based condition record fbased on material group ( = 01 for example). You maintained scales also.

Qty Discount

1 - 10 Rs. 100.00

11 - 50 Rs. 105.00

51 - 150 Rs. 110.00 etc.

2. You are creating a sales order for a customer with five different items with different quantities as below

ITEM 1 - 25 No's

ITEM 2 - 3 No's

ITEM 3 - 12 No's

ITEM 4 - 27 No's

ITEM 5 - 62 No's

All the material is having the material group = 01.

3. While calculating the discount, because of this group condition, system add the quantities of items which have material group = 01. In the above example total quantity is = 109. System apply a discount of Rs. 110.00 to each item irrespective of the individual quantities.

4. If you have not activated the group condition feature, system determines the discount value based on individual item quantity which is as below.

Discount

ITEM 1 - 25 No's Rs. 105.00

ITEM 2 - 3 No's Rs. 100.00

ITEM 3 - 12 No's Rs. 105.00

ITEM 4 - 27 No's Rs. 105.00

ITEM 5 - 62 No's Rs. 115.00

5. Is it clear now. Just try a sales order and see the out come

Procedure to Test:

1. Create 3 materials. Maintain Material Group of each item is same.

2. Activate the condition type as a group condition.

3. Create a condition record for this condition type with scales.

4. Process a sales order for a customer with these three material with different quantities.

5. Check the outcome.

Thanks & Regards,

Rahul Verulkar