Generation of the Quarterly ECD Unified Archive - ECD - Bookkeeping Center - CTBS001 - Managerial Accounting - P12

INDEX

01. OVERVIEW

Generation of ECD unified file for companies with quarterly calculation.

02. EXAMPLE OF USE

The generation of the unified file is used in the cases of companies that perform profit and/or loss calculations in a quarterly manner. Replacing the need to generate the four files.

The prerequisites of this routine comprise:

Having a quarterly accounting calendar;
Performing the calculation of results quarterly.

03. BOOKKEEPING CENTER - ECD - CTBS001

This screen makes up the data extraction from the ECD bookkeeping.

Access the Managerial Accounting Module (SIGACTB) >Updates > Acct Bookkeeping > Bookkeeping Center (CTBS001)
Select the ECD option, and click Add.
Follow the steps by filling in the options according to the status of the company to be booked.
In the Calendar question, select a quarterly calendar. Continue.
In the Unified Quarterly Archive question, Select 1- Yes.

After the generation of the file, check blocks I250 and J005 and how the other accounting statements (Block J) present themselves with the divisions of the quarterly periods in a single file.

04. SCREEN

None

IMPORTANT!

The Unified Quarterly Archive is only available for use in version 12.1.17/later and in layout 7/later.

05. TABLES

From/To Table - CTx to CSx tables for ECD preparation

Functionality/Export	Accounting Source Tables	ECD Tables	Use Generic Function for Accounting Balance Extraction*
Company Data/ECD	SIGAMAT.EMP - Companies/Branches	CS0 – ECD – Revision CS1 - ECD - Additional Revision Information CS2 - ECD – Companies CSZ - ECF - ECF DATA	No
Ledger Account	CT1 - Chart of Accounts	CS3 - ECD - Chart of Accounts	No
Cost Center	CTT - Cost Center	CS5 - ECD - Cost Center	No
Reference Account	CVD - Referential Chart of Accounts	CS4 - ECD - Reference Chart of Accounts	No
Statement Management Plan	CTS - Management View	CS6 - ECD - Managerial View / Account	No
Default History	CT8 - Default History	CS7 - ECD - Default History	No
Signee	CVB - Accountant Data	CS8 - ECD – Accountants	No
Participant	CVC – Participants	CS9 - ECD – Participant	No
SCP	CVS – SCP Record	CSR - SCP Bookkeep. - Rec. 0035	No
Auditors	CVR - Auditors File	CSP - Auditors Bookk. - Rec. J935	No
Co-related Sub-accounts	CVT - Co-related Sub-accounts	CST - Co-related Sub-accounts Book.	No
Export of Accounting Transactions	CT6 - Batch Totals (V11) CTC - Document Balances (V12) CT2 - Accounting Entries	CSA - ECD - Transactions Headers CSB - ECD - Transactions items CSL - ECD - Referential transactions items	No
Export Trial Balances/Balances	CT7 - Chart of Accounts Balances CT3 - Cost Center Balances	CSC - ECD – Trial Balance CSK - ECD - Reference Account Balance	Yes
Accounting Statements: ECD Balance sheet/ECD Income Statement/ECD DMPL	CTS - Management View CTN - Accounting Ledgers Configuration CT7 - Chart of Accounts Balances CT3 - Cost Center Balances CS6 - ECD - Managerial View / Account	CSD - ECD - Balance Sheets header CSE - ECD - Balance Sheets items	Yes (use of managerial view)

Páginas filhas