Calendar Selection Pre-Filter
The Calendar Selection pre-filter is used to generate various calendars that provide access to perform many different functions across Deacom, including viewing and modifying orders and Jobs, scheduling orders for warehouse Docks, scheduling Routings for production operations, viewing information pertaining to on hand inventory levels, printing shipping or productions reports, issuing and reserving material, closing Jobs, etc. The fields and options available to the pre-filter differ depending on the "Report Type" selected. The table below details all fields and options available when toggling between the various "Report Type" options. Best practice information for configuring the options used in the calendars is available via Using Inter-Company Transfers, Configuring Availability and Availability Exceptions, Configuring Operations, Routings, and Sequences for Production Jobs and information on using the calendars themselves is available via Scheduling Warehouse Docks, Scheduling Production Jobs, Using the Master Production Calendar, Using the Job Calendar, Using the Optimization Function.
System Navigation
- Sales > Calendar
- See also: Sales Inventory Calendar
- Inventory > Dock Calendar
- See also: Planned On Hand Calendar
- Production > Calendar
- See also: Job Inventory Calendar
- See also: Master Production Calendar
Calendar Selection pre-filter
| Field | Description |
|---|---|
| Report Type |
Pick list used to select the kind of calendar to generate.
|
| Order Type |
Pick list used to select which orders or Jobs should be included in the calendar output. When the "Report Type" is set to Job Inventory, Jobs, or Master Production, options are: All, Maintenance, Production. When the "Report Type" is set to Planned On Hand, Sales, or Sales Inventory, options are: Inter-Company Transfer, On Hold, Quote, SO Engineering, Sales Order, Sales Order and SO Engineering, Sales Order and Inter-Company Transfer. |
| Capacity Calculation |
Search field used to select a User Calculation that will determine the default order/Job scheduling unit. The default selection is set via the "Default Job Sched." and "Default Sales Sched." fields in Production Options. |
| Date Based On |
Pick list used to determine the date that should be used to generate the calendar output. When the "Report Type" is set to:
|
|
Start/End Date |
Used in conjunction with the "Date Based On" field to set the date parameters for the calendar output when the "Report Type" is set to Planned On Hand. |
|
Save Date |
Pick list used to determine how the date will be saved when orders/Jobs are moved on the calendar.
|
|
Units Per Day |
Defines the number of order/Job units that are the daily quota or capacity. Days with orders/Jobs totaling more than the value in this field will display in red. The default value is set via the "Job Units Per Day" and "Sales Units Per Day" fields in Production Options. |
|
Pixels Per Hour |
Defines how wide the hours fields/columns will be on the generated calendar, with a minimum value of "1". Only available until version 16.06.029. Beginning in version 16.06.030, the addition of more options in the Schedule Type field have replaced the functionality of this pre-filter selection. |
|
Snap Minutes |
Pick list used to determine if the time floor for assigning orders or Jobs to the calendar should be set to 1, 5, 10, 15, 30, or 60. Useful in situations when dragging an order or Job around and it should snap to the first available time on that day. The default selection is "15". Example: If the value in this field is "60", dropped Jobs on a given date will be assigned the start of the hour in which it was dropped. That means dropping a Job at 4:55 will assign it a start time of 4:00. |
|
Schedule Type |
Pick list used to determine if the calendar will show in Day View, Week View or Month View depending on the calendar type selected. When set to "Month View", the "Monthly Job Field 1-3" fields in Production Options may be used to determine what information is displayed on the Jobs calendar.
|
|
Shop Area |
Search field used to filter the Jobs displayed to those assigned to the selected Shop Area. |
|
Work Center Type |
Search field used to filter the Jobs displayed to those that have Routing sequences assigned to any Work Centers included in the selected Work Center Type. |
|
Work Center |
Search field used to filter the Jobs displayed to those that have Routing sequences assigned to the selected Work Center. |
|
Job Category |
Search field used to filter the Jobs displayed to those assigned to the selected Job Category. |
|
Facility |
If selected, only orders/Jobs for the Facility specified will be displayed on the calendar. When generating a calendar without a Facility or Facility Group filter, inventory availability is based on all inventory on hand. This is generally acceptable when Facilities are located adjacent to or inside of one another and inventory can be easily moved. For situations where inventory cannot be easily moved between Facilities, a specific Facility or Facility Group should be selected on the pre-filter. |
|
Facility Group |
If selected, only orders/Jobs whose Facilities belong to the Facility Group specified will be displayed on the calendar. When generating a calendar without a Facility or Facility Group filter, inventory availability is based on all inventory on hand. This is generally acceptable when Facilities are located adjacent to or inside of one another and inventory can be easily moved. For situations where inventory cannot be easily moved between Facilities, a specific Facility or Facility Group should be selected on the pre-filter. |
|
Work Flow Type |
Search field used to filter the orders/Jobs displayed based on assigned Work Flow. |
|
Sequence |
Search field used in conjunction with the "Work Flow Type" field to filter the orders/Jobs displayed based on current Work Flow Sequence. Only orders/Jobs that do not have the specified Sequence marked as complete will be displayed on the calendar. |
|
Part Number |
Search field used to filter the orders/Jobs displayed to only those that contain the selected Part. |
|
Part Starts With |
Filters the orders/Jobs displayed to only those that contain Parts that begin with the string entered in this field. |
|
Category |
Search field used to filter the orders/Jobs displayed to only those that contain Parts that belong to the selected Category as defined on the Item Master General 1 tab. |
|
Sub- Category |
Search field used to filter the orders/Jobs displayed to only those that contain Parts that belong to the selected Sub-Category as defined on the Item Master General 1 tab. |
|
Item Planner |
Search field used to filter the orders/Jobs displayed to only those that contain Parts that have the selected Item Planner assigned on the Item Master General 1 tab. |
|
Inventory Account |
Search field used to filter the orders/Jobs displayed to only those that contain Parts that have the selected Inventory Account. |
|
Unavailability |
Pick list used to determine how downtime is displayed. Options are:
The Planned On Hand output uses the same logic as the Master Production calendar for blackouts. This means that Availability, Availability Exceptions, and MRO Jobs with unavailability level all apply. |
|
On Hand Based On |
Pick list used when "Report Type" is set to Planned On Hand to determine if the on hand calculation will be based on start or end.
|
|
Entered By |
Search field used to filter orders/Jobs based on the User who entered them. |
|
Bill-to Company |
Search field used to filter the list of Sales Orders displayed based on the Bill-to Company used on the order. |
|
Ship-to Company |
Search field used to filter the list of Sales Orders displayed based on the Ship-to Company used on the order. |
|
Ship From Company |
Search field used to filter the list of Sales Orders displayed based on the Ship From Company specified on the Misc 1 tab of the Sales Order. |
|
Billing Group |
Search field used to filter the list of Sales Orders displayed based on the Billing Group specified on the Misc 2 tab of the Sales Order. |
|
Sales Rep |
Search field used to filter the list of Sales Orders displayed based on the Sales Rep assigned on the Sales Assignments tab of the Sales Order. |
|
Sales Group |
Search field used to filter the list of Sales Orders displayed by Sales Rep(s) assigned on the Sales Assignments tab of the Sales Order that belong to the selected Sales Group. |
|
Ship Via |
Search field used to filter the list of Sales Orders displayed based on the Ship Via selected on the Misc 1 tab of the Sales Order. |
|
Sales User 1-5 |
Search field used to filter the list of Sales Orders displayed based on the Sales User 1-5 selections on the Misc 2 tab of the Sales Order. |
|
Progress Billing |
Search field used to filter the list of Sales Orders displayed based on the Progress Billing order selected on the Misc 1 tab of the Sales Order. |
|
Item Search 1-5 |
Search field used to filter the orders/Jobs displayed to only those that have the selected Item Search 1-5 values defined on their Item Master User Fields tab. |
|
Bill-to PO |
Search field used to filter the list of Sales Orders displayed based on the Bill-to PO entered on the General tab of the Sales Order. |
|
Ship-to PO |
Search field used to filter the list of Sales Orders displayed based on the Ship-to PO entered on the General tab of the Sales Order. |
|
Project |
Search field used to filter the list of Sales Orders displayed based on the Project selected on the Misc 1 tab of the Sales Order. |
|
Right Click |
Pick list used to dictate the action that occurs when the user right clicks a record on the calendar. Options are: Modify - Opens the detail form for the clicked order in modify mode. View Detail - Opens the detail form for the clicked order in view mode. |
|
Inventory |
|
|
Over Issue |
Option to have over issue percentages considered for job requirements and colors. Options are Include (default) and Exclude. Only available when using a Report Type of "Job Inventory". |
|
Increment Minutes |
Specifies the time interval, in minutes, used to divide each day into time slots (or "buckets") on the Planned Onhand calendar report. Each time slot represents a discrete window of time within which scheduled sales order shipments and job finishes are grouped for display and on-hand inventory calculations.
|
|
Job Finishes |
Pick list used to show or hide Jobs that have material finished. |
|
Sales Shipments |
Pick list used to show or hide Sales Orders that have material shipped. |
|
Operations |
Pick list used to filter based on the status of the "Operation Complete" checkbox on Job Routing Sequences. Operations are All, Complete, and Incomplete.
|