A/R G/L Integration Screen

Use this option to specify whether to combine transaction details for the same general ledger account into single details, or to send every Accounts Receivable transaction detail to General Ledger.

Important! 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 Receivable are 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. The posting date for consolidated entries is the last date of the fiscal period.

  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. The posting date for consolidated entries is the last date of the fiscal period.

  You will not be able to drill down to the transactions from General Ledger.

This option applies only if you use Sage 300 General Ledger with Accounts Receivable.

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 ledger batch when you create general ledger transactions.

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

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

If you do not use Sage 300 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 Receivable batches, or you can create a batch of general ledger transactions using the A/R Create G/L Batch icon.

You can change your selection at any time.

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

If you have been using the A/R Create G/L Batch icon to create the transactions, be sure to print a copy of the latest G/L Transactions report, and then create any outstanding transactions before you change this option.

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

The source code is a combination of the source ledger code (AR, 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 Receivable, including revaluation.

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

Note: The default source code for receipts is the same as for receipt reversals. Refunds use the same default source code as refund reversals.

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

You use this information when you use 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 field are the same as the posting sequence numbers for each batch type on the Integration tab of the A/R G/L Integration screen.

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 screen that appears.

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

Note: If 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, and then enter the information on the G/L Integration Detail screen that appears.

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

Note: 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, and then enter the information on the G/L Integration Detail screen 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, and then enter the information on the G/L Integration Detail screen that appears.

This column shows the transaction types for which you can assign information for general ledger transactions.

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