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 can also manage the open items individually in invoicing in the Purchasing, Sales or A/P-A/R accounting or Accounting modules.
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.
Refer to documentation Implementation
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 :
It is possible to specify a payment approval start and end range.
For invoices or open items having a discount/charge code, it is possible to simulate the amount of this discount/charge in two ways:
Additional search criteria make it possible to include:
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.
Selection criterion
| Company (field CPY) |
| All sites (field ALLFCY) |
| Site (field FCY) |
|
Only the open items of the entered site will be selected. |
| 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 |
| 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
| 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
| 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
| Sort criteria (field TRI) |
| Screen (field ECRAN) |
|
Specifies the screen code to be used for entering open items. |
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 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:
By clicking on an item header, it is possible to modify:
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.
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.
When an item is selected with the cursor, additional information on it or the selection total is displayed.
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.
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.
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. |
|
Criteria |
It is used to restart the selection with new criteria. |
In addition to the generic error messages, the following messages can appear during the entry :
The site entered is not part of the company previously entered.
The amount entered for the item is greater than the amount for the line on the attached document.
The amount entered for the item is less than the payment amount for the item.
This message can be produced by 2 cases:
When displaying a multi-item grid, the number of items exceeds the size of the grid.
In the multi-item grid, when there is only one item, its cancellation is not possible.
In a multi-item grid, it is necessary to have at least one item line.
The item is linked to one or more payments.
The item is linked to a statement.
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.
On using the "+ Pag" and "-Pag" function keys in the item grid, no items remain to be displayed on another page.
Refer to documentation Implementation