AUTFAEFIL: Addition of selection criteria for the shipments to be invoiced

This entry point is used to insert additional logic during the definition of selection criteria for the validated shipments waiting invoicing.

It is used to add additional filters on these shipments.

It is called in the invoices to be issued process FUNAUTFAE.

Context and operating method

Transaction

There is no transaction in process.

Log file

There is no log file open when in the shipment selection phase.

Call context

This entry point is called during the selection criteria definition.

Available variables and masks

The selection mask for shipments [M :DIA] (SAUTFAE) is still available.

The standard criteria are loaded in the CRITERE variable. They concern the shipment header file (SDELIVERY).

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 ship-to customer that must start with "CLI".

FILSUP -= ‘ & BPCORD >= "CLI"’

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

 

Open tables

In the table below, the significant content flag indicates that the content is in phase with the context (the current customer is loaded...). 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

ATABDIV

No

Miscellaneous tables

TABCOUAFF 

No

Sequence number counter assignment table

TABSIVTYP

Yes

Customer invoice type table

TABCUR

No

Currency table

TABCHANGE

No

Currency exchange rates

TABCOEFF

No

Coefficient table

TABVAT

No

Tax code table

TABRATVAT

No

Tax rates

TABUNIT

No

Unit of measure table

ACODNUM

No

Document sequence number counter

AVALNUM

No

Sequence number counter values

COMPANY

No

Companies table

FACILITY

No

Site table

BPARTNER

No

BP

BPCUSTOMER

No

Customers

BPDLVCUST

No

Ship-to customers

BPCUSTMVT

No

Customer transactions

ITMMASTER

No

Products

ITMSALES 

No

Product-sales

ITMBPC

No

Products-customers

ITMFACILITY

No

Products - Sites

 

 

Sales tables

SINVOICE

No

Invoice headers

SINVOICEV

No

Invoice header valuations

SINVOICED

No

Invoice lines

SDELIVERY

No

Shipment header

SDELIVERYD

No

Shipment line

SORDER

No

Order headers

SORDERQ

No

Order line quantities

 

 

Work tables

SWRKINV

No

Work file

 

 

Accounting tables

GTYPACCENT

No

Journal types

GACCCODE

No

Accounting codes

GACCOUNT

No

General ledger accounts

GACCDUDATE

No

Open items

GAUTACE

No

Automatic journals

GAUTACED

No

Automatic journals (lines)

GAUTACEF

No

Automatic journal formulas

GJOURNAL

No

Journals

 

AUTFAEMAJ: Updates of the specific/custom files after the creation of an invoice

This entry point is used to insert additional logic before the end of the posting transaction for an invoice in order to update the specific/custom files.

It is called in the invoices to be issued process FUNAUTFAE.

Context and operating method

Transaction

There is one transaction in progress.

To cancel the transaction if there is a problem, the GOK variable must be set to 0.

Log file

There is an open log file.

Different call cases

This entry point is called:

in the invoices to be issued function before the end of each transaction for the posting to an invoice.

Open tables

In the table below, the significant content flag indicates that the content is in phase with the context (the current customer is loaded...). 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

ATABDIV

No

Miscellaneous tables

TABCOUAFF 

No

Sequence number counter assignment table

TABSIVTYP

Yes

Customer invoice type table

TABCUR

No

Currency table

TABCHANGE

No

Currency exchange rates

TABCOEFF

No

Coefficient table

TABVAT

No

Tax code table

TABRATVAT

No

Tax rates

TABUNIT

No

Unit of measure table

ACODNUM

No

Document sequence number counter

AVALNUM

No

Sequence number counter values

COMPANY

No

Companies table

FACILITY

No

Site table

BPARTNER

Yes (BP invoice)

BP

BPCUSTOMER

Yes (Bill-to customer)

Customers

BPDLVCUST

No

Ship-to customers

BPCUSTMVT

No

Customer transactions

ITMMASTER

No

Products

ITMSALES 

No

Product-sales

ITMBPC

No

Products-customers

ITMFACILITY

No

Products - Sites

 

 

Sales tables

SINVOICE

Yes

Invoice headers

SINVOICEV

Yes

Invoice header valuations

SINVOICED

No

Invoice lines

SDELIVERY

No

Shipment header

SDELIVERYD

No

Shipment line

SORDER

No

Order headers

SORDERQ

No

Order line quantities

 

 

Work tables

SWRKINV

No

Work file

 

 

Accounting tables

GTYPACCENT

No

Journal types

GACCCODE

No

Accounting codes

GACCOUNT

No

General ledger accounts

GACCDUDATE

No

Open items

GAUTACE

No

Automatic journals

GAUTACED

No

Automatic journals (lines)

GAUTACEF

No

Automatic journal formulas

GJOURNAL

No

Journals

 

AUTFAESEL: Addition of authorization controls for a shipment to be invoiced

This entry point is used to insert additional logic at the end of the authorization controls in the invoicing of a shipment. It is used in this way to add tests that are used to reject the shipment.

It is called in the invoices to be issued process FUNAUTFAE.

