Use this option on the G/L Integration tab of the G/L Integration form to specify whether to combine transaction details for the same general ledger account into single details, or to send every Accounts Payable transaction detail to General Ledger.

Note that if you consolidate transactions, you lose the ability to drill down to them from General Ledger.

You can choose:

• Do Not Consolidate. All the details posted in Accounts Payable will be included in the General Ledger transaction batch. You maintain the ability to drill down to the transactions from General Ledger.
• Consolidate by Posting Sequence, Account and Fiscal Period. All the details with the same posting sequence, account number and fiscal period are combined into one detail. You will not be able to drill down to the transactions from General Ledger.
• Consolidate by Posting Sequence, Account, Fiscal Period, and Source. All the details with the same posting sequence, account number, fiscal period, and source code are combined into one detail. You will not be able to drill down to the transactions from General Ledger.

This option applies only if you use Sage ERP Accpac General Ledger with Accounts Payable.

You can create transactions by:

• Adding to an Existing Batch.  Choose this option if you want to add new general ledger transactions to existing batches.
• Creating a New Batch.  Choose this option if you want to produce a new general ledger batch each time you create general ledger transactions.

• Creating and Posting a New Batch.  Choose this option if you want to create and automatically post a new general batch when you create general ledger transactions.

Note that if you try to post a G/L batch to a period that is locked for General Ledger, the transactions will be placed in an error batch. Therefore, make it a practice to create and post General Ledger batches for outstanding Accounts Payable transactions before locking a period for General Ledger.

Accounts Payable automatically creates separate general ledger batches for the different types of transactions you can post (invoices, payments, adjustments) and for revaluation transactions (if you use multicurrency accounting).

If you do not use Sage ERP Accpac General Ledger, all general ledger transactions are added to the same general ledger batch, regardless of the type of transaction and your choice for this option. You are asked to whether to add the transactions to the existing batch or overwrite the batch. Always choose to add to an existing batch.

Use this option to specify when to create general ledger transactions.

You can create transactions for the general ledger when you post Accounts Payable batches, or you can create a batch of general ledger transactions using the Create G/L Batch icon.

You can change your selection at any time. If you have been using the Create G/L Batch icon to create the transactions, before you change the option, be sure to print a copy of the latest G/L Transactions report, then create any outstanding transactions.

If you use the option to create the batch during posting in Accounts Payable, you cannot print the G/L Transactions report.

Use the Source Type fields in this section to define the source code for each type of Accounts Payable transaction, if you prefer not to use the default source codes.

The source code is a combination of the source ledger code (AP, which you cannot change) and the source type code, which you can specify for all the different types of transactions you can process in Accounts Payable, including revaluation.

The source codes are used to identify transactions in General Ledger.

Note that the default source code for payments is the same as for payment reversals.

This box lists the posting sequence number of each type of transaction batch for which general ledger transactions have been created.

You use this information when you use the On Request Using Create G/L Batch Icon for the Create G/L Transactions option, to find out whether you have created all outstanding general ledger transactions.

 If general ledger transactions are up to date, the posting sequence numbers in this box are the same as the posting sequence numbers for each batch type on the Integration tab of the G/L Integration form.

This field displays, for each detail transaction type, the comment information that will appear with unconsolidated details on the G/L Transactions report and in the general ledger batch.

To include different information as the comment for a selected transaction type, click the Open button, or double-click the Comment field you want to change, then enter the information on the G/L Integration Detail form that appears.

This field displays, for each detail transaction type, the information that will appear with unconsolidated details in the Description column on the G/L Transactions report and in the Description field in the general ledger batch.

Note that if you consolidate details during posting, the description is "CONSOL" for all the transactions in General Ledger.

To edit the information for a selected transaction type, click the Open button, or double-click the field you want to change, then enter the information on the G/L Integration Detail form that appears.

This field displays, for each detail transaction type, the information that will appear with unconsolidated details in the Reference column on the G/L Transactions report and in the Reference field in the general ledger batch.

Note that if you consolidate details during posting, the reference is blank for all the transactions in General Ledger.

To edit the information for a selected transaction type, click the Open button, or double-click the field you want to change, then enter the information on the G/L Integration Detail form that appears.

This field displays, for each entry transaction type, the information that will appear as the entry description on the G/L Transactions report and in the general ledger batch.

To edit the information for a selected transaction type, click the Open button, or double-click the field you want to change, then enter the information on the G/L Integration Detail form that appears.

This column shows the transaction types for which you can assign information for G/L transactions.

To edit the information for a selected transaction type, click the Open button, or double-click the field you want to change, then enter the information on the G/L Integration Detail form that appears.

To open the Integration Detail form, on the Transactions tab, select a transaction type, then click Open.

The following fields appear:

Choose Segments From List

Example

G/L Transaction Field

Segment Separator

Segments Currently Used

Transaction Type