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

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