An entry is characterised by a group of data related to the operation that it represents: the original document number, the document due date, it's payment method, the currency, the amount...

The management of open items makes it possible to facilitate the tracking of operations recorded for a BP (via the Purchasing, Sales, Sales/Purchase ledger or Accounting modules) under a document type parameterised according to this function (management of open items).

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

This item management function is used to:

  • view all the open items related to a company, a site, a BP... (according to the definition level in the selection).
  • modify these open items at several levels:
    • the due date
    • the payment method for this open item
    • split the open item amount over N distinct open items
    • specify a possible dispute
    • activate or deactivate the reminder management
    • the "Payment approval" level
    • the pay-by or pay-to BP
    • modify the early discount/late charge code

In order to only manage a few invoices whose number is known (for instance, to assign them their PA level), the 'Open item entry' function is more adapted than the open item management function.

It is also possible to manage the open items individually in invoicing in the Purchasing, Sales or Sales/Purchase ledger modules by using the appropriate button or by the contextual(right click) menu in document entry in the Accounting module.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

It is on this single screen that it is possible to enter the open item(s) to be viewed / modified.

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 characterises the open item such as:

  • the invoice number, the item due date, the customer invoice or order, the pay-by/pay-to BP etc...
  • the original document number. In order to refine the traceability of the item origin, a contextual (right-click) menu is used to find the original document for the document generating the item (example: the order number for the invoice generating the item). This traceability is only possible for invoices (and/or credit notes) where the "original document" field has been assigned.
  • the currency. All the item amounts can be displayed either in the transaction currency, or the company currency or even the reporting currency.
  • the sign (S) of the item from the accounting point of view: Debit/Credit

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

Item parameter modification

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

  • the due date
  • the Payment Approval value
  • the dispute code
  • the payment method
  • the reminder management
  • the pay-by/pay-to BP
  • the statement generation (accessible by right-click)
  • the early discount/late charge code
  • the pay-by/pay-to address code

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 those open items mentioned or which have to be mentioned on a statement, the "statement" field is completed. The statement number or "To do" is displayed respectively.
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.

Specific buttons

Criteria

SEEREFERTTO For further information, consult the paragraph 'Open item selection criteria' of the 'Open item management' function.

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:

  • when entering a payment method not linked to a statement code, with the item in a statement (error message), or where the statement is to be created for this item (warning message). In this last case, if continues, the information "Statement to be created" is set automatically to "no".
  • on activation of the "Statement" function key on an item where the payment method is not linked to a statement code.
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.

Tables used

SEEREFERTTO Refer to documentation Implementation