Understanding the Extracting and Exporting of Ledger Data Based on ETAFI and ACCON Formats

To assist international customers in extracting ledger data for other general purposes, the GLS7500 process enables the user to:

  • Select a language for account and alternate account descriptions.

  • Select a range of accounting periods.

  • Specify a ledger code and balance sheet indicator to filter data based on these account attributes.

  • Specify if the general ledger business unit is to be treated as a legal entity, thus including associated business units in the extract.

  • Include adjustment periods and balance forward amounts in the extract.

The Ledger File creation process (GLS7500) extracts ledger data on the basis of account values. Because many international organizations must report by using a local chart of accounts that are maintained in the Alternate Account table, the GLS7500 process enables the user to designate which ChartField (account or alternate account) is to be used to extract the ledger data. The process generates a flat file based on the ETAFI (ETAFI5), ETAFI6, and ACCON file layout specifications.