Master Data tab

If a number is entered, it displays only work orders having a start date today + the given number of calendar days.

Beas uses the date which you defined in Production position – Start Date. If this was not defined, Beas uses the Start time field of the Production position which is determined automatically during work order creation using backward scheduling.

Important:

This works only if a start date was entered. Delete the entry to remove the filter.

Table fields:

"BEAS_FTPOS"."STARTZEIT". If null: "BEAS_FTPOS"."ANFZEIT"

You can define a customized filter with an SQL statement. Click on the SQL Symbol to define the filter.

In the SQL Editor, all available fields are shown. The filter can be defined and tested.

The code entered is inserted behind “WHERE” and before “ORDER BY”. This filter uses the following tables:

Work order BEAS_FTHAUPT

Work order position BEAS_FTPOS

Item OITM

Example:

Only show items for which the item code starts with "A"

substring ("OITM"."ItemCode",1,1)='A'

Beas marks correct SQL statements with a green flag and incorrect SQl statements with a red flag.

For more Information See SQL Editor

Tips and tricks (sorting, filter, task descriptions) 10/2017

Work orders can be set APS planned, either automatically at calculation of the lead times or in Work order - Settings.

Example :

Only check already calculated WOs: In this case set to "Only planned".

Only WO set to "APS planned" have to be considered (in this case e.g. released). In this case, select "Hide planned".

Selection:

Hide planned: Hide planned work orders.

All: Show work orders.

Only planned: Show only planned work orders.

Sortings can be set up. For the first sorting you can select from a list of templates or enter an SQL-Order-Statement.

The standard sortings are as follows:

manual sorting: Work orders can be sorted using drag & drop per scenario

planned start: Work orders can be sorted by start time of the manufacturing assembly ("BEAS_FTPOS"."STARTZEIT")

Delivery date: Work orders can be sorted by delivery date of the assembly ("BEAS_FTPOS"."LIEFERDATUM")

Document number: Work orders can be sorted by document number and assembly position number

Project: Work orders can be sorted by project number and start time of the manufacturing assembly

Customer: Work orders can be sorted by customer number and start time of the manufacturing assembly

Item: Work orders can be sorted by item (assembly) and start time of the manufacturing assembly

Priority: Work orders can be sorted by priority ID ("BEAS_FTPOS"."ABGKZ")

For the next two criteria the name and the SQL-Order-Statement is to be entered.

Note: No syntax check is performed by Beas. If an invalid value is entered, this leads to error when opening the planning list. The entered sorting templates are displayed in planning view at the end of the templates list.

Tables BEAS_FTPOS, OITM and BEAS_FTHAUPT are available.

Example: "BEAS_FTHAUPT"."AUFTRAG"  sort by order number

To define this, click on the SQL symbol. In the SQL editor you can only see the available tables.

Choose a table and a double-click on all necessary fields

If you execute the SQL statement, you can see  the result.

If you click on update, Beas inserts this information in the scheduling window.

Window sys_sqleditor.psr
 

For more information see SQL Editor.

Tips and tricks (sorting, filter, task descriptions) 10/2017

Note:

If you want to calculate this automatically, for example overnight, you can define an activity.

See Server activities