Open items

An open item is a group of data related to the operation that it represents: the original document number, the document due date, its payment method, the currency, the amount, etc.

The managing open items makes it possible to facilitate the tracking operations recorded for a BP (via the Purchasing, Sales, A/P-A/R accounting or Accounting modules) under a document type set up according to this function.

After these operations are completely processed by payment (provisional or final) or posted as "In bank" (matched entries), it is no longer possible to manage the items, except for the possibility to place an item on a statement or to associate a dispute code with it.

The items partially processed in payment remain modifiable.

Use this function is used to:

You should use the Open item entry function (MODECHE2) to process only a few invoices when you know how many there are.

You can also manage the open items individually in invoicing in the Purchasing, Sales or A/P-A/R accounting or Accounting modules.

Warning

The discount calculation process uses a "discount base amount" generated at the time of the invoice entry taking into account various elements of the invoice.

If you modify the early discount code of the open item afterwards, this base amount is not available. Instead, only a basic calculation using the total amount and the discount rate is used.

Prerequisite

See also Refer to documentation Implementation

Screen management

Open item selection criteria

Item selection criteria

The first stage consists of the entry of the item selection criteria. Only the items fulfilling all the criteria defined in this first screen are displayed in the item management screen. This allows a specific tracking of the situation for the companies with regard to their BPs.

Several selection criteria are available :

Reminders

Payment approval

Early discount / late charge simulation

For invoices or open items having a discount/charge code, it is possible to simulate the amount of this discount/charge in two ways:

Search criteria

Additional search criteria make it possible to include:

 Sort criteria

Finally, an option to display the selected items is proposed.
It is possible to sort the items by item due date or by pay-by/pay-to BP (when not selection has been carried out on the BPs).

It is possible to specify an inquiry screen that is different to the one proposed by default.

The OK button is used to select the invoices concerned and to pass to the up-date on the item modification screen.

Field descriptions

Selection criterion

Only the open items of the entered company will be selected.
The user company is displayed by default.

All sites or a particular site.

All collective accounts, a group of collective accounts or a particular collective account.

Only the open items with a control account that belongs to the entered control account group will be selected.

Only the open items of the entered control account will be selected.

All pay-by/paid BP or one particular pay-by/paid BP.

Only the open items of the entered BP will be selected.

All payment modes or a particular payment mode.

Only the open items of the entered payment mode will be selected.

All currencies, a group of currencies or a particular currency.

Only the open items with a currency belonging to the entered group of currencies will be selected.

Only the open items of the entered currency will be selected.

Maximum date of the selected open items (no maximum date if not entered).

Company (field CPY)
All sites (field ALLFCY)
Site (field FCY)

Only the open items of the entered site will be selected.
The site associated with the user is displayed by default.
This site must belong to the company previously entered.

All control accounts (field ALLSAC)
Control group (field GRPSAC)
Control (field SAC)
field SACACC
All bill-to BPs (field ALLBPR)

All bill-to suppliers or one particular bill-to supplier.


From bill-to/order BP (field BPRDEB)

Only the open items of the bill-to BPs included within the range
will be selected.


To bill-to/order BP (field BPRFIN)
All paying BPs (field ALLPYRBPR)
From pay-by BP (field PYRBPRDEB)
To pay-by BP (field PYRBPRFIN)
All payment methods (field ALLPAM)
Method (field PAM)
All currencies (field ALLCUR)
Currency group (field GRPCUR)
Currency (field CUR)
From due date (field DUDDATDEB)
To due date (field DUDDATFIN)

Reminders

If no, only the open items with Reminder=No will be selected, if yes, only the open items with Reminder=Yes will be selected, If Not determined, all open items will be selected.

Range on reminder level (all levels if empty range).

Reminder status (field FUPFLG)
Open items never reminded (field FUPLEVZERO)

If the field Open items to remind is set to 'YES' and the field Open items never reminded is checked, the program will display all the open items to be reminded and that have not been reminded yet.

If the field Open items to remind is set to 'UNDEFINED' and the field Open items never reminded is checked, the program will display all the open items to be reminded and that have not been reminded yet, as well as all the open items that have never been reminded and that will never be reminded..

From reminder level (field FUPLEVSTR)
To reminder level (field FUPLEVEND)

Pay approval

Status range of the Payment Approval note.

From payment approval (field FLGPAZSTR)
To payment approval (field FLGPAZEND)

Simulate discount/charge

Reference date (field DEPDAT)

Early discount/late charge simulation.

The amount that will be displayed in the "Early discount/late charge amount" column is calculated while taking into account:

* the early discount/late charge code (either of the open item, or the BP).

* a number of days.

* predefined early discount/late charge rates.

The result will be either a negative amount (=late charge) or a positive amount (=early discount).

For the simulation, the number of days can be entered:

* either directly in the "Nbr of days" field.

* or using a reference date (the number of days will be calculated with respect to the current date).

