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'