Greetings:
We are running Progression 7.6.300C on MS SQL Server 2000.
We are having an issue with the UNIT PRICE that shows up on our invoice forms. The problem is that it rounds to 2 decimal places. We sell items like wire and cable and those typically go to 3 decimal places. So, on a line for 3000 feet of cable with an actual unit price of .262, the invoice shows .2600. However, the NET PRICE (or extended price) reflects the .262 actual UNIT PRICE.
The real issue is that many of our customers note that the unit price * quantity shipped doesn't match the NET PRICE and therefore dispute the amount.
I checked in forms designer for the invoice form that we use and the UNIT PRICE field is set to 4 decimal places, the size is 14, the mask that is selected is ZZZ,ZZZ.9999CR and it doesn't overlap with any other fields.
I am assuming that the mask that is set should allow 4 decimal places. And in fact it DOES print 4 decimal places but the last two decimal places are always zero, i.e., UNIT PRICE .262 prints as .2600.
I looked at some of the standard forms that come with Macola and noted that the mask that was set was ZZ,ZZZ,ZZZ.999, size 14, decimal places 3. So, I set my form to that mask and re-printed an invoice. The only change was that it printed to 3 decimal places but it still rounded, i.e., UNIT PRICE .262 was now .260.
I also looked in the OELINHST_SQL table and confirmed that the UNIT PRICE is .262.
How can I stop the UNIT PRICE on my invoice form from rounding to the second decimal place.
Thanks in advance for your help, everyone.
Christopher J. Poulin
We are running Progression 7.6.300C on MS SQL Server 2000.
We are having an issue with the UNIT PRICE that shows up on our invoice forms. The problem is that it rounds to 2 decimal places. We sell items like wire and cable and those typically go to 3 decimal places. So, on a line for 3000 feet of cable with an actual unit price of .262, the invoice shows .2600. However, the NET PRICE (or extended price) reflects the .262 actual UNIT PRICE.
The real issue is that many of our customers note that the unit price * quantity shipped doesn't match the NET PRICE and therefore dispute the amount.
I checked in forms designer for the invoice form that we use and the UNIT PRICE field is set to 4 decimal places, the size is 14, the mask that is selected is ZZZ,ZZZ.9999CR and it doesn't overlap with any other fields.
I am assuming that the mask that is set should allow 4 decimal places. And in fact it DOES print 4 decimal places but the last two decimal places are always zero, i.e., UNIT PRICE .262 prints as .2600.
I looked at some of the standard forms that come with Macola and noted that the mask that was set was ZZ,ZZZ,ZZZ.999, size 14, decimal places 3. So, I set my form to that mask and re-printed an invoice. The only change was that it printed to 3 decimal places but it still rounded, i.e., UNIT PRICE .262 was now .260.
I also looked in the OELINHST_SQL table and confirmed that the UNIT PRICE is .262.
How can I stop the UNIT PRICE on my invoice form from rounding to the second decimal place.
Thanks in advance for your help, everyone.
Christopher J. Poulin