Hi Wayne,

Due to how the database stores the numeric information, you will need to create a formula to display the correct information for Alternate Price lists with 3+ decimal places.

In your case, you need to create a formula that divides the numeric field by 10, then format the formula field to have 3 decimal places.

If you want to print multiple price lists with different decimals, then you have to use the 'Pricing Decimals' field in conjunction with an If/Then/Else statement:

If Pricing Decimals = 3 then Price/10 else Price

The reports and processing built into Order Entry (both Adagio and Accpac Plus) already take this into consideration. As you are creating a report on the 'raw' data, you may have to manipulate the data somewhat to get what you want.