Páginas filhas
  • FINR290 - Interest Due and Not Paid - Protheus 12


01. OVERVIEW

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:

  • The interest amount according to the number of days overdue, analyzing all bills overdue or paid late; 
  • The interest balance for posted bills with banking transaction
  • Banking transactions received late in relation to the bill posted in SE1 for due and paid interest calculation.

02. QUESTIONS 

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.                                    

03. EXAMPLES



    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.

    04. TABLES USED

    • SE1 - Accounts Receivable
    • SE5 - Bank Transactions