Skip to Content

SAP B1 Price List Calc Query

SAP Business One 9.3 PL0

Price List query

Instead of using the 'factor' on a price list to multiple to get the selling price.

Is it possible to setup SAP B1 to divide to get the selling price automatically calculated.

eg 8.05 / .90 = 8.95 (rounded)

instead of using the current 8.05 * 1.11180 = 8.95 (rounded)

Thanks, Eoin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 04 at 11:48 AM

    i got a solution for you, you can give it a try

    In price list form (form no - 155) define a new column (for eg. - named : divisionvalue) and write the values which you want to divide with.

    and in the field of Default Factor apply fms as ( 1/$[opln.U_divisionvalue] ) and auto update on divisionvalue because multiplication is inversily proportional to division.

    all you have to do is update the field with the value you want to divide with, the query will automatically calculate and put correct values that should be multiplied and you will get desired results.

    in your case 1/.90 = 1.11 0r 1/1.11 = 0.9

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 25 at 01:54 PM

    Hi,

    If my understanding is correct, you can set 0.90 factor as default for selling price list.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 28 at 06:34 AM

    Hi,

    I am not sure but you can check if fms works for you or not.

    I think it should.

    Do let me know.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded