O/E G/L Integration Screen

Click Save to save changes you have made to the screen.

Specify whether Order Entry consolidates transaction details for the same General Ledger account into a single detail, or whether it posts unconsolidated transaction details to General Ledger.

Consolidation reduces the amount of information in the general ledger batch and results in a shorter list when you print the G/L Transactions Listing report, but also reduces information and prevents drilldown from General Ledger.

For more information, see General Ledger Integration Options.

Specify when to create General Ledger transactions.

Important! The option you select here can prevent you from printing the O/E G/L Transactions report or consolidating Order Entry transactions, and can also have a significant impact on system performance during transaction processing.

• During Day End Processing. Depending on when you create subledger transactions in Inventory Control, you can select this option to create General Ledger transactions when you run Day End Processing in Inventory Control.

  Note: If you select this option, you cannot print the O/E G/L Transactions, and you cannot consolidate Order Entry transactions that are posted to General Ledger.

• On Request Using Create Batch Screen. Select this option if you want to create General Ledger transactions manually using the O/E Create Batch screen.

  If you prefer to create General Ledger transactions automatically each time you post Order Entry transactions or each time you run Day End processing in Inventory Control, select During Day End Processing for the Create G/L Transactions option.

  Important! You must select this option if you want to print the O/E G/L Transactions Report, or if you want to consolidate transactions in Order Entry.

For more information, see General Ledger Integration Options.

Specify whether to add new General Ledger transactions to an existing batch, to a new batch, or to a new batch that Order Entry posts automatically to General Ledger.

To have all transactions appended to a single General Ledger batch, select the Adding to an Existing Batch option. Order Entry must use the same company as Sage 300 General Ledger.

Note: Remember to create and post all General Ledger batches for outstanding transactions before locking periods for General Ledger.

This field displays the last day end number for which General Ledger transactions have been created.

This field displays the type of information that will appear with unconsolidated details in the Comment column on the O/E G/L Transactions report, on the G/L Journal Entry screen, and on other reports in General Ledger.

To select and arrange the Order Entry information that will appear in these fields, and to specify a separator (such as a hyphen) that appears between this information, select a detail line and click the Edit icon to open the O/E G/L Integration Details screen.

This field displays the type of information that will appear with unconsolidated details in the Description column on the G/L Transactions report and in that field in the general ledger batch. (The Detail Description field is the description on each detail line, not the main description for the General Ledger transaction.)

To select and arrange the Order Entry information that will appear in these fields, and to specify a separator (such as a hyphen) that appears between this information, select a detail line and click the Edit icon to open the O/E G/L Integration Details screen.

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

To select and arrange the Order Entry information that will appear in these fields, and to specify a separator (such as a hyphen) that appears between this information, select a detail line and click the Edit icon to open the O/E G/L Integration Details screen.

This field displays the type of information that will appear in the Description field for a General Ledger transaction (not in the description for a detail line).

To select and arrange the Order Entry information that will appear in these fields, and to specify a separator (such as a hyphen) that appears between this information, select a detail line and click the Edit icon to open the O/E G/L Integration Details screen.

This column lists transaction types generated by Order Entry, such as invoices, adjustments, and consolidated G/L entries.

To select and arrange the Order Entry information that will appear in these fields, and to specify a separator (such as a hyphen) that appears between this information, select a detail line and click the Edit icon to open the O/E G/L Integration Details screen.