The open sales order report works very well for any point in time. However, I want to go back in time and compare my open orders from prior months/years. How can can create an open order report that will give me what was open at any point in time in history?
This is a standardized reporting function. If the report offers it, of course. Run any report, then use Customize and look bottom right of the display tab. If there is a button here for "Advanced" click it. This is where you find any Advanced Options, including the choice of As Of Report Date, or As Of Current. Not all reports offer this Advanced button and the options here will be specific to the report, if it exists at all. For instance, this button is how you select for the Financial reports to include all rows or columns even if the account value is 0, or exclude balance sheet accounts that are at 0.
Doing that will provide the open orders as of the report date but only if those orders are still open as of today. If the orders open today were not placed yet in the prior period, they do not show up on the prior period report. Therefore, as I go back in time with the report date the open orders are reduced. I want to know what the historic open orders were as of a given date in the past. For example, I would like to know what the Dec 2017 open orders were at that time and compare that to open orders as of Dec 2018.
If I run the report today (Dec 2018) and put the date of Dec 2017, it will show me the open orders as of Dec 2017 but only if they are still open today in Dec 2018. I am happy to run more than one report but it is not showing me what was open at that time. How can I run a report today - Dec 2018 - to show me what was open as of Dec 2017?