This routine was adjusted to comply with the General Personal Data Protection Law (Statute No. 13.70), so that some fields containing data regarded as sensitive and/or personal are blurred, becoming illegible. |
The report allows you to see bills registered in the Accounts Receivable portfolio.
The parameter combination during the printing time allows you to present bills in various manners, complying with the best financial control practices such as:
Performance improvement: now, the report works with a temporary file directly in the database. This update improved significantly the report use, but there are a few important points:
A functionality for generating a log file in the system folder of the Protheus server was deployed, in the case that some syntax incompatibility happens in the database. The generated log will help the technical support team to identify the cause of the difference. The file name is composed of the 'FR130Log' prefix followed by the company code, branch code, and operating system date with the .log extension. E.g., fr130logA1010101_20200515.log, where A1 represents the company code, and 010101, the branch code. |
Parameter | Options | Description |
---|---|---|
From customer? | Select range initial code of customer codes to be considered when generating the report. The [F3] key is available for querying the Customers File. | |
To customer? | Select range final code of customer codes to be considered when generating the report. The [F3] key is available for querying the Customers File. | |
From Prefix? | Enter the initial code of the range from bills receivable prefixes to be considered in printing. | |
To Prefix? | Enter final code of the range from bills receivable prefixes to be considered in printing. | |
From Bill? | Enter the initial code of the range of numbers from bills receivable to be considered in printing. | |
To Bill? | Enter the final code of the range of numbers from bills receivable to be considered in printing. | |
From Bank? | Enter the initial code of the range of bank codes to which the bills receivable to be considered in the report generation belong. The [F3] key is available for querying the Banks File. | |
To Bank? | Enter the final code of the range of bank codes to which the bills receivable to be considered in the report generation belong. The [F3] key is available for querying the Banks File. | |
From due date? | Enter the initial date of the bills receivable due date to be considered when generating the report. | |
To due date? | Enter the final date of bills receivable due date to be considered when generating the report. | |
From Class? | Enter the initial code of the range of classes codes to which the bills receivable to be considered in the report generation belong. The [F3] key is available for querying the Class File. | |
To Class? | Enter the final code of the range of classes codes from the bills receivable to be considered for report generation. The [F3] key is available for querying the Class File. | |
From Issue Date? | Enter the initial date of bills receivable issue date to be considered when generating the report. The "Calendar" button is available for querying dates. | |
To issue date? | Enter the final date of bills receivable issue date to be considered when generating the report. The "Calendar" button is available for querying dates. | |
Which Currency? | Select in which currency values from bills receivables are printed. | |
Print provisional? | Yes / No | Select "Yes" for the report generation to consider even provisional bills, indicated by the "PR" type. Otherwise, select "No". |
Convert Overdue by? | Base date / Due date | Select if overdue bills will be converted by "due date" or by "base date". |
Print Bill in Discount? | Yes / No | Select "Yes" to print bills in discounted collection. Otherwise, select "No". |
Print Report ? | Detailed / Summarized | Enter if the report to be printed will be "Detailed" or "Summarized". Detailed - Prints details from bills receivable, or Summarized - prints only total receivable. |
Compose Retroactive Balance? | Yes / No | Select "Yes" if you want the bills balances to be recalculated until the report reference date. Select "No" if you want to consider the bills' balances in the current status (in the bills file), irrespective of the report issue date. Example: Bill implementation -> 08/04/XX, for BRL 1000.00. Partial post -> 10/08/XX, for BRL 400,00 (a balance of BRL 600.00 remains) Partial post -> 18/08/XX for BRL 200.00 (a balance of BRL 400.00 remains). a) With "Compose Retroactive Balance = Yes" and "Report Reference Date = 08/12/XX", we have: Bill balance= BRL 600.00 (balance on the selected date). b) With "Compose Retroactive Balance = No" and "Report Reference Date = 08/12/XX", we have: Bill balance = BRL 400.00 (in this case, the Retroactive balance option is not considered. The balance displayed is the current one). |
Cons. Branches below? | Yes / No | Select “Yes” for the report generation to consider the branches to be entered in the following parameters; otherwise, select "No". |
From Branch? | Enter the initial code of the branches interval to be considered for report generation when "Consider Branches Below" is set to "Yes". | |
To Branch? | Enter the final code of the branches interval to be considered for report generation when "Consider Branches Below" is set to "Yes". | |
From Store? | Enter the initial code of the customer store codes interval to be considered for report generation. | |
To Store? | Enter the final code of the interval of customer store codes to be considered for report generation. | |
Consider Advance? | Yes / No | Select "Yes" to consider bills referring to advances, registered under types "RA" and "NCC", when generating the report. Otherwise, select "No". |
From accounting date? | Enter the start date of the interval of bill accounting dates (issue dates) to be considered when generating the report. | |
To accounting date? | Enter the final date of the interval of bill accounting dates (issue dates) to be considered when generating the report. | |
Print Name? | Reduced name / Corporate Name | Select "Reduced name" to print the customer's reduced name as registered, or "Corporate Name" to print the corporate name as the customer's name. |
Other Currencies? | Convert / Do Not Print | Select "Convert" if you want bills in other currencies to be converted to the currency selected, or "Do Not Print" if you do not want to print bills from currencies different from the one selected above. |
Print Types? | Enter the bill types you wish to print separated by ";" (semicolon) and with 3 characters each. E.g.: If you wish to print only duplicates and invoices, enter here: DP ;NF. | |
Do not print types? | Enter the bills types you do not want to print separated by ; (semicolon) and with 3 characters each. E.g.: If you wish to print all bills, except duplicates and invoices, enter here: DP ;NF. If you enter something in this question, leave the previous question blank, and vice-versa. | |
Deductions? | List / | Enter the print manner for the deduction bills: "Do not list", "list", "do not consider". If you select "List", all deduction bills will be printed right after the main bill, i.e., the main bill amount will be printed in one row, followed by the deduction bill amount in another row. If you select "Do not list", deduction bills will not be printed, but the deduction amounts will be taken from the amounts receivable. And, if you select "Do not consider", the bill receivable amount will be printed as gross amount, without deductions. |
Only bill for flow? | Yes / No | Select "Yes" to list only bills selected for Cash Flow at the accounts receivable addition. Otherwise, select No. |
Skip page for customer? | Yes / No | Select "Yes" for the system to change to a new page for every new customer. Otherwise, select No. Only if the printing order is "by customer" or "by cust/cd". |
Base date? | Enter the system base date to be considered so that you do not have to change it before printing the report. | |
Compose Balance By? | Posting Date / Credit Date / | Select the date to be considered when composing the bill balance if the question "Comprise Retroactive Balance?" is set to "Yes". Example: Bill posted in 3/30/2002, with Credit date 3/31/2002. If the report is printed on 3/30/2002 with "Comprise Retroactive Balance?" set to "yes" and "Compose balance by" set to "Credit Date", the bill is printed. |
Fut. issuance bill? | Yes / No | Select "Yes" to consider bills with issue date later than the report DataBase, or "No" otherwise. |
Convert values by? | Rate of the day/trans. rate | Select the rate to be used for converting values |
Consider date? | Actual Due Date / Due Date | Enter the due date to be considered for report generation. |
Offset among branches? | Yes / No | Select "yes" to search transactions in all branches, looking for offsets among branches. If you do not have these transactions, select "No". Only in environments with exclusive SE5. |
Select Branches? | Yes / No | Select Yes if you want to select the branch. |
Consider deleted bills? | Yes / No | Select Yes to consider in financial position the bills deleted according to the DataBase. Select No to consider in financial position the bills that were not deleted according to the DataBase. |
Below are some examples and explanations for parameter usage:
|
Entry points currently enabled:
Name | Description |
---|---|
F130Qry | Allows you to use filters in the main query of the FINR130 report |
FR130TELC | |
F130FILT |
<!-- esconder o menu --> <style> div.theme-default .ia-splitter #main { margin-left: 0px; } .ia-fixed-sidebar, .ia-splitter-left { display: none; } #main { padding-left: 10px; padding-right: 10px; overflow-x: hidden; } .aui-header-primary .aui-nav, .aui-page-panel { margin-left: 0px !important; } .aui-header-primary .aui-nav { margin-left: 0px !important; } </style> |