A/R G/L Integration Screen

Select whether or not to combine transaction details for the same general ledger account, and if so, which details are consolidated.

Important! If you consolidate transactions, you lose the ability to drill down to them from General Ledger.

You can select:

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

Note: If you change this selection, the new selection only applies to transactions posted after the change, and has no effect on transactions already in a general ledger batch.

Specify when to create general ledger transactions:

• During Posting. General ledger transactions are created during posting in Accounts Receivable.
• Manually Using A/R Create G/L Batch Screen.

Important! If you select During Posting, you cannot print the G/L Transactions report.

You can change this selection at any time. However, if Manually Using A/R Create G/L Batch Screen is selected, print a copy of the latest G/L Transactions report and create any outstanding transactions before you change this selection.

Select the method to use for creating general ledger transactions:

• Adding to an Existing Batch. Add new general ledger transactions to existing batches.
• Creating a New Batch. Produce a new general ledger batch each time you create general ledger transactions.
• Creating and Posting a New Batch. 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).

This table contains the following columns that are used to create the source codes:

• Transaction Type. The various types of transactions you can process in Accounts Receivable.
• Source Ledger. The two-character code indicating the source, which is always AR.
• Source Type. The two-character code indicating the type of transaction. You can change this code.

Note: The default source type for Payment Received is the same as for Payment Received Reversal. The default source type for Refund is the same as for Refund Reversal.

The source code for each transaction type is a combination of the source ledger code and the source type code. The source codes are used to identify transactions in General Ledger.

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

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

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

To edit the information, click the Edit icon to the right of the field you want to change, and then make the changes on the A/R G/L Integration Detail screen.

For each detail transaction type, this column displays 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: If you consolidate details during posting, the description is "CONSOL" for all the transactions in General Ledger.

To edit the information, click the Edit icon to the right of the field you want to change, and then make the changes on the A/R G/L Integration Detail screen.

For each detail transaction type, this column displays 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: If you consolidate details during posting, the reference is blank for all the transactions in General Ledger.

To edit the information, click the Edit icon to the right of the field you want to change, and then make the changes on the A/R G/L Integration Detail screen.

For each entry transaction type, this column displays 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, click the Edit icon to the right of the field you want to change, and then make the changes on the A/R G/L Integration Detail screen.

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

To edit the information, click the Edit icon to the right of the field you want to change, and then make the changes on the A/R G/L Integration Detail screen.