ALERT: Datto Drive Cloud service will no longer be available as of July 1, 2019. For more information, see our end-of-life article. If you'd like to migrate your data to Datto Workplace, see our migration guide.
To learn how to download your Datto Drive Cloud data, please visit this article.

Datto Autotask PSA: Why is my Unit Cost changing when my Inventory item is added to a ticket as a charge?

Follow

Question

Why is my Unit Cost changing when my Inventory item is added to a ticket as a charge?

Example: We have an item in our Product List that shows unit cost $23.90 & unit price of $39.86. When we put it onto a ticket, the cost comes up $13.08, and the unit price is $24.99 or $20.31. When we try to add this to a ticket, the costs are coming up $13.08, but the price is correct. Why the difference?

Environment

  • Datto Autotask PSA

Answer

Items received into inventory at different times can have different costs.

When quoting or creating charges for inventory items, the system will use the cost determined by the Inventory Accounting Method selected in Autotask Menu → Admin → Features & Settings → Application-Wide (Shared) Features → System Settings → Inventory.

There are three available options:

  • Average Cost: Will calculate and use the average unit cost of all units that have been received
  • Cost of unit(s) received furthest in the past (FIFO): Use the unit cost of the on-hand inventory item that was received the furthest in the past
  • Cost of unit(s) received most recently (LIFO): Use the unit cost of the on-hand inventory item that was most recently received

NOTE: if On Hand = 0, the application will use the Product's unit cost defined in Admin.


Was this article helpful?

0 out of 0 found this helpful

You must sign in before voting on this article.

Want to talk about it? Have a feature request?

Head on over to our Community Forum or get live help.