01. OVERVIEW

This routine aims at generating offline accounting entries for financial operations.

02. EXECUTION

For the offline accounting:

  1. In the Offline Accounting window, a descriptive screen of the routine is displayed.
  2.  Click "Parameters".The system displays the parameters screen.
  3. Configure them according to field help instructions.
  4. Observe the following parameter:  Separates By? Period=The generation of accounting document generates an accounting document for each period date.Document = For each financial document (bills, for example) accounted, an accounting document is generated (similar operation to the online accounting, where each accounted bill generates a new accounting document).Process = For each accounted process (Addition Payable, Addition Receivable, Posting Payable, Posting Receivable, Bank Transaction etc.), a new accounting document is generated.
  5. Check parameters and confirm them.The system returns to the routine's description screen.
  6. Confirm to start processing.



To run this routine, they must be registered in the SIGACTB. 

Accounting Calendar - CTBA010

Accounting Currency - CTBA140

After registering, bind the currencies to the calendars.

Currencies X Calendars - CTBA200  


03. PARAMETERS APPLIED


Question

Description

Display Accounting Entry?

It indicates through the selection between the options Yes and No, if the accounting entry must be displayed when the accounting is online.
Example:
No.

Group Accounting Entry ?

It indicates through the selection between the options Yes and No, if the accounting entries must be grouped in a single row, if the accounts, cost center and value class are equal in the entries performed.
Example:
No.

Account Issues ?

Indicate through the selection between the options By issue date ( Accounting Date = E2_EMIS1 / E1_EMISSAO ) and By Database (dDataBase).


Accounting for accounts payable is based on the date of inclusion of the bill in the system. This is so that accounting entries are not made in periods that have already ended.

For example, when making a purchase on 10/28/21 from a supplier in Manaus, the invoice is issued on 10/28/21 and the cargo is delivered in São Paulo on 11/3/21.

Assuming that the company has already carried out the monthly accounting closing, the company could not account using the date of issuance of the invoice (10/28/21). Due to this type of circumstance, conceptually we must account for using the date of entry of the note into the system.

For the accounts receivable, the bill generation date is considered.  

Example:

06/24/2019

From Date ?

It indicates through the selection From Date?, the beginning of the interval of time to filter the records for the offline accounting.

Example:
06/1/2019

To Date ?

It indicates through the selection To Date?, the end of the interval of time to filter the records for offline accounting.

Example:
06/30/2019

From Portfolio ?

It indicates through the selection between the options Receivable, Payable, Check or All, if the accounting entry will filter by the bills nature.
Example:
No.

Account Posting ?

It indicates through the selection between the options By Posting Date (by the bill posting date), By Digit Date (by the user digital date) or By Availability Date (by the availability entered by the user to account the bill transaction date, and not by the bill posting date) for the accounting entry filter.

Example:
No.

Consider Branches Below ?

It indicates through the selection of the options Yes and No, if the two following parameters are considered in the offline accounting or not, through the branches filter.

Example:
No.

From Branch ?

It indicates which branch will be the start of the filter interval for offline accounting.

Example:
D MG 01

To Branch ?

It indicates which branch will be the end of the filter interval for offline accounting.

Example:
ZZZZZZZZ

Update Summarized ?

It indicates through the options Yes or No, if the summarized accounts (child accounts of the detailed accounts) are updated in the offline accounting.

Example:
No.

Separate by ?

It indicates through the options Period (period chosen by the user before in the questions From Date ? and To Date ?), Document (separate by bordereau included in the chosen period) or Process (separate by bordereau in which there are several bills linked to the it).

Example:
No.

Account Bordereau ?

It indicates through the options Total Bordereau or Bordereau/Bordereau, if the accounting of the LP 532 (Posting of bills in the bordereau) will be separated bordereau by bordereau, or daily, the total accounting of all bordereau (Document on concept applied to LP 534)

Example:
No.

Consider Original Branch ?

It indicates through the selection the options Yes or No, if the following two parameters are considered in the offline accounting or not, through the origin branch filter.

Example:
No.

From Branch ?

It indicates which branch will be the start of the filter interval for offline accounting.

Example:
D MG 01

To Branch ?

It indicates which branch will be the end of the filter interval for offline accounting.

Example:
ZZZZZZZZ

Accounting Provisional Bill ?

It indicates if the provisional bills must be accounted.

Example:
No.

Parameter

Description

Default Content

MV_CFINTHR

Number of threads to be used in the quantity of the threads to be used in Financial (CTBAFIN), minimum 1, maximum 15.

1

MV_FINLOG

It indicates whether the offline accounting of the Financial module will generate the non-accounted records log (.T.) or in warnings (.F.)

Document: {+}https://tdn.totvs.com/x/zN6pHg+

.F.

MV_DIRDOC

Destination directory where the knowledge base files are stored.

\DIRDOC|

MV_CTBUPRC

Define if you want to account through the new accounting model, with dynamic procedures for validations and addition of data CT2 and CV3 (.T.).

.F.

MV_TIPOLOG

Enter 1 to generate the log file in txt or 2 to generate the report.

1

MV_SLDBXCR

It indicates how the balance of the accounts receivable posting will be controlled, only when the check is cleared, or during posting (B,C).

The offline accounting uses the configuration of this parameter as follows:

  • Value B: Use the LP 520 through the Posting record - SE5->E5_TIPODOC = VL
  • Value C: Use the LP 559 through the record of the check clearance date - SEF->EF_DTCOMP

B

MV_CTCHQBX

Defines at what moment the accounting of the check on the posted bill will occur: 1 = Generated,  2 = Release.

1

MV_CTMOVPA

