Offline Accounting - CTBAFIN - Financial - P12

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

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.

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

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

04. ENTRY POINTS

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

Entry Point	Note
F370CTBUSR	The entry point at the end of processing for complementary user processes. Documentation: http://tdn.totvs.com/display/PROT/DT_PONTO_ENTRADA_FIM_CONTABILIZACAO_OFFLINE_FINANCEIRO
F370E5F	Used as a string complement in the SE5 data filter in accounting. Documentation: F370E5F - Entry Point to filter SE5 records from the CTBAFIN routine
F370E2F	Used as a string complement in the SE2 data filter in accounting. 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	Allows you to change the sorting key of the SE5 bank transactions accounting. Documentation: https://tdn.totvs.com/x/4wsOAw
F370E1F	It confirms the selection of the bill for accounting. 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	Handles what will be calculated in the offline accounting routines - FINA370 and CTBAFIN. Documentation: http://tdn.totvs.com/pages/viewpage.action?pageId=185736570
F370E5MBX	Allows you to add post types to a list of items that should not be booked. Documentation: F370E5MBX - Allows you to enter posting purposes that will not participate in the accounting of bank transactions - SE5.
F370E5R	Used in the treatment for accounts receivable accounting. Documentation: http://tdn.totvs.com/display/public/mp/F370E5R+-+Contabiliza+contas+a+receber+--+11765
F370E5P	Used in the treatment of accounting payable. Documentation: http://tdn.totvs.com/pages/releaseview.action?pageId=6071027
F370BORD	Used to validate Standard Entries.
F370EFF	Used to filter SEF data at the time of accounting. Documentation: F370EFF - Entry Point to filter SEF records from the CTBAFIN routine
F370EUF	Used to filter data from SEU bills in accounting. Documentation: http://tdn.totvs.com/display/public/mp/F370EUF+-+Filtra+dados+--+11768
CtbPFO7	The entry point for positioning in table FO7 in the accounting of travel rendering of accounts before the execution of standard entries 8B3, 8B5. Documentation: http://tdn.totvs.com/display/PROT/DT_CTBPFO7_Ponto_de_Entrada

05. STANDARD ENTRY

Information

LP configuration models - Financial

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

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

Páginas filhas