O/E Create Batch Screen

Open Order Entry > Periodic Processing  > Create Batch.

Select this option and specify the day-end number up to which to create a batch of General Ledger transactions from posted shipments.

Select this option to post a batch of invoices in Accounts Receivable from invoices or credit/debit notes posted in Order Entry.

Overview

Use the Create Batch screen to:

  • Create a batch of General Ledger transactions from posted shipments (or append transactions to an existing General Ledger batch) and optionally post them automatically. You can use this screen to create General Ledger batches only if you selected On Request Using Create G/L Batch Icon for the Create G/L Transactions option on the Integration tab of the O/E G/L Integration screen.
  • Post a batch of invoices in Accounts Receivable from invoices or credit/debit notes posted in Order Entry. You can use this screen to post Accounts Receivable invoices created by Order Entry only if you selected On Request Using Create Batch Icon for the Post A/R Batches option on the Processing tab of the O/E Options screen.

Posting to Locked Fiscal Periods

If a fiscal period is locked for General Ledger but not for Order Entry, you can create batches for General Ledger as follows:

  • During posting.
  • During Day End Processing.
  • Using the G/L Batch screen (depending on the options you select on the O/E G/L Integration screen).

If you try to post transactions to a locked period in General Ledger, transactions will be added to an error batch. To prevent this from happening, create and post General Ledger batches for outstanding Order Entry transactions before locking the period for General Ledger.

Similarly, you can create transactions for Accounts Receivable from Order Entry transactions, but you cannot post them to a period that is locked for Accounts Receivable.

Appending General Ledger Transactions to a CSV File

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.