Forum Discussion

ComfortZone's avatar
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's avatar
    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.