Skip to Content
avatar image
Former Member

Header Frieght calculation based on the item gross weight

Hi,

Requirement:

Header freight value (sales order) should be proportionately distributed based on the gross weight, among all the sale order items (as per the calculation mentioned below)

Eg.

Header value (sale order) - 100.

items Gross weight Frieght value

A 16.72 49.93

B 0.041 0.12

C 16.72 49.93

33.481 (total gross weight)

Calculation:

Frieght value calculation: Gr. weight * Header frieght value / Total gross weight.

A: 16.72 * 100 / 33.481 = 49.93

B: 0.041 * 100 / 33.481 = 0.12

C: 16.72 * 100 / 33. 481 = 49.93

Note: Currently I copied HD00 (std. header codition type) and defined as ZFRG.

Group condition marked.

Calculation type - D (gross weight)

condition cat. - Freight

Even after the above settings, it is not working as per the above calculation.

Kindly help on the above.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 11, 2009 at 09:16 AM

    Hi Suresh

    Maintain your condition type ZFRG as Group Condition and also maintain Group Condition Routine '01' in V/06.

    Hope this will resolve your issue.

    Regards

    Amitesh Anand

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI,

      Think the routine 02 will match ur requremnt in the condition type ZFRG in the field GrpCond.routine 02

      The prices with scales based on weight. When a sales order line item is priced, the user would like the system to read the scale with not just the weight of the current line item, but the combined weight of all items in the sales document. To accomplish this, the user defines their price condition types as group conditions and assigns structure of group key formula '2' to them in customizing

  • avatar image
    Former Member
    Aug 11, 2009 at 10:55 AM

    Hi,

    Solution:

    Header condition & Group condition should be marked in V/06

    - calculation type should be B (Fixed Amount)

    - Alternative Cond. Base Value should be 12 (Gross Value)

    This is perfect answer for the above problem.

    Add comment
    10|10000 characters needed characters exceeded