No. of days (field DEPNBJ)

Search criteria

Supplier prepayments (field ACFOU)

If yes, the supplier prepayment due dates will be taken into account.

Factored open items (field FACTOR)

Mentions whether the open items specified for factoring must be loaded

or not. In any case, it will not be possible to modify their amounts.

Validated invoices only (field DUDVAL)

Box not checked: All open items will be displayed.

Box checked: Only the open items for posted invoices will be taken into account.

Customer prepayments (field ACCLI)

If yes, the customer prepayment due dates will be taken into account.

Balanced open items (field DUDCLE)

If 'yes', all closed open items will be taken into account.

Criteria (field CRI)

Mention your selection criterion.


Sort criteria

The open items will be sorted according to the selected sorting criterion: Due date or BP

Sort criteria (field TRI)
Screen (field ECRAN)

Specifies the screen code to be used for entering open items.

Entry screen

Open item modification

The list of open items selected is displayed on the screen. This screen is made up of the lines where all the information linked to the open items is found. At the foot of the grid four frames give the selection total (this can be set up in the inquiry screen), the open item detail, the entry total and the characteristics of any early discount/late charge.

The open item grid

The display of fields is closely linked to the screen setup.

Each line of this grid represents a open item. Found here is all the information that characterizes the open item such as:

The different actions possible at the line level are the following:

Item setup modification

By clicking on an item header, it is possible to modify:

Distribution of an item over multiple items.

In the "Amount" field in the item to be processed, it is sufficient to modify the amount in use of one of the new constituent items.

This change in amount triggers the opening of a new window that is used to enter the new lines. It is possible then to modify the distribution of the item between the different lines and to close the last line by right click.

In the case where a partial payment has already taken place, additional controls are activated.

Grouping of items

The grouping of items is based on the same principal as the distribution. It is not possible to delete an item directly in the lines of the grid. On one of the items to be grouped, it is sufficient to modify the amount by indicating the total amount of the grouped item. A new window appears. It is in this window that the additional item lines can be deleted.

Information at the bottom of the screen

When an item is selected with the cursor, additional information on it or the selection total is displayed.

Selection Total:

This section is optional and depends on the screen setup. It displays key information for the current selection: the number of items and their amount and balance total, the total amount of final or provisional payments.

Item detail:

This detail appears when an item is selected. It underlines the information on the pay-by/pay-to entity and the operation site. 
For items placed or being placed on a statement, the "statement" field is assigned. It displays respectively either the statement number or "To do".
Finally, if the open item is settled, or only partly, the payment number is displayed.

Entry total:

The total amount for the items is displayed in the "Total" field, a single document can be distributed over several items. For finally or partially paid items, the payment amount as well as the item balance appear in the appropriate fields.

Field descriptions

Grid Details

Journal type.
The entered type must have the "Open item management" set to Yes.

The amount cannot be higher than the amount of the journal line.
The amount cannot be lower than the amount already paid.
Modifying the amount of an open item causes a table to open enabling several open items to be entered for the same journal line.

Open item dispute code.

To be reminded Yes/No

Pay-by/paid BP for the open item.

Type (field TYP)
Document no. (field NUM)

Enter the journal number with an open item that needs to be modified. If this is a multi-open item journal, a table opens that lists the open items of the journal. This enables a specific open item to be selected.

Due date (field DUDDAT)

Click Column Update from the Actions icon to modify the due date in batch.

If the MAXPD - Maximum period (companies) activity code is activated, a warning message is displayed if the due date is greater than the period specified, depending on the case, at the level of the following parameters or of the contractual period possibly specified at the BP level.
Pymt. method (field PAM)

If the new payment mode has no associated statement code: 

  • warning message if the open item shows a statement information "to be performed": otherwise, tit will no longer be possible to integrate the open item to a statement.
  • Error message if the open item is integrated to a statement.

Possibility to perform bulk modifcation by right clicking on "Column update".

Bank account (field BIDNUM)

The value of this number defaults from the business partner profile and the address code. The bank account number format is dependent on the bank location.

For example, for an IBAN format, this field only contains the bank account number starting with the 5th character of the full IBAN. The prefix containing the country code and a control key is not included.

To change the bank account number, select the Business partner from the Actions icon available in the field to access the business partner profile, and select or enter a different bank account.

Payment title (field ZPAM)
Curr. (field CUR)
IBAN code (field IBAN)

This field displays the full IBAN, including a prefix with the country code and a control key, followed by the bank account number. If the IBAN prefix does not exist, this field remains empty.

Amount (field AMTCUR)
Paying bank (field PAB)

This field displays the paying bank linked to the Bank account field.

Company amount (field AMTLOC)
Discount/Late charge amount (field AMTDEP)
Discount/Late charge (field DEP)

Code used by default for the current BP to identify a series of early discount and late charge rates (up to 12) to be applied to a payment according to a number of days early or days late with respect to the open item date.

