Change General Ledger Integration Options

Sage ERP Accpac Inventory Control 6.0

Change General Ledger Integration Options

Overview

You cannot change settings on the Integration tab of the G/L Integration form if other Inventory Control forms are open, or other users are working with the Inventory Control database.

Make sure that no one else is using the Inventory Control data and that no other Inventory Control forms are open for the company before you save changes to the G/L Integration form.

Before you start

Print the G/L Integration report from the Setup Reports folder so you have a record of your G/L Integration settings before you start.
If you want to change from using the Create G/L Batch form to produce your general ledger transactions to creating them during day-end processing, be sure to run Create G/L Batch to process any outstanding transactions first, to avoid accidentally omitting transactions from your general ledger batches.

To change General Ledger integration options:

Open Inventory Control > I/C Setup > G/L Integration.

Click here for help on all G/L Integration fields.

The Integration tab lets you change:

When I/C creates transactions for posting to the General Ledger.

You can choose to create transactions when I/C costs inventory items (this is set in the I/C Options form) or using the Create G/L Batch form.

Note: This choice can have a large impact on the speed of processing inventory transactions and transactions in Order Entry. If you are costing inventory during posting, you may want to create transactions at a later date.

Whether I/C adds new transactions to existing G/L batches or creates new batches (and, optionally, automatically posts the new batches).
Whether I/C consolidates G/L transactions to send less detail to the general ledger. (This choice can also limit drilldown from the general ledger.)
The codes attached to each transaction sent from Inventory Control.

New source codes are automatically added to G/L, but you will have to update G/L source journal profiles to include transactions on source journals.

Any changes you make will apply only to general ledger transactions created after the change, and will not affect existing general ledger batches.

Click the Transaction tab to change the information that appears with G/L transactions for the Entry Description, Detail Description, Detail Reference, and Comment fields.

The Entry grid lists each of the transactions produced by Inventory Control, and displays the information that is currently included in G/L transactions produced from these I/C transactions.

Double-click the transaction description or transaction detail information that you want to change.
On the form that appears, highlight the information that you want to add to the transaction field, and use the Include and Exclude buttons to add or remove field information.

You can assign one or more pieces of information (segments) to each G/L transaction field, provided that the combined length of the segments and separators does not exceed 60 characters. Fields exceeding this limit will be truncated when you post the general ledger transactions.

Click Save to save the contents of the G/L transaction field.
Choose a different field to edit, or click Close to return to the Transaction tab.

Click Save to save changes to the G/L Integration form.

After changing G/L Integration Options

Print the G/L Integration report from the Setup Reports folder to check that the settings were changed correctly.