Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
January 2020
January 2020
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 prices per unit are showing with the usual 2 figures after the point, so what is happening when the unit price is imported into the invoice and it suddenly shows and prints with 5 figures after the decimal point?
Solved! Go to Solution.
January 2020
January 2020
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.
January 2020
January 2020
Thanks so much! That helped solve the problem quick smart!! Easy when you know how.
July 2020
July 2020
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
December 2020
December 2020
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?
December 2020
December 2020
Hi @vt12
A user can update their columns on the customise form using the following process:
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
by
jlyall
a month ago
8
367
|
8
|
367
|
||
7
|
383
|
|||
3
|
244
|
|||
5
|
320
|
|||
5
|
280
|