Extracting Entities for Account Reconciliation
For Account Reconciliation, you can export periods, filters, and reconciliations from their respective dialogs, and then open the files in excel.
To extract entities for Account Reconciliation:
- Log in to Account Reconciliation and navigate to the page that contains the metadata
to be exported.
For example, to export reconciliation metadata for AR_RECON_ID, navigate to the Profiles page.
- Export the required metadata.
Ensure that you use Select Columns to select only the ID and name. Then, in Format in the Export Profiles dialog, select Formatted data (visible columns only).
- To export reconciliations, see Exporting Profiles.
- To export periods, see Importing Multiple Periods from a File.
- Open the export file and copy all the values in the ID and Name columns.
- Create a new Microsoft Excel file and add the following column names in the first
row:
entity
,en:value
, anden:synonyms
. - Paste the values copied in Step 3 under the columns
en:value
anden:synonyms
. - Under the column entity, in all rows that contain data, enter the name of the entity
for which metadata is being exported. For example, AR_RECON_ID.
Here is an example of a file for AR_RECON_ID:
- Save the file using the .csv format.