Create, support, comment and share your ideas!

I really like this.  Sometimes we'll have a product, such as a board game, that has been on the shelf over a year before we sell the last copy.  When we restock it, it would be much easier to check the inventory on Crystal Commerce to see if the cost of the game is still the same, or if we need to adjust our prices accordingly.  Currently, we have to find the invoice from the previous purchase to compare, which is time consuming. 

when buy prices fluctuate, such as card costs, you can't just query the current product buy price.

Would this really be that hard to implement though?

You already have all of the data.

We input the buy price, sell price and quantities of all our items, and you already have functionality to provide a report that basically displays "Over X time period, show me how much revenue (including tax) was generated".

That report is just summing up all the quantities of the items that were sold in that time frame (plus the taxes).

For each item it's basically ----> [(sell price+tax) * (qty sold)]

Shouldn't it be pretty simple to provide a report using a similar formula like this ---->  [(buy price) * (qty sold)]

our current POS supports cost of goods averaging and included these totals on daily/monthly reports for accounting.  Our accountant has told us that this is not necessary though.  She works with many businesses that just track their spending on inventory & inventory levels at the beginning/end of each month or year and use the difference as cost of goods.

Also, there's more to this person's idea that I'd like to add.

As another has said... This. 100%

This. 100%