1. Calendar Setup

1.1. Prerequisites for Calendar Setup

Complete the attached worksheet and   "Mark as Completed RoadMap Section B Item 1-b"  before continuing the setup. 

 


User MUST have full rights to the "System Setup"  in System Security .  Users with “Supervisor Rights” will automatically have access.  
 
 

 
1.2. Introduction for Calendar Setup
Administrative and Production calendar sections consist of three parts. They are: Company Holiday setup, Work Days setup, and Calendar Date Ranges setup.  This setup section will generate a calendar, which is referred to by ManEx for calculating delivery days, lead times, due dates, MRP actions and much more.  

ManEx recommends that the user maintain a minimum of at least two years of calendar data ahead of the current date.  If the user places a purchase order a year in advance and the generated calendar range is not enough to cover the range, then the system will generate an incorrect schedule.    Likewise, the user should have at least six months in the past, otherwise any MRP actions that show up as being required beyond that date will provide erroneous information. 

However ManEx recommends that the user does NOT setup an extensive amount of calendar years.  Having extensive calendars (both accounting and production) will slow down operations in each. More specifically, MRP has to determine from the production calendar all of the possible dates necessary for production schedules. With larger files, it takes a little longer to find the target information.  In accounting, each time they post and close, accounting makes a record for every account, for every period in the accounting calendar.  So the fewer periods set up, the faster the process of updating the accounting records.
1.3. Fields and Definitions for Calendar Setup
 
Working Days Selection Grid  -    This section is to tell the system how many standard work days are available each week (exclusive of holidays) for all functioning operations. All computations for deliveries, action dates and resource availability are based on this information. 
 
 
Day of the Week
Administrative Checking the boxes in this column indicates that this weekday is to be a regularly scheduled workday for the administrative department
Production Checking the boxes in this column indicates that this weekday is to be a regularly scheduled workday for the production department
 
Company Holiday List
 
Holiday Displays a list of the Holiday Name's setup
Day/Month Displays the day and month setup for the holiday listed 
Occurance of the Day in the Month  This displays the Day in the Month the Holiday falls on 
Day of the Week This displays the Day of the Week the Holiday falls on
Offset from the Day of the Week This displays the number of days offset from the Day of the Week the Holiday falls on 
 
Enter Holiday Name Name of the Holiday you are Adding to the Company Holiday List 
Enter Day (Fixed Date Holiday Only) Fixed Date of the month the Holiday is On
Enter Month # Number of Month the Holiday is In
Select a Day of the Week (Floating Date Holiday Only)
Select from the pull down the Day of the Week (such as Monday, Tuesday, etc) the Holiday falls on if the Holiday is driven by a day of the week rather than a specific date
Select Occurance of the Day in the Month
(Floating Date Holiday Only
)
Select from the pull down the Occurance of the Day in the Month if the Holiday is driven by a day of the week rather than a specific date  (such as second Tuesday or Third Monday, etc)
Enter # to offset from the Day of the Week entered above
(Floating Date Holiday Only)
Enter the number to offset from the Day of the Week entered for a Floating Date Holiday
 
Depress the button to generate the Holiday dates
 
 
1.4. How To ..... for Calendar Setup
1.4.1. Setup the Admin/Production Calendar

Enter SQLSYSSETTING.EXE   (within the ManEx root directory)  
This action will then prompt the user for a password
The following screen will be displayed,  enter the General Setup/Admin/Production Calendar Module  

The following screen wiil be displayed:

Working Days Selection Grid

To modify this screen, the user must click on the Edit button and supply the password. That action will enable the screen.
 
This screen determines which weekdays will be considered as available for resources for the Administrative and/or Production.  User may check the box if the day should be considered or is available or leave it unchecked of the day should NOT be considered or will NOT be available.



 

COMPANY HOLIDAYS

The user may Add, Edit or Delete holidays by using the action buttons. 

To ADD a holiday user must click on the ADD action button and supply the password.  That action will enable the Holiday Information fields.




Enter the Holiday Name, if the Hoilday is the same date every year (Fixed Date Holiday)  and NOT based on the same day of the year, user would enter in the date of the holiday and the Month of the holiday.  Select to "Repeat Every Year"  or  "Selected Year Only".  Select the Starting Year and Ending Year.  Check if the Company is to Observe the Holiday being entered.  Once all this has been completed depress the "Save" changes or "Abandon Changes" action button. 

If changes have been saved the "Generate Holiday Dates" button will become available.  Depress the "Generate Holiday Dates" button and the Holiday dates will be created as displayed below:




If the Holiday is the same day of the year so the date fluctuates then the user would select a day of the week fron the pull down, select the Occurrence of the Day in the month (such as First, Second, Third, Fourth, or Last) and enter the Month the Holiday is in. 

Select to "Repeat Every Year"  or  "Selected Year Only".  Select the Starting Year and Ending Year.  Check if the Company is to Observe the Holiday being entered.  Once all this has been completed depress the "Save" changes or "Abandon Changes" action button. 

If changes have been saved the "Generate Holiday Dates" button will become available.  Depress the "Generate Holiday Dates"  and holiday dates will be created as displayed below:




To EDIT Holiday Information
 
Highlight the holiday you want to edit, depress the Edit button and the Holiday information will become editable
 
 
Once user has made the changes, depress the Save action button and depress the "Generate Holiday Dates" button to refresh the screen with the changes.


To DELETE a Holiday 

Highlight the holiday you want to remove or delete (Example July 4th)



Depress the Delete action button the following message will be displayed:

 

Depress Yes to Continue (notice that the Holiday (July 4th) has been removed from the Company Holiday List screen to the right but has NOT been removed from the Holiday Dates screen to the left)



User MUST depress the "Generate Holiday Dates"  to refresh the Holiday Dates screen.  Once this button has been depressed the (July 4th) dates will be removed from this screen also, as displayed below.




 
"Mark as Completed RoadMap Section B Item 1-b"
 
Where Used:  All activities that consider available work days.
 
 
 
1.5. Reports for the Calendar Setup

To obtain the AP Aging Reports within the Web, select the WEB Print button from the ManEx action buttons at the top of the screen. For further detail on How the Reports work within the Web refer to Article #5477.


Note: In order to access the Reports within the Web the Company Root URL must be setup within the System Appearance module and user must be linked to web within the System Security Module.   


Select the Report Type:  HOLIDAYS - A List of Reports will be displayed that are available on the Web for HOLIDAYS


To obtain the Holiday Reports within the desktop, select the Print button from the ManEx action buttons at the top of the screen.


The following reports screen will display a list of reports that are available on the ManEx Desktop: 

 
 

Highlight the Holiday List Report and depress the OK button, the following screen will appear:

 
 
 
Highlight the Calendar Year and depress the > button.  To select All of the Calendar Years listed, depress the >> button.   

Depress the OK button.

The following report is available: