Creating a Batch of General Ledger Transactions

Use the I/C Create G/L Batch screen to create batches of general ledger transactions from posted receipts, shipments, assemblies, internal usage transactions, adjustments, and transfers.

Note: Creating G/L batches in this screen is not necessary if you create G/L transactions automatically (either when you post transactions or when you run Day End Processing). For more information about options that control how general ledger transactions are created, see I/C G/L Integration Screen.

If you do not use General Ledger, or if your General Ledger system is at another location, general ledger transactions created by Inventory Control are added to a file called icgltran.csv, which is located in the same directory as your company database. More...

The file is in Comma Separated Values (CSV) format. This file can be imported by a remote site Sage 300 General Ledger or transferred to another general ledger that you use.

All general ledger transactions are placed in the same CSV file. Each time you create general ledger transactions in Inventory Control, you must choose whether to add the transactions to the file, or replace the file.

Warning! If you choose to replace the file, you will destroy all transactions that are already in the file.

  • On the Integration tab of the G/L Integration screen, specify G/L batch creation and posting options.
  • Run Day End Processing to update the company's Inventory Control data.
  • If you use General Ledger, print the G/L Transactions report, then file it with your audit trail reports.

To create a batch of G/L transactions:

  1. Open Inventory Control > I/C Periodic Processing > Create G/L Batch.

  2. Specify the day-end number through which to create general ledger transactions. (transactions are created for all outstanding day-end numbers up to and including the number you specify.)
  3. Click Process.

Post the batches in General Ledger (unless they are posted automatically).

If you use a different general ledger, do one of the following:

  • Import the CSV batch file into your general ledger, and then delete the original CSV file.
  • Using the G/L Transactions report, transfer the entries to your general ledger manually, and then delete the CSV batch file.