Histórico da Página

Índice

01. OVERVIEW

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

...

In the Offline Accounting window, a descriptive screen of the routine is displayed.
Click "Parameters".
1. The system displays the parameters screen.
Configure them according to field help instructions.
Observe the following parameter: Separates
1. Separate By?
  1. Period=The generation of accounting document generates an accounting document for each period date.
  2. 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).
  3. Process = For each accounted process (Addition Payable, Addition Receivable, Posting Payable, Posting Receivable, Bank Transaction etc.), a new accounting document is generated.

Dica

title	Tips

See more information on both cases - Document and Process - in the PARAMETERS APPLIED section in the Parameters/Separate by table

5. Check parameters and confirm them.

The system returns to the routine's description screen.

6. Confirm to start processing.

Important!

Informações

title

Nota

To run this routine, they must be registered in the SIGACTB.be able to perform the routine, it is necessary to register, in SIGACTB:

Accounting Calendar -

CTBA010

CTBA010
Accounting Currency - CTBA140

After registeringmaking the registrations, you should bind the currencies to the calendars.Currencies X Calendars - CTBA200

Currency X Calendar - CTBA200

Dica

title	Performance Tip

The performance of the accounting routine, because it covers all operations of the financial module, implies the gathering of information from several tables, and this makes the maintenance of the Database Application (DBMS) an essential element to obtain better time results and avoid waste. Visit the links below for more details on this maintenance:

In addition, it is worth mentioning:

Check if the LIB, AppServer, Smartclient, DBAccess, and License Server versions are the same as the last ones available in the Customer Portal because some improvements are constantly being implemented to optimize performance for the Protheus 12 environment;
Updates to DBAccess and AppServer must be performed simultaneously in most cases because changes made to the AppServer dbapi library are reflected in DBAccess.

Other tools for environment/performance support and analysis:

MallocIO - Function to measure network latency and feasibility of running Protheus

03. PARAMETERS APPLIED

Deck of Cards

effectDuration	0.5
history	false
id	samples
effectType	fade

Card

default	true
id	1
label	Parameters

Question

Description

Display Accounting Acc. Entry?

It indicates through the selection between the options Yes and No, if Select Yes or No to indicate whether to display the accounting entry must be displayed when the accounting is when booking online.

Example:

No.

Group Accounting Acc. Entry?

It indicates through the selection between the options Yes and No, if the accounting entries must be grouped Select Yes or No to indicate whether to group entries in a single row, line if the accounts, cost center, item, and value class are equal the same in the entries performed.

Example:

No.

Account Issues for issues?

Indicate through the selection Indicates by selecting between the options By issue date By the issuing dt. (Accounting Date Dt. = E2_EMIS1/E1_EMISSAO EMISAO) and and By the Database (dDataBase).

The accounting of accounts payable is based on the date of inclusion of the bill in the system. This occurs so that accounting postings are not made in periods already closed.

Informações

title	Concept

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

For example, when making a purchase on 10/28/21 October 28, 2021, from a supplier in Manaus, the invoice is issued on 10/28/21 October 28, 2021, and the cargo is delivered in São Sao Paulo on 11/3/21.November 3, 2021. Assuming that the company has already carried out made the monthly closing of the accounting closing, the company it could not account using the date of issuance issue of the invoice (10/28/21October 28, 2021). Due to this type of circumstance, conceptually, we must account for using the date of entry of the note invoice into the system.

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

Example:

06/24/2019

From Date?

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

Example:

06/1/2019

To Date?

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

Example:

06/30/2019

From Portfolio?

It indicates through the selection Indicates, by selecting between the options Receivable, Payable, Check, or All, if whether the accounting entry will filter by the bills bill nature.

Example:

No.

Account Posting postings?

It indicates through the selection between the Indicates, by selecting between options By Posting DateDt. (by the bill's posting date), By Digit DateTyping Dt. (by the user digital date) or By Availability Date time when the user typed it), or By Avail. Dt. (by the date of availability entered typed by the user to account in the date of the bill transaction date, and not by the bill's posting date), for the accounting entry filter.

Example:

No.

Cons. branches below?

Indicates by selecting Yes or No, whether the following two parameters will be considered in

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 filterbranch filter that the user has access to.

Example:

No.

From Branch?

It indicates Indicates by typing which branch will be the start beginning of the filter interval for offline accounting.

Example:

D MG 01

To Branch?

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

Example:

ZZZZZZZZ

Update Summarized summarized?

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

Example:

No.

Separate by?It indicates

Indicates through the Period, Document, or Process options.

Example:

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.

: For each Branch/Date informed, 01 (one) accounting document gathering the various financial processes will be generated;
Document: Each financial record must generate 01 (one) accounting document;
Process: 01 (one) accounting document will be generated for each financial process.

Informações

title	NOTICE: Definitions

1. CTBAFIN treats as a financial document:

Each issue of a bill (payable or receivable);
Each bill posting operation (payable or receivable - except those linked to a bordereau);
Each bill posting operation linked to a bordereau (payment or receipt), with the bordereau being the Financial Document;
Financial Application or Financial Loan;
Redemption of financial application or payment of financial loan;
Check issuance or posting;
Advances or Rendering of Travel Accounts.

