Reporting Calendars are used within the Product Sales Analysis & Customer Sales Analysis reports to determine when a Year, Month, or Week begins for a specific ending report date. Use the Reporting Calendars screen to create and edit Reporting Calendars..
Pre-Requisites
None
Step-by-Step Guide
Access the Master module.
Click Miscellaneous.
Click Reporting Calendars.
Under the top grid for "Select Calendar Name", click the Add button.
A new blank entry will be added in the top grid. Enter a Name for the Calendar. For example:
...
“Our New Calendar”
Click Save.
Under the bottom grid for "Set Weeks and Periods", click the Add button.
Enter a Year value. For example:
...
2024
Select a Start Date value. For example:
...
12/
...
31/
...
2023
The start date will be the first date of your calendar year. For example, if your fiscal accounting period year begins on
...
12/
...
31/
...
2023 for the
...
2024 year, you would enter
...
12/
...
31/
...
2023 here. However, if you wanted to create a "Calendar" calendar (1/1/
...
2024 to 12/31/
...
2024) you would enter in 1/1/
...
2024.
Specify a Weeks value. For example: 52
Specify a Periods value. For example: 12
Click Save.
Click the ... ellipses button next to the newly created year.
The system will automatically create a row for each period based upon the Start Date specified.
For the first line, specify the Period's End Date. Using the example above, we might state that
...
, Period #1, ends on
...
1/
...
27/
...
2024.
After specifying an End Date on one row, click on the End Date field on the next row.
The system will automatically calculate the State Date for that period based upon the End Date of the Previous period.Repeat the steps for each row until completed.
Click Close.
Click Yes to save the changes.
Optional: Go to Step #7 for any additional years you wish to create.
Click Close to exit the screen.
You should now be able to select this Reporting Calendar within the sales report wizards.