How to Import Data to G/L Consolidations in Sage 300


  1. Open General Ledger > G/L Consolidations > Import.
  2. Select an import selection method.  If you select Net Changes, Balances, or Fiscal Period, the Year/Period field becomes available.
  3. Click the Go button to see control files that match the criteria you selected.
  4. Click the Add to List button.  The Add To Import List window appears.
  5. Click the Browse button, specify the location where the files exported from the source company are stored, and then click OK.
  6. Click Add to add the exported files to the list for importing.  Data from the exported files appears in the table.
  7. If more than one line is displayed on the G/L Consol Import screen (that is, more than one import file was in the export folder) but you are importing only one set of data, select No in the Import column for each row you do not want to import.  To change the value from Yes to No, double-click the cell, or select the cell and press the spacebar.
  8. Check that the Can Import field displays Yes for the data you are importing.
  9. Click Import.  During the import process, the stored export files are deleted from the temporary storage
    location and saved to an archive folder.  Files imported successfully will be archived within the installation path in the following folder
    (where CompanyID is the destination company): 
    • \Company\Company ID\ZCimport\Archive 
      • When importing is complete, a message displays information about data that was imported successfully or could not be imported.
  10. Close the G/L Consol Import screen.
  11. Check your records to confirm that data was imported successfully. If any errors occurred, use the G/L Consol Export Setup screen to correct any setup errors in the source company, and then perform the export and import again.