on 01-20-2014 2:29 PM
Dear Guru
I have the following issue:
I have a condition header price in inquiry that is managed as splitted in all the items of the inquiry.
Now happens that when I create the sale order from the Inquiry, if I take less items and not all the items of the inquiry, the condition header changes according to the items copied in the order.
I don't want this behaviour! I need that the value of the header condition keep the original one of the inquiry even if i have less items. what will change is the value of every single item in the sale order.
How can I obtain it?
regards
Hi
Check the copy control settings in VTAA for IN to OR, select your Item category and change the Pricing Type to D.
Kindly share the results.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As understand your requirement,
I need that the value of the header condition keep the original one of the inquiry even if i have less items
Your Inquiry pricing
Inquiry - 11001 | |||
Header | ZHDR - Header Condition Type | Quantity | Total Value - 100 |
Item 1 | ZHDR - Header Condition Type split at Item | 200 | 20 |
Item 2 | ZHDR - Header Condition Type split at Item | 150 | 15 |
Item 3 | ZHDR - Header Condition Type split at Item | 250 | 25 |
Item 4 | ZHDR - Header Condition Type split at Item | 50 | 5 |
Item 5 | ZHDR - Header Condition Type split at Item | 350 | 35 |
So, at Sales Order created with reference,
Sales Order - 65001 | |||
Header | ZHDR - Header Condition Type(accumulate from item) | Quantity | Total Value - 75 |
Item 2 | ZHDR - Header Condition Type split at Item as copied from Inquiry | 150 | 15 |
Item 3 | ZHDR - Header Condition Type split at Item as copied from Inquiry | 250 | 25 |
Item 5 | ZHDR - Header Condition Type split at Item as copied from Inquiry | 350 | 35 |
as system will end up like this
Sales Order - 65001 | |||
Header | ZHDR - Header Condition Type(accumulate from item) | Quantity | Total Value - 100 |
Item 2 | ZHDR - Header Condition Type split at Item as copied from Inquiry | 150 | 20 |
Item 3 | ZHDR - Header Condition Type split at Item as copied from Inquiry | 250 | 34 |
Item 5 | ZHDR - Header Condition Type split at Item as copied from Inquiry | 350 | 46 |
There is no standard solution to achieve this. You have to enhance this.
To enhance this, following is one of the way:
1. Create ZReport to store Condition value as derived from split of header condition at item. Says,
Report ZINQPRD - Inquiry ZHDR Condition Value Report | ||||||
Inquiry No | Item No | Material Number | Plant | Quantity | Condition Type | Condition Value at Item |
11001 | Item 1 | ABC-111 | 1000 | 200 | ZHDR - Header Condition Type split at Item | 20 |
11001 | Item 2 | ABC-011 | 1000 | 150 | ZHDR - Header Condition Type split at Item | 15 |
11001 | Item 3 | XYZ-233 | 1000 | 250 | ZHDR - Header Condition Type split at Item | 25 |
11001 | Item 4 | SDF-456 | 1000 | 50 | ZHDR - Header Condition Type split at Item | 5 |
11001 | Item 5 | JPD-210 | 1000 | 350 | ZHDR - Header Condition Type split at Item | 35 |
2. You can have another item condition type for Sales Order, say, ZITM, to get header value. And header condition type not to be copied in sales order
Sales Order - 65001 | ||
Step | Condition Type | BasType (Alternative formula for condition base value) |
400 | ZITM Item Condition Type (this to get value from report) | Routine 9XX - Write as new routine to get condition value from report ZINQPRD |
With that you will get.
Sales Order - 65001 | |||
Header | ZITM - Item Condition Type(accumulate from item) | Quantity | Total Value - 75 |
Item 2 | ZITM - Item Condition Type - Value will be fetched from report ZINQPRD based on Routine 9XX | 150 | 15 |
Item 3 | ZITM - Item Condition Type - Value will be fetched from report ZINQPRD based on Routine 9XX | 250 | 25 |
Item 5 | ZITM - Item Condition Type - Value will be fetched from report ZINQPRD based on Routine 9XX | 350 | 35 |
Thanks, JP
Dear Jyoti,
following your example, what I need is:
Inquiry pricing
Inquiry - 11001 | |||
Header | ZHDR - Header Condition Type | Quantity | Total Value - 100 |
Item 1 | ZHDR - Header Condition Type split at Item | 200 | 20 |
Item 2 | ZHDR - Header Condition Type split at Item | 150 | 15 |
Item 3 | ZHDR - Header Condition Type split at Item | 250 | 25 |
Item 4 | ZHDR - Header Condition Type split at Item | 50 | 5 |
Item 5 | ZHDR - Header Condition Type split at Item | 350 | 35 |
So, at Sales Order created with reference,
Sales Order - 65001 | |||
Header | ZHDR - Header Condition Type(accumulate from item) | Quantity | Total Value - 75 |
Item 2 | ZHDR - Header Condition Type split at Item as copied from Inquiry | 150 | 15 |
Item 3 | ZHDR - Header Condition Type split at Item as copied from Inquiry | 250 | 25 |
Item 5 | ZHDR - Header Condition Type split at Item as copied from Inquiry | 350 | 35 |
I want my SALE ORDER LIKE THIS:
Sales Order - 65001 | |||
Header | ZHDR - Header Condition Type(accumulate from item) | Quantity | Total Value - 100 |
Item 2 | ZHDR - Header Condition Type split at Item as copied from Inquiry | 150 | 20 |
Item 3 | ZHDR - Header Condition Type split at Item as copied from Inquiry | 250 | 34 |
Item 5 | ZHDR - Header Condition Type split at Item as copied from Inquiry | 350 | 46 |
While as now my sale order has header value of 75 and NOT 100.
I need that my original header condition is mainteined even if I copy less items.
How can I obtain it?
regards
When you said this condition type is Header Condition then,
why your "Item Condition" indicator is active?
In addition to that your this Header Condition is active for "Group Condition".
Don't you think your mixing too many Item Condition & Header Condition properties in one condition type, which you want to make it work as header condition type.
Refer standard condition type HD00 - Freight.
Thanks, JP
Your header condition ought be like this:
If you like to control the distribution of header condition based on
Calculat.type | Impact on cal |
---|---|
B - Fixed Amount | Header - Total Value - 100 $ (100/5) Item 1 - 10 Qty - 20 $ Item 2 - 20 Qty - 20 $ Item 3 - 30 Qty - 20 $ Item 4 - 5 Qty - 20 $ Item 5 - 25 Qty - 20 $ |
C - Quantity | Header - Total Value - 100 $ Item 1 - 10 Qty - 10 $ Item 2 - 20 Qty - 20 $ Item 3 - 30 Qty - 30 $ Item 4 - 5 Qty - 5 $ Item 5 - 25 Qty - 25 $ |
D - Gross weight | Header - Total Value - 100 $ Item 1 - 10 Qty - 2 kg - 20 $ Item 2 - 20 Qty - 3 kg - 30 $ Item 3 - 30 Qty - 1 kg - 10 $ Item 4 - 5 Qty - 2.5 kg - 25 $ Item 5 - 25 Qty - 0.5 kg - 5 $ |
Further, after any configuration change, you need to try out new changes in new sales doc to observe the respective change.
Thanks, JP
Hi,
You can try by changing Pricing condition properties
in V/06 for your Header condition type, change calculation type to B. so that it will be always same for every item
regards,
santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.