Index

01. OVERVIEW

The main goal of the Wizard is to enable operators to generate the file Digital Cash Book of Rural Producer in accordance with their parameter settings.

To accomplish this, you must meet some preconditions:

1. To have at least one registered Property / Branch (Real Estate Register in Related Contents);
2. To be registered as Declarant (see Persons Register in Related Contents) of LCDPR in at least one of the properties;
3. To have at least one Bank Account registered as "Title Holder" in the Bank Register (table SA6).

As a result, the file will be generated based on financial transactions (table SE5), of selected branch(es) (which are properties), and that have financial natures registered in 'Generate LCDPR  ?' as 'Yes'.

All transactions made in one of the banks indicated in the LCDPR Extractor as belonging to the Declarant will be printed in block 'Q', of transactions, with the bank account ID code.

If the transaction has a financial nature with 'Generate LCDPR ?' = 'Yes', but the account is not declared, it is displayed as 'Amount in Transit' (code '999').

Yet in cases in which the transaction is a cash payment (reason for posting equal to 'Cash Money'), it is displayed as payment in Cash Money (code '000').

       Still in the transactions block, the identified document types (default) are:

1. Invoice (document type = 'NF');
2. Bill (document type = 'FT');
3. Receipt (document type = 'RC');
4. Contract (document type = 'C01');
5. Payroll (document type = 'FOL');
6. Other (the remaining document types).

       To change these default types, you must use one of the two entry points available for routine LCDPR Extractor. For further information, check the link in item 05 of this document.

02. MAIN SCREEN

The Wizard is displayed onscreen so you can set the initial parameters for generating the obligation.

On this first screen you can check the name of the routine, its purpose and the LCDPR layout version currently supported by the application.

Initial Parameters:

Code of Owner (direct query of Persons Register, filtering declarants):

Calculation Method: The calculation method of the chosen rural activity indicates the natural person calculated the result based on:

1) Cash Book: calculated the result of rural activity based on entries registered in the Rural Producer Cash Book; or

2) Calculated the Result  of rural activity based on the option provided in art. 5º of Law No. 8,023, of 1990 (20% of Gross Revenue).

Special Status: Indicator of Special Status and Other Events:

0 - Regular;

1 - Bereavement;

2 - Estate;

3 - Definitive departure from country.

Special Status Date: Date of Special Status: in case of bereavement of natural person, the date of death.

Start of period indicator: This period can be:

0 - Regular (starts on first day of year);

1 - Opening (activities begin on calendar year);

2 - Start of bookkeeping requirement during the calendar year. (Example: noncompliance as exempt from IRPF)

By Date: It defines whether transactions are taken into account by credit date (E5_DTDISPO) or posting date (E5_DATA).

Start Date: Start date of period. Start date of information found in file. Fill out this field with the start date of period corresponding to the calendar year referred to by the LCDPR.

End Date: End date of period.

Real Estate properties screen:

Screen to select the Bank Accounts of declarant:

Screen to define the accountant and file directory:

Note: the option to create a .CSV file (separated by comma) is available from the accumulated Continuous Dispatch of 5/17/2021 onwards.

03. MAIN FIELDS AND PARAMETERS

Main Fields and Parameters

04. RELATED CONTENTS

Persons Register (FINA031):

https://tdn.totvs.com/x/dW76Hg+

Real Estate Properties Register (FINA029):

https://tdn.totvs.com/x/Xmz6Hg

Facilitator of Nature (FINA010):

https://tdn.totvs.com/x/qgBlDw+

Adjustment in Bank Register (MATA070):

For a given bank account (table SA6) to be available for selection in the LCPDR Extractor,  it must be defined as Title Holder:

Note: For title holder accounts, the Country of the account (another information the LCDPR Extractor uses) becomes a requirement.

For accounts that have a registered code (A6_COD) that differs from the bank codes from the Central Bank, we offer the field "Official Bank" (based on the "0N" banks table) with all the codes of the main existing banks.

You can also complete this table of Banks whenever you need.

05. ENTRY POINTS

F820Qry - Handling of condition of LCDPR Extractor
F820Reg - Control of LCDPR records        
F820Bco - Data adjustment of bank accounts selected in LCDPR