cancel
Showing results for 
Search instead for 
Did you mean: 

Billing for the first 100 items for the customer

Former Member
0 Kudos

For the first 100 items for any customer system should pick the price x per item and from the item 101 system should pick a price of y. Condition is that there can be multiple sales order for the customer - but for the first 100 item only he should get the price X,

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi there,

Consition update is one option available but it is dependent on the value of another condition type but not the num of line items of the sales order per customer.

I feel that this will require customizing.

What I can suggest is you need to define a new Z table which will keep track of num of order items per customer. When a customer raises a sales order, it will update the table with num of line items. Once the customer reaches a total of 100 line items in N number of orders, system would flag X in field "Max Limit reached" in the table for eg. For this the system should keep track of num of VBAP-POSNR entries of all sales orders for that customer. (Which is definetely a complex process). To make the logic simple, you can stop counting the num of total line items per customer once he reaches 100 items (VBAP-POSNR count = 100).

Define a new discount type ZCUS which will give discount of say 10% to all customers that exceeded 100 line items. So for a product priced $100, customer who exceeded 100 order items will get the price of only $90 from 101 items. It is similar to offering different price to customers.

But to fulfill that in the requirement routine of ZCUS, you will need to put a code that system will pass the values of the sold to (VBPA-KUNNR of PARVW AG) into the Z table. Then it should check if the field "Max Limit reached" is flagged X or not. If yes, only then the discount will apply.

Check if this logic works.

Regards,

Sivanand

Former Member
0 Kudos

Hi Friend,

This can be possible by CONDITION UPDATE AND CONDITION INDEX.

These two fields are in the condition type V/06

santosh

Former Member
0 Kudos

hello, friend.

i believe your requirement can be met by the functionality "Condition Update". however, there are some limitations to this feature.

you may refer to existing threads on condition update (alternatively: maximum number of orders, maximum order quantity).

regards.