Function Set Entries
General
By setting up Function Set Entries a range of flexible functions can combined to be used in StatusTemplates, Steps and some specific fields, for example the Invoice Info Description Code on the Customer.
Example of a Function Set Entries:
| Field | Description |
|---|---|
| Codeunit ID | Select from a list the required Codeunit |
| Function Code | Select from a list the required Function Code |
| Description | The description related to the Function Code |
| Parameter Values | The statement based on the parameters as entered on the Tab:Parameters |
| Table No. | The table on which the |
| Tabele Filter | Select from a list the required Table on which the Function Set Entries is to be applied |
| Blocked | When True this line is no longer excecuted |
| End Execution | Select Always or When Result Found to stop the excecution of the Function Set Entries |
| On Different Table No. | Select the reuired option from the list |
Note
Function Set Entries can be copied by using the actions Copy Last Function Set. To copy a Function Set Entries from a RAPP-environment to a PROD-environment use the action: Copy Json to Clipboard in the RAPP, go to the PROD, click on the action Edit Json and paste the set
List of functions sets
The following table contains a number of functions. By clicking on the link a page with the Json-code can be opened so it can be coppied to 3PL Dynamics.
| Applicable Area | Value | Result function Set | ||||
|---|---|---|---|---|---|---|
| Agreement Quantity Calculation / Criteria | CONDITION ADR | The function checks if the goods lines on the Order contains Hazardous in the field: No.. If so the Condition: ADR will be applied | ||||
| Agreement Quantity Calculation / Criteria | CONDITION TAIL LIFT | The function checks if the *from- *or *to-address *on the Order contains a Condition. If so the Condition: TAIL LIFT will be applied | ||||
| Agreement Quantity Calculation / Criteria | CONDITION Unloading Strickt | The function checks if the time-window between unloading time from and unloading time to on the Order is less then 15minutes. If so the Condition: UL STRICKT will be applied | ||||
| Agreement Quantity Calculation / Criteria | CONDITION Unloading 09:00h | Will check if the unloading time to on the Order is before 09:00 hours. If so the Condition: UL UPTO 09 will be applied | ||||
| Agreement Quantity Calculation / Criteria | EXTRA_STOP | Filters orders within the linked order, not being the order with the highest value in field:Kilometer. This function will apply each suborder as as stop. | ||||
| Agreement Quantity Calculation / Criteria | FIXED | Function will always return 1 so can be used if only 1 price is set in a contract detail line. | ||||
| Agreement Quantity Calculation / Criteria | FUEL_SURCHARGE | Calculates the amount of fuel surcharge based on the Fuel Clause. | ||||
| Agreement Quantity Calculation / Criteria | KM_MAX | Filters the order with the highest value in field:Kilometer within the linked orders. | ||||
| Agreement Quantity Calculation / Criteria | KM_TRIP | Returns the numnber of kilometers on a trip. The parameter used will select either the planned, actual or agreed number of Kilometers | ||||
| Agreement Quantity Calculation / Criteria | SECTION_FIRST | Determinates if a section is the first section of an order. | ||||
| Agreement Quantity Calculation / Criteria | SECTION_NOT_FIRST | Determinates if a section is not the first section of an order. | ||||
| Agreement Quantity Calculation / Criteria | UNLOADAM | Will check if a condition is set on the order so a surcharge can be applied. | ||||
| Agreement Quantity Calculation / Criteria | UOM_QTY | Returns the total quantity of the the specified UOM on the order. | ||||
| Agreement Quantity Calculation / Criteria | WEEKEND | Will chekc if an order. is (un)loaded on the days set in the parameters of the function. | ||||
| Devices | NEW_TASK_ACT | Creates a task to send the planned activities of a trip to a device. | ||||
| Devices | DEL_TASK_ACT | Creates a task which removes planned activities of a trip which were previously sent to a device | ||||
| Devices | GET INTERNAL VALUE | Determinates which Internal Value is applicable based on a external value received in a Device Activity | ||||
| Devices | COPYSTR | Converts the first 10 charactres of a field to a new value | ||||
| Invoice Info Description Code | DOCNO. | A string with the documentnumer on which the revenue is based | ||||
| Invoice Info Description Code | EXT_DOC_QT | A string with the the external document number and quantity on which the cost is based | ||||
| Invoice Info Description Code | UOM_QTY_AR | A string with the Unit Of Measure Code, The Quantity and the Area based on the agreement on which the revenue is based | ||||
| Sections | GET_DEPARTMENT | Determinates the Department on a section based on the Routingstrategy | ||||
| Sections | GET_PLAN_DEPARTMENT | Determinates the Plan Department on a section based on the Routingstrategy | ||||
| Sections | GET_PLANBOX | Determinates the Plan Box on a section based on the Routingstrategy | ||||
| Sections | NORM_TIME | Calculates the norm times on sections based on the Norm time Strategy | ||||
| Status template | STATUSCHANGE_ON_REVENUE | The status of the order will be changed depending on wether there are revenue lines. | ||||
| Transport Conditions Code | MAX_LENGTH_WIDTH_HEIGHT | Adds a condition to the order or section with the maximum length, width and height. | ||||
| Trip (TMS) | EMISSION_CALCULATE | Will calculate the emission on a Trip and device the emission-entries over the Sections planned on the Trip. | ||||
| Trip (TMS) | EMISSION_METHOD | Defines on what method the emissions are based on at Trip. | ||||
| Trip (TMS) | FILTER_ON_TRIPS_BASED_ON_SHIPMENTS | Applies a filter so only Trips based on Shipments will be processed. | ||||
| Trip (TMS) | SEND_WHAT_SAPP_MESSAGE | Creates device task log which sends a What's App Message to the driver of the trip with a tripreport. | ||||
| Trip (TMS) | SET_TRIP_ACT_DATE_TIME | Copies the actual starting date/time and ending date/time from the boardcomputerlog to the Trip-header. | Visual Planning | LAYER_FILTER | filters the unplanned section on Loadmeter<=3 |