FILTER: Additional filter on the invoices

This entry point is used to add an additional filter on the invoices to be validated.

Context and operating method

Transaction

There is no transaction in progress.

Log file

There is an open log file.

Different call cases

This entry point is called in 3 different cases :

CASE 1: On the execution of the Customer BP invoice validation (BPCVAL function)

CASE 2: On the execution of the Supplier BP invoice validation (BPSVAL function)

    CASE 3:  Supplier BP invoice transition from "Pending" to " To be validated" (VALBIS function)

Available variables and masks

The [L]FILTER is available and will be applied as an additional filter on the invoice file. Its length is 250 characters.

The OPTVAL variable is used to determine the call case.

        CASE 1:  Function BPCVAL, OPTVAL='C'

        CASE 2:  Function BPSVAL, OPTVAL='F'

        CASE 3:  Function VALBIS, OPTVAL = 'V'

The criteria mask BPCVAL [DIA] is also available. 

Variable or mask

Definition

 Char FILTER(250)

Additional selection criteria for the Invoice file.

Mask BPCVAL [DIA]

Validation mask for invoices.

 

Open tables

No table has not got significant content in this context.

Call case 1

Table

Significant content

Table Title

BPCINVLIG

 

Customer BP invoice lines

BPCINVLIGA

 

Analytical BP lines

BPCUSTMVT

 

Customer transactions

TABSIVTYP

 

Customer invoice type table

Call cases 2 & 3

Table

Significant content

Table Title

BPSINVLIG

 

Supplier BP invoice lines

BPSINVLIGA

 

Analytical BP lines

BPSUPPMVT

 

Supplier transactions

TABPIVTYP

 

Supplier invoice type table

AUTILIS

 

Users

In all call cases

Table

Significant content

Table Title

FACILITY

 

Sites

COMPANY

 

Company

BPARTNER

 

Business Partner

BPCUSTOMER

 

Customers

BPSUPPLIER

 

Suppliers

BPADDRESS

 

Addresses

GACCOUNT

 

General ledger accounts

GACCCODE

 

Accounting codes

GDIAACC

 

Account structures

CACNA

 

Analytical natures

CADSP

 

Prior allocation keys

CACCE

 

Analytical dimensions table

CAAUZ

 

Restrictions table

TABCUR

 

Currency table

TABUNIT

 

Unit of measure table

TABVAT

 

Tax code table

GTYPACCENT

 

Document types

FISCALYEAR

 

Accouting financial

PERIOD

 

Periods

ACCESS

 

Access by user

GACCDUDATE

 

Open items

ATABDIV

 

Miscellaneous tables

GAUTACE

 

Automatic journals

GAUTACEF

 

Automatic journal formulas

TABCOUNTRY

 

Country table