Agreement Quantity Calculation / Criteria - PAYWEIGHT
This page contains the JSON of the function-set applicable on the Agreement Quantity Calculation / Criteria - Payweight
Note
- The function will determinate the total of Payweight on the document-lines of the type: Goods
- The function will work on both Single Orders as well as Linked Orders.
{
"FunctionSet": {
"TableNo": 11172787,
"DataType": "12799",
"Entries": [
{
"EntryNo": "2500",
"CodeunitID": "11172846",
"FunctionCode": "REF",
"Description": "Get all orders related to Parent Order No.",
"Parameters": [
{
"ParameterName": "TABLENO",
"Value": "11172786"
},
{
"ParameterName": "FUNCTION SET",
"Value": "10022",
"ValueFunctionSet": {
"FunctionSet": {
"TableNo": 11172786,
"Entries": [
{
"EntryNo": "15000",
"CodeunitID": "11172846",
"FunctionCode": "SET VAR",
"Description": "Set Variable: Orders (All orders linked to Partent No.)",
"Parameters": [
{
"ParameterName": "VAR NAME",
"Value": "ORDERS"
},
{
"ParameterName": "VAR VALUE",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172786,
"DataType": "31488",
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "CREATE FILTER STRING",
"Description": "Create Filter wilth OrderNo. based on Parent Doc. No.",
"Parameters": [
{
"ParameterName": "SEPARATOR",
"Value": "|"
},
{
"ParameterName": "TABLENO",
"Value": "11172786"
},
{
"ParameterName": "FIELDNO",
"Value": "2"
},
{
"ParameterName": "FIELD 1",
"Value": "1"
},
{
"ParameterName": "FILTER 1",
"Value": "2"
},
{
"ParameterName": "FIELD 2",
"Value": "79"
},
{
"ParameterName": "FILTER 2",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172786,
"DataType": "31488",
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "FIELD",
"Parameters": [
{
"ParameterName": "FIELDNO",
"Value": "79"
}
]
}
]
}
}
},
{
"ParameterName": "FIELD 3",
"Value": "3"
},
{
"ParameterName": "FILTER 3",
"Value": "0"
},
{
"ParameterName": "READ ISOLATION",
"Value": "1"
}
]
}
]
}
}
}
]
}
]
}
}
},
{
"ParameterName": "FIELD 1",
"Value": "1"
},
{
"ParameterName": "FILTER 1",
"Value": "2"
},
{
"ParameterName": "FIELD 2",
"Value": "2"
},
{
"ParameterName": "FILTER 2",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172787,
"DataType": "31488",
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "FIELD",
"Parameters": [
{
"ParameterName": "FIELDNO",
"Value": "2"
}
]
}
]
}
}
},
{
"ParameterName": "FIELD 3",
"Value": "3"
},
{
"ParameterName": "FILTER 3",
"Value": "0"
},
{
"ParameterName": "FIELD 4",
"Value": "79"
},
{
"ParameterName": "FILTER 4",
"Value": "<>''"
},
{
"ParameterName": "NOT FOUND",
"Value": "1"
},
{
"ParameterName": "READ ISOLATION",
"Value": "1"
}
]
},
{
"EntryNo": "6250",
"CodeunitID": "11172846",
"FunctionCode": "IF VALUE",
"Description": "Calculate Payable Weight on Linked Orders",
"Parameters": [
{
"ParameterName": "VALUE",
"Description": "Determinate if Order is related to a Parent Order",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172787,
"DataType": "34047",
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "COMPARE",
"Description": "Compare Parent Document No. = empty",
"Parameters": [
{
"ParameterName": "VALUE1",
"DataType": "0",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172787,
"DataType": "31488",
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "GET",
"Description": "Get Parent Document No.",
"Parameters": [
{
"ParameterName": "TABLENO",
"Value": "11172786"
},
{
"ParameterName": "FIELDNO",
"Value": "79"
},
{
"ParameterName": "FIELD 1",
"Value": "1"
},
{
"ParameterName": "FILTER 1",
"Value": "2"
},
{
"ParameterName": "FIELD 2",
"Value": "2"
},
{
"ParameterName": "FILTER 2",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172787,
"DataType": "31488",
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "FIELD",
"Description": "Get Document No.",
"Parameters": [
{
"ParameterName": "FIELDNO",
"Value": "2"
}
]
}
]
}
}
},
{
"ParameterName": "FIELD 3",
"Value": "3"
},
{
"ParameterName": "FILTER 3",
"Value": "0"
},
{
"ParameterName": "FINDWHAT",
"Value": "1"
},
{
"ParameterName": "READ ISOLATION",
"Value": "1"
}
]
}
]
}
}
},
{
"ParameterName": "OPERATOR"
},
{
"ParameterName": "VALUE2",
"Value": "",
"DataType": "0"
}
]
}
]
}
}
},
{
"ParameterName": "FILTER"
},
{
"ParameterName": "ON TRUE",
"Description": "Sum Payable weight on order lines of a single order",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172787,
"DataType": "12799",
"Entries": [
{
"EntryNo": "20000",
"CodeunitID": "11172846",
"FunctionCode": "SUM",
"Description": "Sum Payable Weight on Document lines Linked orders",
"Parameters": [
{
"ParameterName": "TABLENO",
"Value": "11172787"
},
{
"ParameterName": "FIELDNO",
"Value": "81"
},
{
"ParameterName": "FIELD 1",
"Value": "1"
},
{
"ParameterName": "FILTER 1",
"Value": "2"
},
{
"ParameterName": "FIELD 2",
"Value": "2"
},
{
"ParameterName": "FILTER 2",
"Value": "ORD2601261",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172787,
"DataType": "31488",
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "FIELD",
"Parameters": [
{
"ParameterName": "FIELDNO",
"Value": "2"
}
]
}
]
}
}
},
{
"ParameterName": "FIELD 3",
"Value": "10"
},
{
"ParameterName": "FILTER 3",
"Value": "1"
}
]
}
]
}
}
},
{
"ParameterName": "ON FALSE",
"Description": "Sum Payable weight on order lines of the Parent order",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172787,
"DataType": "12799",
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "SUM",
"Description": "Sum Payable Weight on Document lines Linked orders",
"Parameters": [
{
"ParameterName": "TABLENO",
"Value": "11172787"
},
{
"ParameterName": "FIELDNO",
"Value": "81"
},
{
"ParameterName": "FIELD 1",
"Value": "1"
},
{
"ParameterName": "FILTER 1",
"Value": "2"
},
{
"ParameterName": "FIELD 2",
"Value": "2"
},
{
"ParameterName": "FILTER 2",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172787,
"DataType": "12799",
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "REF",
"Description": "Verwijs naar de transoportkop ",
"Blocked": "true",
"Parameters": [
{
"ParameterName": "TABLENO",
"Value": "11172786"
},
{
"ParameterName": "FUNCTION SET",
"Value": "10033",
"ValueFunctionSet": {
"FunctionSet": {
"TableNo": 11172786,
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "SET VAR",
"Description": "Set Variable: Orders",
"Parameters": [
{
"ParameterName": "VAR NAME",
"Value": "ORDERS"
},
{
"ParameterName": "VAR VALUE",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172786,
"DataType": "31488",
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "CREATE FILTER STRING",
"Description": "Maak filterstring van alle ordernr's bij de parentorder",
"Parameters": [
{
"ParameterName": "SEPARATOR",
"Value": "|"
},
{
"ParameterName": "TABLENO",
"Value": "11172786"
},
{
"ParameterName": "FIELDNO",
"Value": "2"
},
{
"ParameterName": "FIELD 1",
"Value": "1"
},
{
"ParameterName": "FILTER 1",
"Value": "2"
},
{
"ParameterName": "FIELD 2",
"Value": "79"
},
{
"ParameterName": "FILTER 2",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172786,
"DataType": "31488",
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "FIELD",
"Parameters": [
{
"ParameterName": "FIELDNO",
"Value": "79"
}
]
}
]
}
}
},
{
"ParameterName": "FIELD 3",
"Value": "3"
},
{
"ParameterName": "FILTER 3",
"Value": "0"
},
{
"ParameterName": "READ ISOLATION",
"Value": "1"
}
]
}
]
}
}
}
]
}
]
}
}
},
{
"ParameterName": "FIELD 1",
"Value": "1"
},
{
"ParameterName": "FILTER 1",
"Value": "2"
},
{
"ParameterName": "FIELD 2",
"Value": "2"
},
{
"ParameterName": "FILTER 2",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172787,
"DataType": "31488",
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "FIELD",
"Parameters": [
{
"ParameterName": "FIELDNO",
"Value": "2"
}
]
}
]
}
}
},
{
"ParameterName": "FIELD 3",
"Value": "3"
},
{
"ParameterName": "FILTER 3",
"Value": "0"
},
{
"ParameterName": "FIELD 4",
"Value": "79"
},
{
"ParameterName": "FILTER 4",
"Value": "<>''"
},
{
"ParameterName": "NOT FOUND",
"Value": "1"
},
{
"ParameterName": "READ ISOLATION",
"Value": "1"
}
]
},
{
"EntryNo": "20000",
"CodeunitID": "11172846",
"FunctionCode": "VAR",
"DataType": "31488",
"Parameters": [
{
"ParameterName": "VARIABLE",
"Value": "ORDERS"
}
]
},
{
"EntryNo": "30000",
"CodeunitID": "11172846",
"FunctionCode": "MESSAGE",
"DataType": "0",
"Blocked": "true",
"Parameters": [
{
"ParameterName": "MESSAGE",
"ResultFunctionSetID": {
"FunctionSet": {
"TableNo": 11172787,
"DataType": "31488",
"Entries": [
{
"EntryNo": "10000",
"CodeunitID": "11172846",
"FunctionCode": "VAR",
"Parameters": [
{
"ParameterName": "VARIABLE",
"Value": "ORDERS"
}
]
}
]
}
}
}
]
}
]
}
}
},
{
"ParameterName": "FIELD 3",
"Value": "10"
},
{
"ParameterName": "FILTER 3",
"Value": "1"
}
]
}
]
}
}
}
]
}
]
}
}