2. The CTBAFIN process is treated as:

Accounts Payable Issuance;
Accounts Receivable Issuance;
Posting of Accounts Payable;
Posting of Accounts Receivable;
Bank transactions (Applications, Redemptions, Deposits, Withdrawals, or Bank Transfers);
Issuance and/or posting of checks;
Travel-related operations (Advances, Rendering of Accounts, etc.).

Account Bordereau?

Indicates, by means of the Total Bordereaux or Bordereau/Bordereau options, if the LP 532 accounting (Bosting of bordereau bills) will be dismembered or if daily accounting of the total of all bordereaux will take place (Documentation on the concept applied to the LP 532

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 Source Branch?

It indicates through the selection the options Indicates, by selecting Yes or No, if whether the following two parameters are will be considered in the offline accounting or not , through the origin source branch filter.

Example:

No.

Branch From Branch ?

It indicates Indicates by typing which branch will be the start beginning of the filter interval for offline accounting.

Example:

D MG 01

To Branch?

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

Example:

ZZZZZZZZ

Book Prov. Bill?

Indicates whether provisory

Accounting Provisional Bill ?

It indicates if the provisional bills must be accountedbooked.

Example:

No.

Card

default	true
id	2
label	Parameters (SX6)

Parameter

Description

Default Content

MV_CFINTHR

Number The number of threads to be used in the quantity of the threads to be used in Financial to speed up the accounting queue (CTBAFIN), minimum 1, maximum 15.with a minimum of 2 and a maximum of 30.
Each processing instance requires that the minimum number of records be equal to or greater than 200.

Check this page MV_MXRCTHR

1

MV_FINLOG

It indicates Indicates whether or not the financial module offline accounting of the Financial module will generate the non-accounted unaccounted records log (.T.) or in warnings alerts (.Ff.)Document. Documentation: {+}https://tdn.totvs.com/x/zN6pHg+

.F.

MV_DIRDOC

Destination The target directory where the knowledge base files are files of the Knowledge Base will be stored.

\DIRDOC|\

MV_CTBUPRC

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

.F.

MV_TIPOLOG

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

1

MV_SLDBXCR

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

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

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

B

MV_CTCHQBX

Defines at what moment the accounting of the check when the check will be accounted for on the posted bill will occur: 1 = GeneratedGeneration, 2 2 = Release.

1

MV_CTMOVPA

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

1

MV_CTBAGP

Define Defines whether the PCC bills are accounted for by their grouped bills groupings or not (Default = .F.).

.F.

MV_NATTROC

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

"TROCO"

MV_GPDOCTB

Determine the Lps Determines that LPs 560 and 561 (Bank Transfer) are grouped in a single will be grouped into the same accounting document when the question "Separate by?" has is set to Document value.

.F.

MV_BXCNAB

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

N

MV_UNIAO

Used to identify Identify the code given to the Federal Revenue Secretariat to pay the for payment of Income Tax.

UNIAOUNION

MV_MUNIC

Used to identify Identifies the code given to the City Finance Secretariat to pay ISSof the finance department of the municipality for ISS collection.

MUNIC

MV_ORDLCTB

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

L

MV_CTBINTE

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

1

MV_DATADE

Start date of reference the period for entering valid entries in for accounting.

20010101

MV_DATAATE

End date of reference the period for entering valid entries in for accounting.

20020531

MV_CTBAIXA

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

C

MV_CARTEIR

Bank codes operating in Codes of banks in the portfolio.

MV_CTBFLAGIt indicates

Indicates at which time the selection of the accounting flags

of

in the financial records will be made:
- .T. value (Recommended) - through the accounting module - SIGACTB - where there is a transaction tracking (*);
- value .F. (Default) - Through the SIGAFIN module itself: CTBAFIN - where there is no transaction tracking, i.e. the flag selection occurs without checking that errors or cancelations have occurred.

Informações

title	Database - Transaction Tracking

A transaction is a single work unit. If a transaction succeeds, all data changes made during the transaction are confirmed and become a permanent part of the database. If a transaction finds errors or needs to be canceled and or reversed, all data changes will be deleted.

Source: Microsoft - SQL documents

.F. (Default)

.T. (Recommended) offline routines will be flagged in the accounting entry transaction - SIGACTB..F.

MV_BX10925

Define Defines when the handling withholding of the withholding PIS, COFINS, and CSLL taxes , is processed: 1 = During At Posting or 2 = In the IssuanceAt Issue.

1

MV_CTMSFIL

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

.F.

MV_MXRCTHR

The minimum number of records for a thread to be used in multi-thread processing.

200

MV_CNOUTR

Trace/Log for analysis in the performance of the accounting integration - MV_CONOUTR

Âncora

	composition-deck-samples
	composition-deck-samples

...

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

Entry Point	Note
F370CTBUSR	Entry The entry point at the end of the processing for complementary user additional processes. DocumentDocumentation: {+}http://tdn.totvs.com/display/PROT/DT_PONTO_ENTRADA_FIM_CONTABILIZACAO_OFFLINE_FINANCEIRO+
F370E5F	Use Used as a string complement of the string in the SE5 data filter in the accounting. Document: {+}http://tdn.totvs.com/display/public/mp/F370E5F+-+Complementa+filtro+--+11763+Documentation: F370E5F - Entry Point to filter SE5 records from the CTBAFIN routine
F370E2F	Used as a string complement of the string in the SE2 data filter in the accounting. Document: {+}http://tdn.totvs.com/display/public/mp/F370E2F+-+Complementa+filtro+--+11762+ Documentation: F370E2F - Entry Point to filter SE2 records from the CTBAFIN routine
F370EFK	Allows you to change the sorting key of the check accounting in the offline accounting routine. Documentation:	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 Allows you to change the sorting key of the SE5 Bank Transactions bank transactions accounting. DocumentDocumentation: {+}https://tdn.totvs.com/x/4wsOAw+
F370E1F	Confirm It confirms the selection of the bill for accounting. Document: {+}http://tdn.totvs.com/pages/viewpage.action?pageId=6071024+ Documentation: F370E1F - Entry Point to filter SE1 records from the CTBAFIN routine
F370E1W	Changes the condition of the repeat loop "while" executed in table SE1. Documentation:	F370E1W	Edit the the "while" loop executed in the SE1 table. Document: {+}http://tdn.totvs.com/pages/viewpage.action?pageId=185752211+
F370NATP	Manipulate Handles what will be calculated in the Offline Accounting offline accounting routines - FINA370 and CTBAFIN. DocumentDocumentation: {+}http://tdn.totvs.com/pages/viewpage.action?pageId=185736570+
F370E5MBXAllow	adding types of posting, which will not be accounted, Allows you to add post types to a list of items .Document: that should not be booked. Documentation: F370E5MBX - Allows you to enter posting purposes that will not participate in the accounting of bank transactions - SE5F370E5MBX - Allow entering the posting reasons that will be part of the bank transactions accounting.
F370E5R	Used when handling in the treatment for accounts receivable accounting. DocumentDocumentation: {+}http://tdn.totvs.com/display/public/mp/F370E5R+-+Contabiliza+contas+a+receber+--+11765+
F370E5P	Used when handling the accounts payablein the treatment of accounting payable. Documentation: Document: {+}http://tdn.totvs.com/pages/releaseview.action?pageId=6071027+
F370BORD	Used to validate Standard EntryEntries.
F370EFF	Used to filter SEF data at the time of the SEF during accounting. Document: {+}http://tdn.totvs.com/display/public/mp/F370EFF+-+Filtra+dados+--+11767+Documentation: F370EFF - Entry Point to filter SEF records from the CTBAFIN routine
F370EUF	Used to filter data from SEU bill bills in the accounting. DocumentDocumentation: {+}http://tdn.totvs.com/display/public/mp/F370EUF+-+Filtra+dados+--+11768+
CtbPFO7	Entry point to place the FO7 table The entry point for positioning in table FO7 in the accounting of the provision of account of trips, travel rendering of accounts before the execution of the standard entries 8B3, 8B5. DocumentDocumentation: {+}http://tdn.totvs.com/display/PROT/DT_CTBPFO7_Ponto_de_Entrada+

05. STANDARD ENTRY

Informações

title	Information

LP configuration models - Financial

Informações

title	LP 501 and 502 - Behaviors

The inclusion of the RA-type bill is made using standard entry 501. This can be done online using the Accounts Receivable (FINA040) routine, or offline using the Offline Accounting routine (CTBAFIN).

When the inclusion of the RA-type bill has already been accounted for, regardless of whether it was Online (FINA040) or Offline (CTBAFIN), the accounting of the deletion of the RA-type bill will be carried out by the Accounts Receivable routine (FINA040) using the standard entry 502.

If the inclusion of the RA-type bill is not accounted for, the deletion of this bill will also not be accounted for via the Offline Accounting routine (CTBAFIN).

SE Configuration Models - Financials

Informações

title	Accounting FLAG: Behavior

Accounting FLAGS are saved from the moment the record passes through the assessment of the rule defined in the standard entry (CT5_VLR01), whether it is met (return .T.) or not (return .F.).

Therefore, once the LPs are present and active, the system will make the respective flag selection on the linked records regardless of the returned value and the manipulation of the records in the accounting screen (even if the rows are deleted)

Card

default	true
id	2
label	Parameters (SX6)

Informações

title	Information

06. NOTE

When the TopConnect is used (Relational Database), the accounting may be processed in batch mode through the Schedule routine (automatic execution), through the Configurator Configuration module.
The E5_NODIA, E5_DIACTB fields are only completed when the accounting is through document.

...

Páginas filhas

Versões comparadas

Versão antiga 13

Nova versão Atual

Chave

01. OVERVIEW

03. PARAMETERS APPLIED

05. STANDARD ENTRY

06. NOTE