Skip to main content
Skip table of contents

The Last Invoiced Base Cost Field on the Item Card Does Not Have the Same Decimal Places as the Unit Cost Field on the Last Purchase Invoice

Why do I see 5 decimals on the Last Invoiced Base Cost field on the Item card, but only 2 decimals entered to the Unit Cost field on the last Purchase Invoice?

By default, we display 5 decimals on all Unit Cost fields, including the Last Invoiced Base Cost on the Item card.

If you prefer to see 2 decimals on the Item card, you can add a custom formula field to display that.

How is the Last Invoiced Base Cost calculated?

To calculate Last Invoiced Base Cost, we have to calculate Line Cost first:

Unit Cost x Quantity - Discount = Line Cost

For example: 44.8 x 33.48 - 0 = 1499.904

We then have to round 1499.904 to 1499.90 because only 2 decimals are allowed on the financial statement.

We also have to convert 1499.90 to the base currency. (ex. USD)  

Then, we calculate Last Invoiced Base Cost using:

Line Cost (USD) / Quantity

1499.90/33.48

= 33.47991

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.