Páginas filhas
  • FINR130 - Bills Receivable - Protheus 12

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.

01. OVERVIEW

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: 

  • Summarized or detailed values. 
  • Balance composition with retroactive date in a specific date
  • Multi-Branch transactions with totalizators by Order, Branch, and Company. 
  • Statements of provisional bills and discounted collection bills. 
  • Statement of bills in other currencies.
  • Statement of tax rebate in a detailed manner or by simple reduction. 
  • Balance composition by posting, credit, or typing date. 
  • Evaluation of bills deleted on a specific date. 
  • And various filter options for dates, prefix, number, type, customer, store, class, and others. 


02. PERFORMANCE

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:

  • The temporary file management is now the responsibility of the SGBD. This brings some benefits such as the ability to run SQL commands directly on the temporary files, improving performance since files are manipulated via query.
  • Even with the performance adjustment, it is recommended that bases with a high data volume run the report with direct printing to the server, since the network topology can drastically impact the report building time.


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.

03. QUESTIONS/FILTERS

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 /
Do Not List / Do Not Consider

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 /
Typing 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.

Obs.: When run via report schedule, as it does not have an interface with the use, the "Select Branches?" parameter will automatically select the branch registered in the schedule. To select more branches, we recommend using the "Cons. Branches Below?" parameter and entering the range in the "From Branch?" and "To Branch?" parameters.

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.

04. EXAMPLES

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


2. 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.


05. ENTRY POINTS

Entry points currently enabled:


06. TABLES USED

  • SE1 - Accounts Receivable
  • SE5 - Bank Transactions
  • SA1 – Customers
  • SA6 - Banks
  • FJU - Save Deleted Bills