SAP B1 Price List Calc Query

[former_member391531]

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

[former_member211473 · Accepted solution]

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

[former_member391531 · Accepted solution]

Thank you very much!

[former_member211473]

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

[former_member391531]

Giving that a try but not got it working as required yet. But thanks Ranu for the response.

[kothandaraman_nagarajan]

Hi,

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

Regards,

Nagarajan

[former_member391531]

If I set the factor to .90 I get the wrong selling price as it multiples rather than divides.

eg 8.05 * .90 = 7.25