The "Fiscal Period" query allows you to define the current fiscal period. This is needed if one or more of your source queries is designed to limit rescanning based on the open fiscal period.
Remove the check next to to "Use Template" to allow custom editing. Now, you may click on "Edit..." to use the built-in editor. Refer to Using the Query Designer reference for more details.
This query should only return one row. It must return a scan code that can be referred to by source scanners that are configured to rescan within the open fiscal period.
Note: The scan code returned does not necessarily need to refer to a fiscal period, per se. Scan codes are very versatile. They can be used to represent values of many different kinds. Be creative in the use of this feature when you need a scan code that can be queried dynamically from the source database. Using this query to determine the open fiscal period and configuring rescanning to be based on it is just the most obvious use of this feature. |