Skip to Content
avatar image
Former Member

Billing for the first 100 items for the customer

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 13, 2009 at 02:20 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 13, 2009 at 02:45 AM

    Hi Friend,

    This can be possible by CONDITION UPDATE AND CONDITION INDEX.

    These two fields are in the condition type V/06

    santosh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 13, 2009 at 03:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded