Interest notes generation
Use this function to create interest notes based on late charges calculated in the Early discounts/Late charges function (GESTDA).
Process
1 Set up late charges in the Early discounts/Late charges function (GESTDA) and then link them to an open item.
2/ Select the criteria such as company, due date, site, payment method, etc. to generate a list of interest notes. When you click OK, a new screen opens with a Details grid that displays the list of open items.
3/ The results display in a grid that lists the open items that are eligible for interest notes, grouped by company. If an interest note has already been issued for an open item, the Due date and No. days columns are highlighted blue.
4/ Generating interest notes:
For each item in the Details grid you can decide which opens items to include by selecting Yes or No in the Select column.
You also have the option to Include all or Exclude all.
For selected items, interest notes are generated as a document in Customer BP invoices (GESBIC). The document type is based on the
IDNINVTYP- Late charges invoice type parameter setting. You receive an error message if this parameter has no value.
By default, open items are grouped by customer site and currency. This means that one interest note is created for each Customer site. If you have one customer with two sites, this would create two interest notes for the same customer, one for each site. However, you can choose to group all sites under one customer. In that case, only one interest note is generated that includes late charges for all open items for all sites.
When you click Create, the interest notes are generated, and the records stored in Customer BP invoices (GESBIC) as an invoice. Each open item with its late charge is listed on a separate line. Amounts cannot be changed.
The accounts used to generate the interest notes journal entry lines are those defined for the Early discount/Late charge code.
It is the same for dimensions; however, if there are more than one line with different Early discount/Late charge codes, the dimensions allocated in the header of the document are related to the first code.
Prerequisites
Refer to documentation Implementation
Screen management
Header
Company (field CPY) |
Type in or select the company interest notes for open items are to be generated. You cannot enter a group of companies. This field is mandatory. The IDNTDAEXE - Late charges flow parameter (TRS chapter, TDC group) must be set to By interest note |
Number of days (field NBOFDAYS) |
Enter a number to include open items that are overdue more than the number of days entered here.
|
Reference date (field REFDAT) |
By default, this is the current date. You can enter a different date to view charges up to this date.
|
Tab Primary criteria
The selections you make here determine which open items are included when you create interest notes.
Block number 1
All sites (field ALLFCY) |
Select this check box to include all sites for the select company. |
Site (field FCY) |
If you did not select All sites, enter a site.
|
All customers (field ALLBPC) |
Select this check box to include all customers.
|
From customer (field BPCDEB) |
If you did not select All customers, enter a From customer and To customer to only include customer open items with that range. Enter the same customer in both fields to filter on a single customer.
|
To customer (field BPCFIN) |
All users (field ALLUSR) |
Select this check box to include all users.
|
User (field USR) |
If you did not select All users, enter a user.
|
All payment methods (field ALLPAM) |
Select this check box to include all payment methods.
|
Payment method (field PAM) |
If you did not select All payment methods, enter a payment.
|
Control account
Control group (field GRPSAC) |
Enter a control group to filter open items according to this group.
|
Control (field SAC) |
Enter a control account for the customer.
|
Account (field SACACC) |
This field displays the account number for the Control or the Control group.
|
Miscellaneous
Criteria (field CRI) |
You can use this field to enter a formula using the Formula wizard for specific filtering criteria.
|
Tab Secondary criteria
All group customers (field ALLBPCGRU) |
Select this check box to include all group customers.
|
Group customer (field BPCGRU) |
If you did not select All group customers, enter a Group customer.
|
All risk customers (field ALLBPCRSK) |
Select this check box to include all risk customers.
|
From risk customer (field BPCRSKDEB) |
If you did not select All risk customers, enter a From risk customer and To risk customer to include risk customers in that range. Enter the same risk customer in both fields to limit the search to that risk customer.
|
To risk customer (field BPCRSKFIN) |
All representatives 1 (field ALLREP1) |
Select this check box to include all representatives.
|
field REPDEB1 |
If you did not select All representatives, you can search for a range of representatives.
|
field REPFIN1 |
All representatives 2 (field ALLREP2) |
field REPDEB2 |
field REPFIN2 |
All classes (field ALLCLS) |
Select this check box to include all classes.
|
Class (field CLS) |
If you did not select All classes, select a class.
|
All stat groups (field ALLTSCCOD) |
Select this check box to include all stat groups.
|
Limitations
Reversal process
After you generate an interest note, you can revert the process by creating a credit note linked to the main document. This deletes the records from the Interest notes table (DNODEBNOT) when the credit note is posted.
This is the only way to revert the interest notes.
Late charges amount calculation
The late charge amount calculated is always based on the initial due date or on the date of the last interest note issued for that open item.
This means that the amount is based on the table from the open items (GACCDUDATE) related to the open amount (AMTLOC-PAYLOC-TMPLOC). Therefore, the original amounts from previous matching, and calculating the days until the next matching, are not considered. To sum up, the HISTODUD table is not analyzed for this purpose.
Dimensions header allocation
The dimensions used to generate the interest note lines are those defined for the Early discount/Late charge code. However, in a situation with more than one line with different Early discount/Late charge codes, the dimensions allocated in the header of the document are related to the first code. This means no dimensions by default are managed at this step.