The report allows you to view and analyze interest due and not paid related to bills registered in the Accounts Receivable portfolio in order to demonstrate:
Parameter | Options | Description |
---|---|---|
From Bank? |
| Select the initial code from the bank code range to be considered for the report generation. The [F3] key is available for checking the Banks Registration. |
To Bank? |
| Select the final code from the bank code range to be considered for the report generation. The [F3] key is available for checking the Banks Registration. |
From due date? |
| Enter the start date of the range of bill due dates to be considered for the report generation. |
To due date? |
| Enter the end date of the range of bill due dates to be considered for the report generation. |
From customer? |
| Select the initial code of the range of customer codes to be considered for the report generation. The [F3] key is available for checking the Customers Registration. |
To customer? |
| Select the final code of the range of customer codes to be considered for report generation. The [F3] key is available for checking the Customers Registration. |
Interest minimum value? |
| Enter a minimum interest value for collecting data to be considered in the report generation. Values lower than the one entered will not be considered as interest due and not paid, and will not be printed. |
Bills? | Open / Paid | Select whether the bills to be considered in the report generation should be Paid or Open. |
Which Currency? |
| Select the currency to be considered in the report generation: "Currency 1", "Currency 2", "Currency 3", "Currency 4", or "Currency 5." |
Other currencies? | Convert / Do Not Print | Select "Convert" if you want to consider bills in other currencies in the report. Otherwise, select "Do Not Print". |
Posted Bills Int? | Regular calculation / Calc. for posting | Select how the interest from bills already posted will be calculated, regularly or by posting. "Regular" indicates that the interest from posted bills will be calculated on the bill amount, and "by posting" indicates that the interest will be calculated on the amount of each post. |
The examples involve mainly the combination between "Minimum interest value?" (MV_PAR07) and "Bills?" (MV_PAR08) questions.
For bills that have not been posted and that have the interest to be calculated, this is displayed in the report, showing the interest according to the days overdue.
Example:
Open Bill Receivable:
Amount |
Interest |
Balance |
Paid Interest |
Due date |
---|---|---|---|---|
1000 |
100 |
1100 |
0 |
4/28/21 |
Report extraction: System base date: 04/29/2021.
Bills posted with fully paid interest will not be displayed in the report.
Example:
Posted Bill Receivable:
Amount |
Interest |
Balance |
Paid Interest |
Due date |
---|---|---|---|---|
5000 |
500 |
5500 |
500 |
4/28/21 |
Report extraction: System base date: 04/29/2021.
Bills with fully posted balance and partially posted interest will be displayed in the report:
Example:
Posted Bill Receivable:
Amount |
Interest |
Balance |
Paid Interest |
Due date |
---|---|---|---|---|
4000 |
450 |
4450 |
200 |
4/28/21 |
Report extraction: System base date: 04/29/2021.