G/L Consol. Import Screen

Click Add to List to open the Add to Import List window.

Important! All export files are removed from the folder during the import process. Make sure you back up all exported files before proceeding. Import records are copied from the export folder to the \Company\Company ID\ZCImport folder in the installation path.

Click Close to close the screen.

After you select general ledger data to import, this column displays one of the following states:

• Yes. The selected data can be imported.
• No. The selected data cannot be imported.
• N/A. The data is not available for import.

Double-click the Accounts column to toggle between Yes and No. The column can display the following values:

• No. Do not import accounts.
• Yes. Import accounts.
• N/A. Accounts were not included in the data to be exported.
• Missing. Accounts were exported, but the file (UnitSEQ#.ACT) is not in the import directory.
• Aborted. The import was stopped before the procedure was complete.
• Previously Imported. You cannot import the same data twice.

This column displays Yes if you included account groups as data to be exported when setting up the export process ID. If you did not select account groups, this column displays N/A.

You can double-click the column to toggle between Yes and No. The column can display the following values:

• No. Do not import account groups.
• Yes. Import account groups. (You can double-click on the field to change it to No.)
• N/A. Account groups were not included in the data to be exported.
• Missing. Account groups were exported, but the file (UnitSEQ#.AGP) is not in the import directory.
• Aborted. The import was halted before the procedure was complete.
• Previously Imported. You cannot import the same account groups more than once.

This column displays Yes if you included account optional fields as data to be exported when setting up the export process ID. If you did not select account groups, this column displays N/A.

You can double-click the column to toggle between Yes and No.

Specify whether to import budgets. You can double-click the column to toggle between Yes and No.

The column can display the following values:

• No. Do not import budgets.
• Yes. Import budgets.
• N/A. Budgets were not included in the data to be exported.
• Missing. Budgets were exported, but the file (UnitSEQ#.BDG) is not in the import directory.
• Aborted. The import was halted before the procedure was complete.
• Previously Imported. You cannot import the same budget more than once.

The Import Audit report displays these statuses, plus Not Imported (but available) and Not Available.

This column displays the following messages about availability of general ledger data for import:

• Yes. The general ledger data is available for import.
• No. The general ledger data is not available for import.
• Not in Unit Maintenance. The unit ID for the general ledger data has not been defined on the G/L Consol Import Unit Maintenance screen. For more information, see G/L Consol. Import Unit Maintenance Screen.
• Same Sequence. This message appears when the destination company tries to import general ledger data with a unit ID and export sequence number that is the same as one previously imported. You can override this warning and continue with the import process.
• Bad Currency. This message appears under the following circumstances:
  • When the functional currency of the source company does not match the functional currency specified for the source company on the G/L Consol Import Unit Maintenance screen. For more information, see G/L Consol. Import Unit Maintenance Screen.
  • When the translation currency does not match the functional currency of the destination company. You cannot import general ledger data until you fix the currency issue.

This column displays the functional currency for the set of import files.

This column displays the method of export for the set of import files.

Each time an export is performed, a file in the form of UUUU####.XXX is created, where:

• UUUU is the unit ID
• #### is the export sequence number
• XXX is the extension

Example: UNIT0001.ACT

The program creates a number unique to each exported record. The number is used to identify the import record corresponding to the set of exported files being imported.

The export sequence number is also the number that appears in Restart Maintenance if an import fails.

This column displays the range of posting sequences exported.

These columns display Yes if you included Optional Fields From G/L Setup and/or Optional Fields From CS Setup as data to be exported when setting up the export process ID. You can double-click the column to toggle between Yes and No.

If you did not select these options, these fields display N/A.

This field displays the fiscal period for the set of import files.

This field displays messages about possible duplication:

• None. No apparent duplication.
• Same Posting Sequence. If the general ledger data was exported using the posting sequence method, this warning appears when data with the same unit ID and posting sequence number has already been imported. There is a potential for duplications.
• Same Fiscal Period. If the general ledger data was exported using fiscal periods, this warning is displayed when data with the same unit ID and fiscal year and period has already been imported. There is a potential for duplications.

This field displays the process ID for the set of import files.

This column displays Yes if you included segment codes as data to be exported when setting up the export process ID. If you did not select segment codes, this column displays N/A.

You can double-click the column to toggle between Yes and No. The column can display the following values:

• No. Do not import segment codes.
• Yes. Import segment codes.
• N/A. Segment codes were not included in the data to be exported.
• Missing. Segment codes were exported, but the file (UnitSEQ#.SEG) is not in the import directory.
• Aborted. The import was halted before the procedure was complete.
• Previously Imported. You cannot import the same data twice.

This column displays Yes if you included source codes as data to be exported when setting up the export process ID. If you did not select source codes, this column displays N/A.

You can double-click the column to toggle between Yes and No. The column can display the following values:

• No. Do not import source codes.
• Yes. Import source codes.
• N/A. Source codes were not included in the data to be exported.
• Missing. Source codes were exported, but the file (UnitSEQ#.SRC) is not in the import directory.
• Aborted. The import was halted before the procedure was complete.
• Previously Imported. You cannot import the same data twice.

This column displays Yes if you included transactions as data to be exported when setting up the export process ID. If you did not select transactions, this column displays N/A.

You can double-click the column to toggle between Yes and No. The column can display the following values:

• No. Do not import transactions.
• Yes. Import transactions.
• N/A. Transactions were not included in the data to be exported.
• Missing. Not in the import directory.
• Aborted. The import was halted before the procedure was complete.
• Previously Imported. You cannot import the same data twice.

This column displays Yes if you included transaction optional fields s as data to be exported when setting up the export process ID. If you did not select transaction optional fields, this column displays N/A.

You can double-click the column to toggle between Yes and No. The column can display the following values:

• No. Do not import transaction optional fields.
• Yes. Import transaction optional fields.
• N/A. Transaction optional fields were not included in the data to be exported.
• Missing. Transaction optional fields were exported, but the file (UnitSEQ#.SRC) is not in the import directory.
• Aborted. The import was halted before the procedure was complete.
• Previously Imported. You cannot import the same data twice.

This column displays the unit ID for the set of import files.

This column displays the description entered for the unit ID on the G/L Consol Import Unit Maintenance screen.

This column displays the fiscal year for the set of import files.