Group Conditions Displayed at Header

[former_member236234]

Hello,

I have a question regarding grouping conditions and displaying at the header level.

I have a condition ZPRC which is maintained as a group condition with the routine as 03 matrl pricing grp.

This condition also has pricing records which is maintained by material group and uses scales.

So the pricing records are as follows...

Matrl grp 1 = $30.00 with scales

Matrg grp 2 = $35.00 with scales

mat grp 3  =  $40.00 with scales

On the sales order

Item 10 =  matrl grp 1

Item 20 = matrl grp 2

Item 30 =  matrl grp 1

The group condition works great and pulls in the scales across all of the materials that are assigned the same matrl pricing grp.

However, the header displays multiple lines which are grouped by matrl grp.

It seems like the header adds up the lines that use the same matrl grp (based on the condition record) and puts the total on one line.

So for the above example, the header would show two lines of ZPRC.

One for matrl grp 1 ( which is the sum of item 10 and 30)

One for matrl grp 2 (item 20)

Is it possible to display condition ZPRC as one line item on the header instead of grouping by condition record?

[former_member182378]

Marcus,

What is the issue if this condition type ZPRC is populating twice, at header level of the sales order?

Two different entries of the condition type gives clear information to the user that discounts have been given for two different material pricing groups, which is the basis of calculation for routine 3.

Check in the billing document, how many lines, at header level do you see in the billing document?

tw

[former_member236234]

TW,

The billing doc header still shows the multiple lines.

Couple of issues with it displaying in multiple lines...

The routine 03 is used so that the scales will work based on the cumulative values of all of the same material pricing groups.That was the initial requirement and passed.  However, there can be multiple pricing records for this scenario since we are using material group in our condition record table.  There are also records that are by the specific material.  So there is a potential for there to be a large amount of lines on the header, which may cause confusion to the user and is also unsightly.

The other issue is that for records where we maintain as percentages, since these are grouped by the record, rounding issues begin to appear.  If there were one line for the condition, then the rounding might not be an issue.

[siva_vasireddy2]

Hi,

Mark this condition both as Header and Item Condition

[former_member236234]

Hi Siva,

Marking the condition as header and item condition did not solve the issue.

Thanks