Context and operating method

Transaction

There is no transaction in process.

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

Log file

There is an open log file.

Different call cases

This entry point is called:

in the invoices to be issued function at the end of the authorization controls on the invoicing of each shipment.

Available variables and masks

The Shipment selection mask SAUTFAE is available.

Open tables

In the table below, the significant content flag indicates that the content is in phase with the context (the current customer is loaded...). 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

ATABDIV

No

Miscellaneous tables

TABCOUAFF 

No

Sequence number counter assignment table

TABSIVTYP

No

Customer invoice type table

TABCUR

No

Currency table

TABCHANGE

No

Currency exchange rates

TABCOEFF

No

Coefficient table

TABVAT

No

Tax code table

TABRATVAT

No

Tax rates

TABUNIT

No

Unit of measure table

ACODNUM

No

Document sequence number counter

AVALNUM

No

Sequence number counter values

COMPANY

No

Companies table

FACILITY

No

Site table

BPARTNER

No

BP

BPCUSTOMER

No

Customers

BPDLVCUST

No

Ship-to customers

BPCUSTMVT

No

Customer transactions

ITMMASTER

No

Products

ITMSALES 

No

Product-sales

ITMBPC

No

Products-customers

ITMFACILITY

No

Products - Sites

 

 

Sales tables

SINVOICE

No

Invoice headers

SINVOICEV

No

Invoice header valuations

SINVOICED

No

Invoice lines

SDELIVERY

Yes

Shipment header

SDELIVERYD

No

Shipment line

SORDER

No

Order headers

SORDERQ

No

Order line quantities

 

 

Work tables

SWRKINV

No

Work file

 

 

Accounting tables

GTYPACCENT

No

Journal types

GACCCODE

No

Accounting codes

GACCOUNT

No

General ledger accounts

GACCDUDATE

No

Open items

GAUTACE

No

Automatic journals

GAUTACED

No

Automatic journals (lines)

GAUTACEF

No

Automatic journal formulas

GJOURNAL

No

Journals

 

AUTFAEREG: Modification of the sort/shortage criteria of the shipments to be inv

This entry point is used to insert additional logic before the write to the work file of each shipment to be invoiced entry. Thus it is used to add data that serves as shortage criteria in the data of the work file (SWIDATA field) or to modify the key (SWIKEY and SWIKEY1 fields).

It is called in the invoices to be issued process FUNAUTFAE.

Context and operating method

Transaction

There is no transaction in process.

Log file

There is an open log file.

Different call cases

This entry point is called:

in the invoices to be issued function for each posting of an entry in the work file.

Available variables and masks

The Shipment selection mask SAUTFAE is available.

To add shortage criteria, it is necessary to load the required information in the SWIDATA field.

Ex : [F :SWI]SWIDATA += [F :SDH]xxx

Warning: In the SWIDATA field, there are only 40 characters available.

Any modification involving the key fields SWIKEY and SWIKEY1 can lead to problems involving the generated invoices.

Open tables

In the table below, the significant content flag indicates that the content is in phase with the context (the current customer is loaded...). 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

ATABDIV

No

Miscellaneous tables

TABCOUAFF 

No

Sequence number counter assignment table

TABSIVTYP

No

Customer invoice type table

TABCUR

No

Currency table

TABCHANGE

No

Currency exchange rates

TABCOEFF

No

Coefficient table

TABVAT

No

Tax code table

TABRATVAT

No

Tax rates

TABUNIT

No

Unit of measure table

ACODNUM

No

Document sequence number counter

AVALNUM

No

Sequence number counter values

COMPANY

No

Companies table

FACILITY

No

Site table

BPARTNER

No

BP

BPCUSTOMER

No

Customers

BPDLVCUST

No

Ship-to customers

BPCUSTMVT

No

Customer transactions

ITMMASTER

No

Products

ITMSALES 

No

Product-sales

ITMBPC

No

Products-customers

ITMFACILITY

No

Products - Sites

 

 

Sales tables

SINVOICE

No

Invoice headers

SINVOICEV

No

Invoice header valuations

SINVOICED

No

Invoice lines

SDELIVERY

Yes

Shipment header

SDELIVERYD

No

Shipment line

SORDER

No

Order headers

SORDERQ

No

Order line quantities

 

 

Work tables

SWRKINV

Yes

Work file

 

 

Accounting tables

GTYPACCENT

No

Journal types

GACCCODE

No

Accounting codes

GACCOUNT

No

General ledger accounts

GACCDUDATE

No

Open items

GAUTACE

No

Automatic journals

GAUTACED

No

Automatic journals (lines)

GAUTACEF

No

Automatic journal formulas

GJOURNAL

No

Journals

 

AUTFAELIG: Addition of checks so as not the invoice a shipment line

This entry point is used to insert additional logic after the read of each shipment line [F:SDD], before the write of the invoice line and to carryout updates of the shipment. Notably it makes it possible to exclude a shipment line from the invoice.

It is called in the invoices to be issued process FUNAUTFAE.

Context and operating method

Transaction

There is one transaction in progress.

