Note
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:
Log file for evaluating differences
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:
Compose Retroactive Balance (MV_PAR20)
The Compose Retroactive Balance question is employed in financial reports to check the company situation in a specific past date and displays the bills receivable situation as a retrospective.
Example:
Bill Receivable:
Issue Date: 05/05/2019
Due Date: 5/10/2019
Net Amount: BRL 1000.00
On 5/9/2019, this bill receives a partial posting for BRL 600.00. Thus, the bill balance is now BRL 400.00.
Report extract: System base date: 05/06/2019.
1.The result presented is the bill above for BRL 1000.00, but with a balance of BRL 400.00. That is because the partial posting had already been made on 05/09.
Parameter Consider Retroactive Balance = No
The result presented is the bill above for BRL 1000.00, but with a balance of BRL 1000.00. Even if the bill already had postings on 05/09, the balance is presented according to the balance on 05/06, when the value was still totally pending.
Parameter Consider Retroactive Balance = Yes
REPORT EXTRACT WITH BILLS IN FOREIGN CURRENCY
To generate a Bills Receivable Report (FINR130) considering a scenario with bills in foreign currency (dollar, for example), the following parameters must be considered:
MV_PAR(17) - Convert due date by:
- "Due date" The rate to be considered will be the rate on the due date of each bill (E1_VENCREA).
- "Base date" The rate to be considered will be the one entered in the "Base Date" question (36).
MV_PAR(20) - Compose Retroactive Balance:
- Yes The bill balances will be rebuilt to the reference date from the "Base Date" question (36).
- No The balances will be kept in the current status, regardless of the "Base date" question (36).
MV_PAR(30) - Other currencies:
- Convert - the balances will be converted to the currency selected in the "Which currency" question (15).
- Do Not Print - the balances will not be converted.
MV_PAR(36) - "Data Base" Enter the system base date to be considered so that you do not have to change it before printing the report.
Scenario:
When the parameter “Compose retroactive Balance?” (MV_PAR20) = SIM, the system considers as the report base date the date entered in the “Data Base” (MV_PAR36) parameter.
When there are bills in foreign currency to be printed and the parameter MV_PAR30 “Other Currencies” = CONVERT, the system checks the existence of a hired rate(E1_TXMOEDA). If it exists, this will be the one considered for converting. If there is no hired rate, the system fetches the conversion rate in the Currency File (SM2).
Frequently Asked Questions:
If the question “Compose Retroactive Balance? = YES, and no hired rate exists in the field (E1_TXMOEDA), and no registered currency rate exists (SM2) in the date entered in the "Data Base" question, the bill balance is printed as 0.00 (zeroed) in the report.
Example:
CONVERSION USD X BRL
BILL X RATE
USD 1,000.00 X 0.00 = BRL 0.00 -> The bill is displayed in the report with a caption to inform that no rate exists for currency conversion.
Entry points currently enabled:
Name | Description |
---|---|
F130Qry | Allows you to use filters in the main query of the FINR130 report |
FR130TELC | |
F130FILT |