There are several reasons why you may want to view your stock value at a specific point in time, for example:
-
Tax Purposes
- End of Financial Year reporting
- General Stock Reports and so forth
Retail Express doesn't currently have a report that provides this information as the majority of reports in Retail Express are live (i.e data can be edited at any time, altering the figures for a past date).
The only way to get a true stock value as of a certain date is to either:
While you could try and figure out your stock value as of a certain day by calculation method, we don't recommend it.
Trying to determine the stock by reviewing Sales Data, Purchase Orders, Transfers etc doesn't take into account Stock Adjustments that have been made en-masse or manually within the system. This method is incredibly risky and has a high potential for error.
Understandably it may not be possible to do complete Stocktakes frequently (although if required you could break them down incrementally using filters e.g. brand, or supplier etc).
Tip: The best way is to utilise the Reports within Retail Express. Run these reports on a regular basis, download and store a copy for referral in the future.