Sales Price List Setup

Good day

I have a client that needs the capability to specify a value in a field on the SORDER table (Sales Order header) which are then used  in the price determination of X3. This means that this table needs to be visible on the Price list setup.

Is this possible as I hoped that Data models were used?

Thank you in advance

Herman

  • 0
    Technically you can but it doesn't make sense. At the time that the user enters the order the value for you field will be 0 only after the order is created can you look at the SORDER table. Perhaps you should add the field to the header screen, force the user to enter a value and use the value from the screen not the table.
  • 0 in reply to Israel Braunfeld

    You are 100% correct...I am more interested in a screen field than the actual SORDER table field as the point of creation will not have an effect.

    The question is therefore more then how can a price list be setup to look at a screen field as part of the price list setup as the price list is forcing you to specify a table.

  • 0 in reply to Hermanv
    The answer is yes. In the sales price setup GESSPC you would select "Calculation" in the price processing field and then in the in the base price field you would add your field [M:SOH1]XXX or do some calculation with your field.
  • FormerMember
    0 FormerMember in reply to Israel Braunfeld

    Hi Israel,

    I am a total newbie in X3 (a super highly flexible customization system which I am starting to like very much). How would you go about setting 3 or more related Price lists like so: 

    • Purchase Price from Supplier 
    • Price List A = Purchase Price from Supplier X 1.20
    • Price List B = Purchase Price from Supplier X 1.40
    • Price List C = Purchase Price from Supplier X 1.60

    Basically the idea would be to only maintain the Purchase Price from the Supplier. Another scenario (if the above is not possible) is to setup:

    • Price List A = Entered
    • Price List B = Price List A X 1.1667
    • Price List C = Price List B X 1.3333

    Best regards,

    Carlitos

  • 0 in reply to FormerMember

    Maybe someone will explain it more detailed or more precise way, but try to test in Setup>Purchase>Price lists>Price setup parameters in tab Price/free.

    Change price processing to the calculation (maybe factor also will work) and try to get your price setup. Probably you will need more than one price setup. 
    I used it only to make price list to calculate the sales price based on product average cost price.