Dispute (field DPTCOD)
Sign (field SNS2)
Legal title (field ZDPTCOD)
Days delay (field DELAY)
Reminder (field FLGFUP)
Level (field LEVFUP)

Possibility to perform bulk modifcation by right clicking on "Column update". Only the "revenue"-type open items will be modified.

Reminder date (field DATFUP)
Pay approval (field FLGPAZ)

The entered level must not be higher than the level of the user's payment approval note. Possibility to perform bulk modifcation by right clicking on "Column update". Only the "expense"-type open items with an approval payment level lower than or equal to the level of the user's approval payment will be modified.

Pay-by/Pay-to BP (field BPRPAY)
Business partner address (field BPAPAY)

Address code of the pay-by/paying BP.

Bill-to/Order BP (field BPR)
BP type (field BPRTYP)
Internal number (field ACCNUM)
Company (field CPY)
Site (field FCY)
Control (field SAC)
Account (field ACCSAC)
Paid (field PAYCUR)
Provisional payment (field TMPCUR)
Statement (field SOI)
Statement number (field SOINUM)
Payment reference (field REG)
Factor (field BPRFCT)
Prepayment deducted (field DINAMT)
Paid (co) (field PAYLOC)
Paid (ledger) (field PAYRPT)
Provisional company payment (field TMPLOC)
Item balance (field DUDCLECUR)
Company item balance (field DUDCLELOC)
Source document (field BPRVCR)
Source date (field BPRDATVCR)
Accounting date (field ACCDAT)
Bill-to/order BP name (field LIBBPR)
Pay-by/Pay-to BP name (field LIBBPRPAY)
Mandate reference (field UMRNUM)

The "Mandate reference" field is used to initialize or select the mandate reference, which is the unique mandate identifier. This field is initialized with the validated main mandate of the company/pay-by BP combination. If there is no validated main mandate, the field is empty but another validated mandate of the combination can be selected.

The user can modify the payment method. If the chosen payment method is SDD, the mandate reference can be accessed and the user can select the reference desired. If the chosen payment method is other than SDD, the mandate reference is not displayed and the field can not be accessed.

  

This field can be accessed for the current company only if activity code SDD - SDD management is activated and parameter SDDMGT - SDD management (chapter TC, group SDD) is set to "Yes". Moreover, the payment method selected must be SDD.

Selection total

No. of items due (field NBDUD)
Total (field TTTCDEV)
Balance (field TDUDCLE)
field TCUR
Final payment (field TREGDEF)
Provisional payment (field TREGPRO)

Item detail

Control (field VSAC)
BP (field VBPR)
Name (field VBPRNOM)
Pay-by/Pay-to (field VBPRPAY)
Name (field VBPRPAYNOM)
Site (field VFCY)
Statement (field VREL)
Payment (field VREG)

Entry total

Total (field VTTCDEV)
field VCUR
Final payment (field VREGDEF)
Provisional payment (field VREGPRO)
Balance (field VDUDCLE)

Early discounts/Late charges

Date reference (field DEPDAT)
No. of days (field DEPNBJ)
Action icon
Source Document

This option is always accessible. It is used to obtain the original document number. This information is also available in a grid column.

Statement

This option is always accessible. By selecting / de-selecting this option, the "Statement" field toggles between its two values; "Yes" is used to generate a statement while "No" is used to prohibit this.

Journal Inquiry

This option is always accessible. Is used to pass via a tunnel to the accounting journal.

Invoice Inquiry

Used to move via a tunnel to the original invoice (when an item is the output from a sales/purchase or BP invoice).

Payment inquiry

Used to pass via tunnel to the payment for the item.

Menu Bar

Criteria

It is used to restart the selection with new criteria.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

This site belongs to company XXX

The site entered is not part of the company previously entered.

Item amt > Doc line amt

The amount entered for the item is greater than the amount for the line on the attached document.

Item amt < Amt already paid

The amount entered for the item is less than the payment amount for the item.

Payment method not related to the statements

This message can be produced by 2 cases:

Number of items > Number of lines in the grid

When displaying a multi-item grid, the number of items exceeds the size of the grid.

There is only one item, Cancellation not possible

In the multi-item grid, when there is only one item, its cancellation is not possible.

Cancellation is not possible for all the items

In a multi-item grid, it is necessary to have at least one item line.

There is a payment for this item, Cancellation not possible

The item is linked to one or more payments.

The item appears on a statement, Cancellation not possible

The item is linked to a statement.

Item amount total <> Document line amount

During validation of the multi-item grid, the amount total of the items is different to the amount for the document line. Modify one or more of the amounts to obtain the total amount for the document line, which is displayed for information at the bottom right of the screen.

Start/End of file

On using the "+ Pag" and "-Pag" function keys in the item grid, no items remain to be displayed on another page.

 

Tables used

See also Refer to documentation Implementation