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?
- Datto Autotask PSA
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.