Offline Accounting - CTBAFIN - Financial - P12

...

Índice

01.

...

OVERVIEW

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

02. EXECUTION

For the offline accounting:

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.

...

Nota
To

...

be able to perform the routine, it is necessary to register, in SIGACTB:

Accounting Calendar -

...

CTBA010
Accounting Currency - CTBA140

After

...

making the registrations, you should bind the currencies to the calendars.

...

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
...
Acc. Entry?
...
Select Yes or No to indicate whether to display the accounting entry
...
when booking online.
Example:
No.
Group
...
Acc. Entry?
...
Select Yes or No to indicate whether to group entries in a single
...
line if
...
accounts, cost center, item, and value class are
...
the same in the entries
...
.
Example:
No.
Account
...
for issues?
...
Indicates by selecting between the options
...
By the issuing dt. (Accounting Dt. = E2_EMIS1/E1_
...
EMISAO)
...
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
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.
For example, when making a purchase on October 28, 2021, from a supplier in Manaus, the invoice is issued on October 28, 2021, and the cargo is delivered in Sao Paulo on November 3, 2021. Assuming that the company has already made the monthly closing of the accounting, it could not account using the date of issue of the invoice (October 28, 2021). Due to this type of circumstance, conceptually, we must account using the date of entry of the invoice into the system.

For accounts receivable, the bill generation date is considered.
Example:
06/24/2019
From Date?
...
This indicates
...
the start of the date interval
...
to filter
...
records for
...
offline accounting.
Example:
06/1/2019
To Date?
...
This indicates
...
the
...
end of the time interval
...
to filter
...
records for offline accounting.
Example:
06/30/2019
From Portfolio?
...
Indicates, by selecting between the options Receivable, Payable, Check, or All,
...
whether the accounting entry will filter by
...
bill nature.
Example:
No.
Account
...
postings?
...
Indicates, by selecting between options By Posting
...
Dt. (by the bill's posting date), By
...
Typing Dt. (by the
...
time when the user typed it), or By Avail. Dt. (by the date of availability
...
typed by the user to account in the date of the bill transaction
...
,
...
not by the bill's posting date), for the accounting entry filter.
Example:
No.
...
Consider Branches Below ?
Cons. branches below?
Indicates by selecting Yes or No, whether the following two parameters will be considered in
...
offline accounting or not
...
through the
...
branch filter that the user has access to.
Example:
No.
From Branch?
...
Indicates by typing which branch will be the
...
beginning of the filter interval for offline accounting.
Example:
D MG 01
To Branch?
...
Indicates by typing which branch will be the end of the filter interval for offline accounting.
Example:
ZZZZZZZZ
Update
...
summarized?
...
Indicates, through the
...
Yes or No options,
...
whether summarized accounts (child accounts of
...
detailed accounts)
...
will be updated in
...
offline accounting.
Example:
No.
Separate by?
...
Indicates through the Period, Document, or Process options.
Example:
Period
...
Account Bordereau ?
: 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
...
)
Example:
No.
Consider
...
Source Branch?
...
Indicates, by selecting Yes or No,
...
whether the following two parameters
...
will be considered in
...
offline accounting or not
...
through the
...
source branch filter.
Example:
No.
Branch From
...
?
...
Indicates by typing which branch will be the
...
beginning of the filter interval for offline accounting.
Example:
D MG 01
To Branch?
...
Indicates by typing which branch will be the end of the filter interval for offline accounting.
Example:
ZZZZZZZZ
...
Accounting Provisional Bill ?
...
Book Prov. Bill?
Indicates whether provisory bills must be
...
booked.
Example:
No.
Card
default true
id 2
label Parameters (SX6)
Parameter
Description
Default Content
MV_CFINTHR
...
The number of threads to be used
...
to speed up the accounting queue (CTBAFIN),
...
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
...
Indicates whether or not the financial module offline accounting
...
will generate
...
unaccounted records log (.T.) or
...
alerts (.
...
f.)
...
. Documentation:
...
https://tdn.totvs.com/x/zN6pHg
...
.F.
MV_DIRDOC
...
The target directory where the
...
files of the Knowledge Base will be stored.
\DIRDOC
...
\
MV_CTBUPRC
...
Defines whether to account
...
using the new accounting model, with dynamic procedures for validations and
...
inclusion of
...
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
...
Indicates how the balance of the posting of the accounts receivable
...
will be
...
tracked, only when the check is
...
compensated or at the time of the posting (B, C).
The offline accounting uses the configuration of this parameter as follows:
Value B:
...
Uses LP 520 through the
...
posting record - SE5->E5_TIPODOC = VL
Value C:
...
Uses LP 559 through the record of the check
...
compensation date - SEF->EF_DTCOMP
B
MV_CTCHQBX
Defines
...
when the check will be accounted for on the posted bill
...
: 1 =
...
Generation,
...
2 = Release.
1
MV_CTMOVPA
...
Indicates whether the LP 513
...
Offline Accounting will occur
...
by the Bill (SE2) or
...
Banking Transaction (SE5) of the
...
Advance Payment, 1="SE2" / 2="SE5".
1
MV_CTBAGP
...
Defines whether
...
PCC bills are accounted for by their
...
groupings or not (Default = .F.).
.F.
MV_NATTROC
...
Determines which nature will be used in the generation of change
...
outflow of SIGALOJA and FRONTLOJA.
"TROCO"
MV_GPDOCTB
...
Determines that LPs 560 and 561 (Bank Transfer)
...
will be grouped into the same accounting document when the question "Separate by?"
...
is set to Document
...
.
.F.
MV_BXCNAB
...
Defines whether the
...
CNAB return bill posts must be grouped, (S) Yes or (N) No.
N
MV_UNIAO
...
Identify the code given to the Federal Revenue
...
for payment of Income Tax.
...
UNION
MV_MUNIC
...
Identifies the code
...
of the finance department of the municipality for ISS collection.
MUNIC
MV_ORDLCTB
...
Sets the order of accounting
...
postings in the integration batch/
...
doc, "L"
...
=Default standard entry order, "E"
...
Inflow order, and "T"
...
= Balance Type
...
.
L
MV_CTBINTE
1 - Accounting by bill, 2 - Accounting by
...
sale (Use only for integration)
1
MV_DATADE
Start date of
...
the period for entering valid entries
...
for accounting.
20010101
MV_DATAATE
End date of
...
the period for entering valid entries
...
for accounting.
20020531
MV_CTBAIXA
Type of
...
Post Booking (Acc. Payable)
...
: (B) Posting, in the generation of (C) Check or
...
(A) Both cases.
C
MV_CARTEIR
...
Codes of banks in the portfolio.
...

MV_CTBFLAG
...
Indicates at which time the selection of the accounting flags
...
in the
...
.F.
...
MV_BX10925
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)

