Specify whether to combine transaction details for the same general ledger account into a single detail, or to send unconsolidated transaction details to General Ledger:
- Do Not Consolidate. If you select this option, separate details are kept for each bank transaction
Tip: During bank setup, select this option so that you have a detailed record of the setup entries.
- Consolidate by Account and Fiscal Period. If you select this option, all transaction details with the same account number and fiscal period are combined into one detail. For example, all service charges, interest income, and other transactions entered in Bank Services within a given fiscal period are consolidated to show a total amount for each General Ledger account.
- Consolidate by Account, Fiscal Period, and Source. If you select this option, all transaction details with the same account number, fiscal period, and source code are combined into one detail.
Note: The posting date for consolidated entries is the last date of the fiscal period.
Specify when to create general ledger transactions in Bank Services:
-
During Posting. If you select this option:
- General ledger transactions are created automatically when you post a bank reconciliation.
- You cannot print the Bank G/L Transactions report. However, you can print a record of the transactions by printing the Batch Listing report in General Ledger.
-
On Request Using Create G/L Batch Icon. If you select this option:
- You create general ledger batches using the Create G/L Batch icon, after posting a bank reconciliation.
- You can print the Bank G/L Transactions report.
Tip: When you are setting up your system, select this option so that you can set up all your banks before sending information to General Ledger.
Specify how new transactions are added to G/L batches:
- Creating a New Batch. If you select this option, a new G/L batch is created each time you post a reconciliation.
- Adding to an Existing Batch. If you select this option and there is an unposted G/L batch, G/L transactions are added to the existing G/L batch.
- Creating and Posting a New Batch. If you select this option, a new G/L batch is created and posted immediately.
Use this tab to assign information to G/L transactions. For more information, see .
Overview
You use the I/C G/L Integration screen to select options and settings that determine how your Inventory Control ledger interacts with your general ledger.
Integration Tab
Use this tab to:
-
Specify whether to add general ledger transactions to the G/L batch during posting or each time you run Day End Processing, or to create the transactions at a later date.
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.
- Choose whether to create a separate G/L batch each time you create the G/L batch (and optionally automatically post the batch) or add new transactions to the existing batch. (This option applies only if you use Sage 300 General Ledger with Inventory Control at the same location.)
- Choose whether to consolidate the G/L batch when you post, or always enter full transaction details in the batch.
- Assign different source codes to general ledger transactions created by Inventory Control and added to G/L batches. (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.)
- Select the information to appear in the Entry Description, Detail Description, and Detail Reference and Comment fields in G/L transactions. (This information appears for transactions in the G/L Transactions report.)
- Look up the last Day End Number for which you have created general ledger batches.
Transactions Tab
Use this tab to:
- Select the information to appear in the Entry Description, Detail Description, and Detail Reference and Comment columns on the Inventory Control G/L Transactions report and in the corresponding fields in the general ledger batch.
- Look up the last Day End Number for which you have created general ledger batches.