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

Question:

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?

Answer:

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

Article 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  ·  Last updated October 02, 2025 · GoldFinch ERP Help Center