MV_BX10925
Defines when the withholding of PIS, COFINS, and CSLL taxes is processed: 1 = At Posting or 2 = At Issue
...
.
1
MV_CTMSFIL
Used in
...
offline accounting of the
...
financial module with the question "Consider
...
Source Branch" = YES
...
. .T. = Consider FILORIG fields
...
/.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

04. ENTRY POINTS

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.

Document

Documentation:

{+}

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

F370EFK

Allow editing the ordering key of the accounting of checks in the Offline Accounting.
Document: {+}

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:

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.

Document

Documentation:

{+}

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+

F370E1W

Edit the the "while" loop executed in the SE1 table.
Document: {+}

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:

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.

Document

Documentation:

{+}

http://tdn.totvs.com/pages/viewpage.action?pageId=185736570

+

F370E5MBX

Allow 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 - SE5

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

Document

Documentation:

{+}

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

+


F370E5P	Used

when handling the accounts payable
Document: {+}

in the treatment of accounting payable.

Documentation: http://tdn.totvs.com/pages/releaseview.action?pageId=6071027

+


F370BORD	Used to validate Standard

Entry

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

Document

Documentation:

{+}

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.

Document

Documentation:

{+}

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

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)

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.

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
Image Removed

Páginas filhas

Versões comparadas

Versão antiga 3

Nova versão Atual

Chave

Offline Accounting - CTBAFIN - Financial - P12

01.

OVERVIEW

02. EXECUTION

03. PARAMETERS APPLIED

04. ENTRY POINTS

05. STANDARD ENTRY

06. NOTE

07. OTHER INFORMATION

Páginas filhas

Histórico da Página

Versões comparadas

Versão antiga 3

Nova versão Atual

Chave

Offline Accounting - CTBAFIN - Financial - P12

01.

OVERVIEW

02. EXECUTION

03. PARAMETERS APPLIED

04. ENTRY POINTS

05. STANDARD ENTRY

06. NOTE

07. OTHER INFORMATION