Forum Discussion

5 years ago

Invoices displaying price column to 5 decimal points instead of 2

The price column on our invoices has suddenly started printing prices with 5 figures after the decimal point instead of 2. The sub total column is fine, and we've checked the inventory list and the p...

Steven_M
5 years ago
Hi ComfortZone

The Unit Price within the Enter Sales window can have up to 6 decimal places. This is hardcoded and not able to be changed to always reflect a 2 decimal place system, although, the number can be manually overtyped to be a 2 decimal place number if required - Note: this may have an effect on the Total.

In saying that, when printing an invoice you can have the system use 2 decimal places or up to 6 decimal places. This is done by the relevant column that you add to the invoice table on the customise form. If you use the Ex Price 2/Inc Price 2 on your customise form it will be 2 decimal places on the printed/emailed invoice whereas Ex Price or Inc Price will do up to 6 decimal places.

You can see and adjust the column used on the customise form via Setup>>Customise Forms>>Invoices>>Item>>Selecting the desired form and Customise. Within the Customise Form window, you can right-click on the invoice table and select Show/Hide Columns before selecting the desired column. Our Help Article: Add tables to forms has more information on that process.

Steven_M

Former Staff

5 years ago

Hi ComfortZone

The Unit Price within the Enter Sales window can have up to 6 decimal places. This is hardcoded and not able to be changed to always reflect a 2 decimal place system, although, the number can be manually overtyped to be a 2 decimal place number if required - Note: this may have an effect on the Total.

In saying that, when printing an invoice you can have the system use 2 decimal places or up to 6 decimal places. This is done by the relevant column that you add to the invoice table on the customise form. If you use the Ex Price 2/Inc Price 2 on your customise form it will be 2 decimal places on the printed/emailed invoice whereas Ex Price or Inc Price will do up to 6 decimal places.

You can see and adjust the column used on the customise form via Setup>>Customise Forms>>Invoices>>Item>>Selecting the desired form and Customise. Within the Customise Form window, you can right-click on the invoice table and select Show/Hide Columns before selecting the desired column. Our Help Article: Add tables to forms has more information on that process.

ComfortZone
5 years ago
Thanks so much! That helped solve the problem quick smart!! Easy when you know how.
IvyMcG
Contributing Cover User
5 years ago
Thanks for this, I have been struggling for a while with a client with this issue. I will be cusomising the invoice tonight.
Will let you know if it works
vt12
Experienced Cover User
5 years ago
Great that I can change to 2 decimals, but my invoice detail is in a table. How can I change just the unit price column in the table to the alternative Field?
- Steven_M
  Former Staff
  5 years ago
  Hi vt12
  
  A user can update their columns on the customise form using the following process:
  
  Navigate to Setup>>Customise Forms
  
  Choose the desired type, layout and form
  
  Select Customise
  
  Within the Customise Forms window, right-click on the table and select Show/Hide columns
  
  Choose the desired column on the left-hand side and select Show> (To remove unwanted columns, highlight it before selecting <Hide).
  
  Select Ok
  
  The above process adds the required column to the forms table. You may want to resize or reorder the columns.
  
  For more information on this topic please see Help Article: Add tables to forms