AUTINVTFIL: Add selection criteria on the transfer documents to be invoiced

This entry point is used to insert additional logic during the definition of the selection criteria for the stock transfer documents to be invoiced.  

It is used to add additional filters on these documents.

It is called in the automatic invoicing of stock transfer documents process FUNAUTINVT.

Context and operating method

Transaction

There is no transaction in process.

Log file

No log file is open yet because this is still the selection phase for the transfer documents.

Call context

This entry point is called during the selection criteria definition.

Available variables and masks

The selection mask for the transfer documents [M :DIA] (SAUTINVT) is still available.

The standard criteria are loaded in the CRITERE variable. They concern the stock change header file (SCHGH).

The FILSUP variable has been created to add additional criteria. It has a length of 250 characters. To aid the functioning during the evaluation, FILSUP is initialized to the string "1=1" if it has not been loaded by the entry point.

It is sufficient to complete it in the entry point.

For instance     : Add an additional filter on the currency that must be "EUR".

FILSUP -= ‘ & CUR =  "EURI"’

FILSUP is evaluated at the same time as CRITERE during the filter on the SCHGH file. The criteria must relate to the fields in the SCHGH file.

 

Open tables

In the table below, the significant content flag indicates that the content is in phase with the context. Traditionally, this is the case for the file that contains the header and not the file that contains the lines...

Table

Significant content

Table Title

 

 

Database tables

TABCOUAFF 

No

Sequence number counter assignment table

TABSIVTYP

Yes

Customer invoice type table

ACODNUM

No

Document sequence number counter

BPARTNER

No

BP

BPCUSTOMER

No

Customers

BPDLVCUST

No

Ship-to customers

BPCUSTMVT

No

Customer transactions

ITMMASTER

No

Products

ITMSALES 

No

Product-sales

ITMFACILITY

No

Products - Sites

 

 

Stock tables

SCHGH

No

Stock change header

SCHGD

No

Stock change line

 

 

Sales tables

SINVOICE

No

Invoice headers

SINVOICEV

No

Invoice header valuations

SINVOICED

No

Invoice lines

 

 

Work tables

SWRKINV

No

Work file

 

 

Accounting tables

GTYPACCENT

No

Journal types

GACCCODE

No

Accounting codes

GACCOUNT

No

General ledger accounts

GAUTACE

No

Automatic journals

GAUTACEF

No

Automatic journal formulas

GJOURNAL

No

Journals

 

AUTINVTSEL: Add authorization controls for a transfer document to be invoiced

This entry point is used to insert additional logic after the read of a selected transfer document. It is used in this way to add tests that are used to reject the document.

It is called in the automatic invoicing of stock transfer documents process FUNAUTINVT.

Context and operating method

Transaction

There is no transaction in process.

To refuse the document, it is necessary to set the OK variable to 1.

Log file

There is an open log file.

Call context

This entry point is called on each read of a document.  

Available variables and masks

The selection mask for the transfer documents [M :DIA] (SAUTINVT) is available.

Open tables

In the table below, the significant content flag indicates that the content is in phase with the context. Traditionally, this is the case for the file that contains the header and not the file that contains the lines...

Table

Significant content

Table Title

 

 

Database tables

TABCOUAFF 

No

Sequence number counter assignment table

TABSIVTYP

No

Customer invoice type table

ACODNUM

No

Document sequence number counter

BPARTNER

No

BP

BPCUSTOMER

No

Customers

BPDLVCUST

No

Ship-to customers

BPCUSTMVT

No

Customer transactions

ITMMASTER

No

Products

ITMSALES 

No

Product-sales

ITMFACILITY

No

Products - Sites

 

 

Stock tables

SCHGH

Yes

Stock change header

SCHGD

No

Stock change line

 

 

Sales tables

SINVOICE

No

Invoice headers

SINVOICEV

No

Invoice header valuations

SINVOICED

No

Invoice lines

 

 

Work tables

SWRKINV

No

Work file

 

 

Accounting tables

GTYPACCENT

No

Journal types

GACCCODE

No

Accounting codes

GACCOUNT

No

General ledger accounts

GAUTACE

No

Automatic journals

GAUTACEF

No

Automatic journal formulas

GJOURNAL

No

Journals