Sales Price Calc from Cost In Inventory (like COGS) NOT Just Last Cost
Currently Sales price, if calculated by the system, is based off the Last Cost. This works, EXCEPT when the Last Cost is LESS than the cost of the items sitting in inventory, in which case you would be selling those old items at a loss! The current work around is a manual report to identify the items being purchased that are less than the previous cost and we then have to manually update the Last Cost. To allow the system to be totally mechanical when pricing, why can't the Selling Price be calculated off of the Cost in inventory? In other words, just like the Cost of Goods Sold is calculated off the cost of the item in inventory, can the Selling Price also be set up the same? For example, if you have an inventory item purchased at $2.00 and then you purchase more in inventory at $1.50 -- the COGS will calculate based off of the $2 and the $1.50 -- why can't the selling price be calculated the same instead of only off the last cost of $1.50 as it is today? This would eliminate the need to manually update the last cost so when you sold the $2.00 items you didn't lose money. We would always also need the ability to override the cost for those scenarios where we purchased items at a deep discount and we didn't want to pass that on to the customer.
Thanks for the suggestion!
I have submitted this to programming for further review.