Hello,
I've been using RMS for a couple of years now. When we receive items into our database, we enter the actual cost and price of the item into the system. If, during the year, the cost of the item changes, we change the cost and price of the item to reflect the new numbers. In the meantime, we have sold some items at the old cost(actual) and price and some at the new cost(current) and price. Very frequently we receive additional identical items into the system with updated costs. Since they are identical items with identical SKU's, they are all mixed together, even though they have different costs.
My bookkeeper is horrified that I just change the cost of an item, as it does not reflect the actual cost of the item sold. She is concerned with having accurate COGS numbers. I need to keep my database up to date with current costs and prices.
I think this might be to much to explain here, but could someone please direct me to a guide or info source that would explain how I can keep my database updated with current cost and price, while maintaining the ability to report on actual costs of items sold.
Thank you,
Scott...
*This post is locked for comments
I have the same question (0)
