The In Stock On report is used to calculate the value of your inventory as of a past date. The software will examine item history and make the best possible attempt to ascertain what inventory was on hand on the date specified.
Previously found as an option on most inventory reports, In Stock On was moved to be its own standalone report and now provides more accurate results.
Best Practices/Notes
- For the most accurate figures it is always best to generate your reports in real-time. See our Automated Reports feature for information on setting up your reports to automatically generate on a set schedule.
- Due to the complex nature of rebuilding item history, the farther back the In Stock On date the less accurate the report will be.
- Bulk inventory may be inaccurate if you have manually changed quantities using the Adjust button on the bulk item’s Quantities tab.
• This does not apply to Supervisor or Physical Inventory changes to quantities made using the Missing, Scrapped, or RTV functions. These types of changes are taken into account.
- Running this report for a date that includes inventory data that was converted from another source will lead to inaccurate results.