Create G/L Batch form

Sage ERP Accpac Inventory Control 6.0

previous page next page

Create G/L Batch

Use this form to:

Create general ledger transactions from posted receipts, shipments, assemblies, internal usage transactions, adjustments, and transfers, if you do not create them during Day End Processing.

G/L Integration options and G/L batches

You use the Create G/L Batch form to create general ledger batches only if you did not choose the option Create G/L Transactions During Day End Processing on the Integration tab of the G/L Integration form.

G/L Integration options also let you:

Add new transactions to an existing G/L batch or create a new one (and optionally post it directly to G/L accounts).
Consolidate transactions during batch creation.
Select the information to appear in the Entry Description, Detail Description, and Detail Reference and Comment fields in general ledger transactions.

When you create the general ledger batch, the last day-end number processed is entered in the G/L Transactions Generated Through Day End Number field on the Integration tab of the Options form, as well as the next day-end number the program will assign.

Locked fiscal periods

Note that if a fiscal period is locked for General Ledger but not for Inventory Control, you can create batches for General Ledger during Day End Processing or using the Create G/L Batch icon (depending on Inventory Control's G/L Integration settings). When you try to post transactions to a locked period in General Ledger, however, the transactions will be placed in an error batch. You can avoid this situation if you create and post General Ledger batches for outstanding Inventory Control transactions before locking the period for General Ledger.

Before you start

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.
If you use Sage ERP Accpac General Ledger, print the G/L Transactions report, then file it with your audit trail reports.

Note: 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, created in the same directory as your company database.

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

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.

To create the general ledger batch:

Double-click the Create G/L Batch icon in the Periodic Processing folder.
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.)
Click Process.

After creating the general ledger batch:

Post the batches in Sage ERP 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.

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