Financials > Interfaces > Pre-consolidated balance export 

Use this function to export a pre-consolidated balance to be integrated into a financial reporting application. This function exports data from the Pre-consolidated balances (BALPRECSL) table and can be run in batch mode.

This function only applies to legal companies and ledgers with consolidation management selected.

The flow and partner correspond to those posted in accounting.

The pre-consolidated balance only contains data for the ledgers (manual or automatic) with consolidation management. 

If the ledger is general only, the pre-consolidation balance only contains general records (Dimension ID IDTCCE equals 0).

If the ledger is analytical only, the pre-consolidation balance only contains analytical records (Dimension ID is not equal to 0).

If the ledger is general and analytical, the pre-consolidation balance contains general records (Dimension ID equals 0) and analytical records (Dimension ID is not equal to 0).

Period 0 contains the carry-forward record when updated by the fiscal year end simulation process (FIYEND) or in real time when the FRWGAC – General balance year-end simulation and FRWANA – Analytical year-end balance simulation parameters are set to Yes.

The amounts are saved at the site level and noncumulative amounts are stored at company level.

Two parameters, defined at the company level, define the export template information to be used.

CSLEXP - Export template parameter (CPT chapter, CSL group) is used if no dimension details are requested.

CSLEXPANA – Export template (CPT chapter, CSL group) is used if dimension details are requested.

You can modify the standard template.

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Entry screen

    Fields

    The following fields are present on this tab :

    Selection

    • All companies (field ALLCPY)

    Select this check box to extract only legal companies that have consolidated ledgers. A file for each legal company is created.


    You can only access this option if have the necessary authorizations.

    Enter a legal company to export ledgers with consolidation management.

    • Ledger (field LEDTYP)

    Select one ledger type that must be consolidated.


    You can only access this option if have the necessary authorizations.

    • Period end (field ENDDAT)

    Export includes all amounts from the beginning of the Fiscal year until the Period in which the Period end date falls. For anything after this date, the amount is set to zero.

    • Dimension details (field ANAFLG)

    This check box is only available when you enter a single, legal company and if the ledger is general and analytical. If All companies is selected, this field is not available.

    For a general ledger

    This check box is cleared by default and cannot be modified.

    The process selects general records in the pre-consolidated balance (records with dimension ID IDTCCE = 0).

    The Export template defined in the CSLEXP – Export template parameter (CPT chapter, CSL group) value is used.

    For an analytical ledger

    This check box is selected by default and cannot be modified.

    The process selects analytical records in the pre-consolidated balance (records with dimension ID IDTCCE <> 0).

    The Export template defined in the CSLEXPANA -  Export template parameter (CPT chapter, CSL group)  value is used.

    • Off-balance-sheet (field HBI)

    Select this check box to export normal accounts with Off balance sheet.

    If this check box is cleared, only normal accounts are exported.

    • Balance sign (field SNSSLD)

    Use this field to select the difference between Debit and credit, or the difference between credit and debit.

    • Log (field TRCFLG)

    Select this check box to generate a log file that includes the export parameters for each company, the number of exported records, and the name of the export file.

    Destination

    • field TYPEXP

    Select Client to download the export file to your computer. You cannot select this option if you selected All Companies

    Select Server to download the file to a directory location based on the default directory identified in the EXPCSL - Consolidation export value parameter (CPT chapter, CSL group). You can also select a different directory or change the default parameter setting.

    • Directory (field VOLFIL)

    If you selected Server, the field defaults to the default directory identified in the EXPCSL - Consolidation export value parameter (CPT chapter, CSL group). You can also select a different directory or change the default parameter setting.

    Close

     

    Batch task

    This function can be run in batch mode. The standard task CSLEXP is provided for that purpose.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation