About Importing Batches

Sage 300 ERP

Home > Entering and Posting Transactions > About Importing Batches

About Importing Batches

You can use the Import command on the G/L Journal Entry File menu to transfer to General Ledger batches of transactions that were:

Exported by Sage 300 ERP ledgers at other physical locations.
Created by non-Sage 300 ERP programs.

After importing the transactions, you can edit, print and post them in Sage 300 ERP General Ledger.

Note: If the batch file does not contain valid data, it is not imported.

Tip: To see how the data records should be organized, we recommend that you export a record from Sage 300 ERP in the format that you want to import. (For more information on creating batches for importing, see the "Import Data into Sage 300 ERP" topic in the System Manager help.)

Importing Batches from Another Location

Generally, you use the Import feature to transfer Sage 300 ERP batches that are created in another location for posting to your General Ledger. (If your subledgers are in the same database as your General Ledger, they create batches directly in General Ledger.)

Import batches can be created off-site in one of two ways:

By using the G/L Journal Entry screen in the remote site to create the batch.Then, you use the Export command on the Journal Entry screen's File menu to create a batch that can be imported by your General Ledger.
By creating a General Ledger batch in a database that does not have General Ledger activated. For example, if you have a branch office database that contains Accounts Receivable or Accounts Payable ledgers—but no General ledger—Sage 300 ERP will create a G/L import batch file when you create a batch for posting to General Ledger.

Import batches created automatically by Sage 300 ERP are in CSV text format (comma separated values).

If you are exporting a batch manually (using the File > Export command in the Journal Entry screen), you can choose from a variety of formats. However, if you are creating the file for Sage 300 ERP, there is no reason to use another format.

Importing Batches from Non-Sage 300 ERP Programs

The only way to transfer batches created by non-Sage 300 ERP programs into General Ledger is to import them.

As with transactions generated by Sage 300 ERP subledgers, the source code attached to the detail indicates the transactions’ source ledger and type. You must define your source codes in the source program, and then add them to General Ledger before you export transactions.