Create G/L Batch

Sage ERP Accpac Inventory Control 6.0

Create G/L Batch

Overview

You use the Create G/L Batch form to create general ledger batches if you do not automatically create G/L transactions when you post transactions or when you run Day End Processing.

You can find out how you currently create G/L transactions by looking at the Create G/L Transactions option on the Integration tab of the G/L Integration form (in the I/C Setup folder).

Before you start

  • If you use Sage ERP Accpac General Ledger, print the G/L Transactions report, before using the Create G/L Batch form.

  • If you do not use Sage ERP Accpac General Ledger, or if your Sage ERP Accpac General Ledger system is at another location, Inventory Control appends its general ledger transactions to a file called icgltran.csv, which can be imported by a remote site Sage ERP Accpac General Ledger, or transferred to another general ledger that you use. The file is in a Comma Separated Values (CSV) format, and is created in the same directory as your company database.

Note that all general ledger transactions are placed in the same CSV file, and that each time Inventory Control creates transactions it asks whether to add to the file, or replace it.

Always add to a CSV file. If you overwrite it, you will destroy all transactions that are already in the file.

  • Select G/L batch creation and posting options on the Integration tab of the G/L Integration form.

  • Run Day End Processing to update the company's Inventory Control data.

  • 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.

  1. Specify the day-end number through which to create general ledger transactions. (You create the transactions for all outstanding day-end numbers up to and including the number you specify.)

  2. Click Process.

After using

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

If you use a different general ledger,

  • Import the CSV batch file into your general ledger, and then delete the original CSV file.

Or

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

Related topics