Hi all
I'm sure I'm missing something obvious but can't seem to find an answer on the forum for this.
The Background:
I have a recipe and inventory workbook for a restaurant with inventory pricing and recipe pricing
I'm also adding in inventory usage and stock monitoring over time. The issue comes in when stock prices for individual items [change
For example:
I do a stock count on Monday and the system pulls all the prices from the inventory sheet and calculates the value.
during the week the accountant adds purchases and updates the current price of every item
On Friday when we count again, the price is pulled from the inventory and the current stock value is recorded.
The Problem: as we change the inventory pricing, the previous stock values (ie Monday) also change as the pricing is dynamic
What i need:
I'm looking for the best way to set this up that is smooth and idiot proof and doesn't really involve the accountant copying and pasting 'as values' as if he does this wrong once and I miss it, I can see it messing everything up.
So how do I ensure that stock value at a given date is 'frozen' for that date so that future values can be compared correctly?
Thanks for any input.
Bookmarks