Open Item Edit
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
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.
Grid Details
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:
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) |
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. |
Specific buttons
Criteria |
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.