I know that this topic is certainly not new, however, it is driving me crazy [:(] I’m creating a functionality to make people able to set a certain margin on a sales line so the unit price will be recalculated. Nothing special with that. However, although I have set the ‘decimal’ properties of the ‘unit price’ for both the table and form to 2:2, the invoice rounding in G/L setup has been set to 2:2, and the amount decimal places of the currency set to 2:2, I still get unit prices with more than 2 decimals. Any idea how I can change this behaviour ? Thanks upfront,
Hi, Set the value of AutoFormatType property as 0 and delete the value of AutoFormatExp property for the field “Unit Price” in table “Sales Line”.