O/E G/L Integration Screen

On the Transactions tab, click Open to open the O/E G/L Integration Detail screen. You use this screen to specify the information that will appear in fields in General Ledger transactions that are created from invoices, shipments, credit notes, and debit notes.

For more information, see O/E G/L Integration Detail 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 Posting. Depending on when you create subledger transactions in Inventory Control, you can select this option to create General Ledger transactions during posting.

  Warning! This selection can have a significant impact on the speed of processing inventory transactions and transactions in Order Entry. If you want to speed up order processing, switch to creating transactions when you run Day End 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 Icon. 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 Posting or 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 database as Sage 300 General Ledger.

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

If you do not use Sage 300 General Ledger, or if your Sage 300 General Ledger system is at another location, Order Entry appends its general ledger transactions to a file called oegltran.csv, which can be imported by a Sage 300 General Ledger at another site, or transferred to another general ledger that you use. The file is in Comma Separated Values (CSV) format, and is created in the same directory as your company database.

If you do not use Sage 300 General Ledger in the same database as Order Entry, all general ledger transactions are placed in the same CSV file. Each time Order Entry creates transactions, a message asks whether you want to add transactions to the existing file or replace it.

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 Open button 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 Open button 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 Open button 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 Open button to open the O/E G/L Integration Details screen.