Open Forum

  • 1.  Unite Price By Level

    Posted Apr 17, 2021 10:30 PM
    Hello , all
     someone helps me find a solution by code of what is blocking me now, I created a customer price contract document used to add items to be sold to the customer with a special price during a defined date range in the header (start date-end date).
    the contract includes the following fields in the line of course, item number, Zone, Unit price, Deduction amount, Deuction level (option = ,1,2,3), start date and end date.
    this for the contract and the status make active once launch the contract after I will create a sales order for this customer, the posting date is in the contract range, I insert in the first line the Item exists in the contract on price and also arrives from the contract, here we have critical fields (Contract No and No in contract, and delivery date i.e in sales line the item is linked to the contract so quantity delivered is 1 because always the quantity base equal 1 after if I will ship another quantity I must add a second line here same item, same delivery date, same zone, I assure you that the unit price deduct from 100$ this amount exists in a field in the contract and we must attribute level 1 at this second line the operation repeated according to the level defined in the contract the unit price will be deuidre by each level of 100 is assigned the level id for each line but if I will add more lines than the level proposed here l The unit price is the last level that will be applied.

    exempel::
    Contract [1] Line
    <google-sheets-html-origin>
    contract 1 contract 2
    item level start datq fin date dis item level start datq fin date
    1002 3 4012021 4022021 150 1002 2 4052021 41021
    sale order 1
    Price Item Card zone item qty del date upirce level shipmnt contract
    1001 500 z0002 1001 1 04/01/2021 1500 0 1 1
    z0002 1001 1 04/01/2021 1500 1 1 1
    z0002 1001 1 4052021 1500 0 1 2
    z0002 1001 1 4052021 1200 1 1 2
    z0002 1001 1 4052021 900 2 2 2
    z0002 1001 1 4052021 900 2 1 2
    z0002 1001 1 4052021 900 2 1 2
    z0002 1001 1 4062021 1500 0 1 3
    z0002 1001 1 4062021 1200 1 1 3
    z0002 1001 1 4062021 900 2 1 3
    z0002 1001 1 4062021 900 2 1 3
    z0002 1001 1 4062021 900 2 1 3
    z0002 1001 1 5012021 500 0 1 0
    </google-sheets-html-origin>

    ------------------------------
    Zakaria Zakaria
    CONFIDENTIELLE
    ------------------------------


If you've found this thread useful, dive deeper into User Group community content by role