You’re offline. This is a read only version of the page.
30
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.
*This post is locked for comments
I have the same question (0)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)
Share
Report
All responses (
Answers (