It indicates if the LP 513 Online Accounting will occur through Bill (SE2) or Bank Transaction (SE5) of the Anticipated Payment, 1="SE2" / 2="SE5".

1

MV_CTBAGP

Define whether the PCC bills are accounted by their grouped bills (Default = .F.).

.F.

MV_NATTROC

Determine which nature will be used in the generation of change output from SIGALOJA and FRONTLOJA.

"TROCO"

MV_GPDOCTB

Determine the Lps 560 and 561 (Bank Transfer) are grouped in a single accounting document when the question "Separate by ?" has Document value.

.F.

MV_BXCNAB

Define whether the posting of the bills in the CNAB return must be grouped, (S) Yes or (N) No.

N

MV_UNIAO

Used to identify the code given to the Federal Revenue Secretariat to pay the Income Tax.

UNIAO

MV_MUNIC

Used to identify the code given to the City Finance Secretariat to pay ISS. 

MUNIC

MV_ORDLCTB

Define the order of accounting entries in the batch/integration doc, "L"-Default Standard Entry Order, "E" Incoming Order and "T" - Type of Balance.

L

MV_CTBINTE

1 - Accounting by bill, 2 - Accounting by sales (Use only for integration)

1

MV_DATADE

Start date of reference for valid entries in accounting.

20010101

MV_DATAATE

End date of reference for valid entries in accounting.

20020531

MV_CTBAIXA

Type of Cash Accounting (Accounts Payable), (B) Posting, in the generation of (C) Check or in (A) Both cases.

C

MV_CARTEIR

Bank codes operating in portfolio.


MV_CTBFLAG

It indicates the accounting flags of the offline routines will be flagged in the accounting entry transaction - SIGACTB.

.F.

MV_BX10925

Define the handling of the withholding PIS, COFINS and CSLL taxes, 1 = During Posting or 2 = In the Issuance.

1

MV_CTMSFIL

Used in the offline accounting of the Financial with the question "Consider Original Branch" = YES,  .T. = Consider fields FILORIG / .F. = MSFIL.

.F.



04. ENTRY POINTS

Below is the list of entry points available in the Offline Accounting (CTBAFIN) routine.

Entry Point

Note

F370CTBUSR

Entry point at the end of the processing for user additional processes.

Document: {+}http://tdn.totvs.com/display/PROT/DT_PONTO_ENTRADA_FIM_CONTABILIZACAO_OFFLINE_FINANCEIRO+

F370E5F

Use as a complement of the string in the SE5 data filter in the accounting.

Document: {+}http://tdn.totvs.com/display/public/mp/F370E5F+-+Complementa+filtro+--+11763+

F370E2F

Used as a complement of the string in the SE2 data filter in the accounting.

Document: {+}http://tdn.totvs.com/display/public/mp/F370E2F+-+Complementa+filtro+--+11762+

F370EFK

Allow editing the ordering key of the accounting of checks in the Offline Accounting.

Document: {+}http://tdn.totvs.com/pages/releaseview.action?pageId=6071542+

F370E5K

Allow editing the ordering key of the SE5 Bank Transactions accounting. 

Document: {+}https://tdn.totvs.com/x/4wsOAw+

F370E1F

Confirm the selection of the bill for accounting.

Document: {+}http://tdn.totvs.com/pages/viewpage.action?pageId=6071024+

F370E1W

Edit the the "while" loop executed in the SE1 table.

Document: {+}http://tdn.totvs.com/pages/viewpage.action?pageId=185752211+

F370NATP

Manipulate what will be calculated in the Offline Accounting routines - FINA370 and CTBAFIN.

Document: {+}http://tdn.totvs.com/pages/viewpage.action?pageId=185736570+

F370E5MBX

Allow adding types of posting, which will not be accounted, to a list of items.Document: F370E5MBX - Allow entering the posting reasons that will be part of the bank transactions accounting.

F370E5R

Used when handling accounts receivable accounting.

Document: {+}http://tdn.totvs.com/display/public/mp/F370E5R+-+Contabiliza+contas+a+receber+--+11765+

F370E5P

Used when handling the accounts payable

Document: {+}http://tdn.totvs.com/pages/releaseview.action?pageId=6071027+

F370BORD

Used to validate Standard Entry.

F370EFF

Used to filter data of the SEF during accounting.

Document: {+}http://tdn.totvs.com/display/public/mp/F370EFF+-+Filtra+dados+--+11767+

F370EUF

Used to filter data from SEU bill in the accounting.

Document: {+}http://tdn.totvs.com/display/public/mp/F370EUF+-+Filtra+dados+--+11768+

CtbPFO7

Entry point to place the FO7 table in the accounting of the provision of account of trips, before the execution of the standard entries 8B3, 8B5.

Document: {+}http://tdn.totvs.com/display/PROT/DT_CTBPFO7_Ponto_de_Entrada+

05. STANDARD ENTRY


LPs Configuration Models - Financials


Parameters (SX6)
Note
Booking by posting type:
Bills: For regular bills, the standard entry is 530. For advance bills the standard entry is 513.
Bordereaux: For regular bills, the standard entry will be 532, for prepayment bills, the standard entry is 513.
                  Taxes with generating factor "Cash" (posting), generated by the bordereau, using the standard entry 532,
cannot be viewed in the Offline Accounting screen, so they must be accounted through standard entry 530.
Note: If the parameter "Account by" is set as "Bordereau/bordereau", the standard entry 513 is not accounted.

06. NOTE

07. OTHER INFORMATION

Offline accounting with multiple processes – Financial
Entry Points.
Semaphore - Table F74 - Control of Simultaneous Processing in the Financial
532 Posting of Bills Per Payment Bordereau