Script TRTSEL : X3 connection properties
ITM_CRIT: Addition of criteria for product auto-selection
This entry point is called after loading the criteria used to filter the automatic selection of products. You use it to complete the filter that is applied to products.
Context and operating mode
Transaction
There is no transaction in process.
Log file
No log file is opened.
Different call cases
To complete the filter on products, you need to use the CRITERE variable and the data from the [F:ITM] table.
For example, to exclude non-usable products from the selection you would write:
CRITERE += '&[F:ITM]ITMSTA<>6'
You can also choose to rewrite the CRITERE variable completely. If you do so, the variable should contain at least the standard filter, as follows:
CRITERE = '((left$([F:ITM]ITMREF,' + num$(len(UPVAL)) + ')="'+UPVAL+'")'
CRITERE -= '| (pat(toupper([F:ITM]ITMDES1),"*'+UPVAL+'*")<>0)'
CRITERE -= '| (toupper([F:ITM]EANCOD)="'+UPVAL+'"))'
ITP_CRIT: Addition of criteria for product auto-selection
This entry point is called after loading the criteria used to filter the automatic selection of products. You use it to complete the filter that is applied to products, including the product-supplier data.
Context and operating mode
Transaction
There is no transaction in process.
Log file
No log file is opened.
Different call cases
To complete the filter on products, you need to use the CRITERE variable and the data from the [F:ITM] table.
For example, to exclude non-usable products from the selection you would write:
CRITERE += '&[F:ITM]ITMSTA<>6'
You can also choose to rewrite the CRITERE variable completely. If you do so, the variable should contain at least the standard filter, as follows:
CRITERE = '((left$([F:ITM]ITMREF,' + num$(len(UPVAL)) + ')="'+UPVAL+'")'
CRITERE -= '| (pat(toupper([F:ITM]ITMDES1),"*'+UPVAL+'*")<>0)'
CRITERE -= '| (toupper([F:ITM]EANCOD)="'+UPVAL+'"))'
ITV_CRIT: Addition of criteria for product auto-selection
This entry point is called after loading the criteria used to filter the automatic selection of products. You use it to complete the filter that is applied to products, including the sales product data.
Context and operating mode
Transaction
There is no transaction in process.
Log file
No log file is opened.
Different call cases
To complete the filter on products, you need to use the CRITERE variable and the data from the [F:ITS] and [F:ITM] tables.
For example, to include only the products managed in stock you would write:
[F:ITM]SERMGTCOD=1
You can also choose to rewrite the CRITERE variable completely. If you do so, the variable should contain at least the standard filter, as follows:
CRITERE = '((left$([F:ITM]ITMREF,' + num$(len(UPVAL)) + ')="'+UPVAL+'")'
CRITERE -= '| (pat(toupper([F:ITM]ITMDES1),"*'+UPVAL+'*")<>0)'
CRITERE -= '| (toupper([F:ITM]EANCOD)="'+UPVAL+'"))'
CRITERE -='& [F:ITM]ITMSTA=1'
BPC_CRIT: Addition of criteria for customer auto-selection
This entry point is called after loading the criteria used to filter the automatic selection of customers. You use it to complete the filter that is applied to customers.
Context and operating mode
Transaction
There is no transaction in process.
Log file
No log file is opened.
Different call cases
To complete the filter on customers, you need to use the CRITERE variable and the data from the [F:BPC] table.
For example, to include only the customers who are authorized to close orders you would write:
CRITERE += '&[F:BPC]ORDCLE=2'
You can also choose to rewrite the CRITERE variable completely. If you do so, the variable should contain at least the standard filter, as follows:
CRITERE = '((left$([F:BPC]BPCNUM,' + num$(len(UPVAL)) + ')="'+UPVAL+'")'
CRITERE -= '| (pat(toupper([F:BPC]BPCNAM),"*'+UPVAL+'*")<>0))'
CRITERE -='& [F:BPC]BPCSTA=2'
BPS_CRIT: Addition of criteria for supplier auto-selection
This entry point is called after loading the criteria used to filter the automatic selection of suppliers. You use it to complete the filter that is applied to suppliers.
Context and operating mode
Transaction
There is no transaction in process.
Log file
No log file is opened.
Different call cases
To complete the filter on suppliers, you need to use the CRITERE variable and the data from the [F:BPS] table.
For example, to include only the suppliers who are authorized to use orders with multiple lines you would write:
CRITERE += '&[F:BPS]SEVLIN=2'
You can also choose to rewrite the CRITERE variable completely. If you do so, the variable should contain at least the standard filter, as follows:
CRITERE = '((left$([F:BPS]BPSNUM,' + num$(len(UPVAL)) + ')="'+UPVAL+'")'
CRITERE -= '| (pat(toupper([F:BPS]BPSNAM),"*'+UPVAL+'*")<>0))'
BPR_CRIT: Addition of criteria for business partner auto-selection
This entry point is called after loading the criteria used to filter the automatic selection of business partners. You use it to complete the filter that is applied to business partners.
Context and operating mode
Transaction
There is no transaction in process.
Log file
No log file is opened.
Different call cases
To complete the filter on business partners, you need to use the CRITERE variable and the data from the [F:BPR] table.
For example, to include only the business partners who are defined as customers you would write:
CRITERE += '&[F:BPR]BPCFLG=2'
You can also choose to rewrite the CRITERE variable completely. If you do so, the variable should contain at least the standard filter, as follows:
CRITERE = '((left$([F:BPR]BPRNUM,' + num$(len(UPVAL)) + ')="'+UPVAL+'")'
CRITERE -= '| (pat(toupper([F:BPR]BPRNAM),"*'+UPVAL+'*")<>0))'
CRITERE -='& [F:BPR]ENAFLG=2'