Script TRTSEL: X3 connection properties

ITM_CRIT: Addition of criteria for product auto-selection

Context and operating mode

Transaction

There is no transaction in process.

Log file

There is no open log file.

Code context

This entry point is called after loading the criteria used to filter the automatic selection of products. You can use it to complete the filter that is applied to products.

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 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:AXX]TEXTE),"'UPVAL'")<>0)'
CRITERE -= '| (toupper([F:ITM]EANCOD)="'+UPVAL+'"))'

ITP_CRIT: Addition of criteria for product auto-selection

Context and operating mode

Transaction

There is no transaction in process.

Log file

There is no open log file.

Code context

This entry point is called after loading the criteria used to filter the automatic selection of products. You can use it to complete the filter that is applied to products, including the product-supplier data.

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 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:AXX]TEXTE),"'UPVAL'")<>0)'
CRITERE -= '| (toupper([F:ITM]EANCOD)="'+UPVAL+'"))'

ITV_CRIT: Addition of criteria for product auto-selection

Context and operating mode

Transaction

There is no transaction in process.

Log file

There is no open log file.

Code context

This entry point is called after loading the criteria used to filter the automatic selection of products. You can use it to complete the filter that is applied to products, including the sales product data.

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 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:AXX]TEXTE),"'UPVAL'")<>0)'
CRITERE -= '| (toupper([F:ITM]EANCOD)="'+UPVAL+'"))'
CRITERE -='& [F:ITM]ITMSTA=1'

BPC_CRIT: Addition of criteria for customer auto-selection

Context and operating mode

Transaction

There is no transaction in process.

Log file

There is no open log file.

Code context

This entry point is called after loading the criteria used to filter the automatic selection of customers. You can use it to complete the filter that is applied to customers.

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 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

Context and operating mode

Transaction

There is no transaction in process.

Log file

There is no open log file.

Code context

This entry point is called after loading the criteria used to filter the automatic selection of suppliers. You can use it to complete the filter that is applied to suppliers.

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 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

Context and operating mode

Transaction

There is no transaction in process.

Log file

There is no open log file.

Code context

This entry point is called after loading the criteria used to filter the automatic selection of business partners. You can use it to complete the filter that is applied to business partners.

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 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'