Dynamics Community Forum Thread Details

Change Decimal Places for % of list value when using % of list price lists

Hi,

Our company uses % of list price lists that we assign to our customers. For some customers, we quote specific pricing and then create a price list that allows us to maintain that pricing by applying a certain % of an item's list price.

Because some of our items have large list prices (i.e.) $4649.00, I need to use a % off of list that has more than 2 decimal places. For instance, using a list price of $4649.00 I want to achieve a discounted selling price of $2,388.42. The % of list to get that value needs to be 51.3749%, but right now Dynamics will only accept a % value with two decimal places. If I round it to 51.37% I get a discounted selling price using % of list of $2,388.19- relatively small difference ($0.23) but significant enough for our purposes that it won't work.

Can I change the % of list field to accept more than 2 decimal places? In this case, change it from 2 to 4 decimal places? And will this affect all price lists or just the one I am currently editing?

Thanks.

Major disclaimer here, and a warning. Try this in a test system first, and or try it on an item/price level combo created for just this purpose. BE CAREFUL and ALWAYS HAVE A BACKUP!!!

The fields in GP will accept up to 5 decimal places of accuracy. I just tested the following query and it worked as I expected. You won't be able to make the changes in the User Interface, but you can change the values in the database, and achieve your desired results.

update IV00108 set UOMPRICE = 95.55555 -- the new percentage you want to use

where ITEMNMBR = '128 SDRAM' -- replace '128 SDRAM' with your item number

and PRCLEVEL = 'NEWONE' -- replace 'NEWONE' with your Price Level

-- you will need to do some more modifications to this query if you use different Quantity Breaks for pricing (i.e. 1-10 = 95.55555 percent and 10-100 = 95.52555 percent)

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)