To cancel the transaction if there is a problem, the GOK variable must be set to 0.

Log file

There is an open log file.

Different call cases

This entry point is called:

in the invoices to be issued function, in the shipment lines loading loop.

Available variables and masks

The masks for the invoice management are available : [M:SIH0] (SIH0), [M:SIH1] (SIH1), [M:SIH2] (SIH2), [M:SIH4] (SIH4).

The setting of the IJUMP variable to 1 is used to pass to the next shipment line. If an order or shipment update must still be carried out, it is necessary to include the entry point by taking as a template the contents of the $TRT_DETAIL dimension of the FUNAUTFAE process.

Open tables

In the table below, the significant content flag indicates that the content is in phase with the context (the current customer is loaded...). 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

ATABDIV

No

Miscellaneous tables

TABCOUAFF 

No

Sequence number counter assignment table

TABSIVTYP

Yes

Customer invoice type table

TABCUR

No

Currency table

TABCHANGE

No

Currency exchange rates

TABCOEFF

No

Coefficient table

TABVAT

No

Tax code table

TABRATVAT

No

Tax rates

TABUNIT

No

Unit of measure table

ACODNUM

No

Document sequence number counter

AVALNUM

No

Sequence number counter values

COMPANY

No

Companies table

FACILITY

No

Site table

BPARTNER

Yes (BP invoice)

BP

BPCUSTOMER

Yes (Bill to customer )

Customers

BPDLVCUST

No

Ship-to customers

BPCUSTMVT

No

Customer transactions

ITMMASTER

No

Products

ITMSALES 

No

Product-sales

ITMBPC

No

Products-customers

ITMFACILITY

No

Products - Sites

 

 

Sales tables

SINVOICE

Yes

Invoice headers

SINVOICEV

Yes

Invoice header valuations

SINVOICED

No

Invoice lines

SDELIVERY

No

Shipment header

SDELIVERYD

No

Shipment line

SORDER

No

Order headers

SORDERQ

No

Order line quantities

 

 

Work tables

SWRKINV

No

Work file

 

 

Accounting tables

GTYPACCENT

No

Journal types

GACCCODE

No

Accounting codes

GACCOUNT

No

General ledger accounts

GACCDUDATE

No

Open items

GAUTACE

No

Automatic journals

GAUTACED

No

Automatic journals (lines)

GAUTACEF

No

Automatic journal formulas

GJOURNAL

No

Journals

 

AUTFAEEND: Modification of the invoice or addition of lines before invoice calcu

This entry point is used to insert additional logic after the loading of all the lines in class [M] as well as their write to [F:SID] and before the launch of the invoice calculation. It is used to add additional lines or to carryout modifications before the calculation.

It is called in the invoices to be issued process FUNAUTFAE.

Context and operating method

Transaction

There is one transaction in progress.

To cancel the transaction if there is a problem, the GOK variable must be set to 0.

Log file

There is an open log file.

Different call cases

This entry point is called:

in the invoices to be issued function before the end of each transaction for the posting to an invoice.

Available variables and masks

The masks for the invoice management are available : [M:SIH0] (SIH0), [M:SIH1] (SIH1), [M:SIH2] (SIH2), [M:SIH4] (SIH4).

For the addition of a line use the $TRT_DETAIL dimension from the FUNAUTFAE process as the template

Open tables

In the table below, the significant content flag indicates that the content is in phase with the context (the current customer is loaded...). 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

ATABDIV

No

Miscellaneous tables

TABCOUAFF 

No

Sequence number counter assignment table

TABSIVTYP

Yes

Customer invoice type table

TABCUR

No

Currency table

TABCHANGE

No

Currency exchange rates

TABCOEFF

No

Coefficient table

TABVAT

No

Tax code table

TABRATVAT

No

Tax rates

TABUNIT

No

Unit of measure table

ACODNUM

No

Document sequence number counter

AVALNUM

No

Sequence number counter values

COMPANY

No

Companies table

FACILITY

No

Site table

BPARTNER

Yes (BP invoice)

BP

BPCUSTOMER

Yes (Bill to customer )

Customers

BPDLVCUST

No

Ship-to customers

BPCUSTMVT

No

Customer transactions

ITMMASTER

No

Products

ITMSALES 

No

Product-sales

ITMBPC

No

Products-customers

ITMFACILITY

No

Products - Sites

 

 

Sales tables

SINVOICE

Yes

Invoice headers

SINVOICEV

Yes

Invoice header valuations

SINVOICED

No

Invoice lines

SDELIVERY

No

Shipment header

SDELIVERYD

No

Shipment line

SORDER

No

Order headers

SORDERQ

No

Order line quantities

 

 

Work tables

SWRKINV

No

Work file

 

 

Accounting tables

GTYPACCENT

No

Journal types

GACCCODE

No

Accounting codes

GACCOUNT

No

General ledger accounts

GACCDUDATE

No

Open items

GAUTACE

No

Automatic journals

GAUTACED

No

Automatic journals (lines)

GAUTACEF

No

Automatic journal formulas

GJOURNAL

No

Journals