About Creating G/L Transactions

Use one of the following Create G/L Transactions options (on the Integration tab of the G/L Integration screen) to specify when to create general ledger transactions:

  • During Posting or During Day End Processing. This option lets you create general ledger transactions during posting or when you run day end processing—depending on your settings on the Costing tab of the I/C Options screen. More...

    You choose when to create G/L transactions and audit information on the Costing tab of the I/C Options screen. The Create Subledger Transactions And Audit Info. During option gives you one of two choices on this screen:

    • During Posting (available only if you cost items during posting)

      G/L transactions will be created when transactions are posted.

    • During Day End Processing

      G/L transactions will be created when you run the Day End Processing task.

    Note: These choices can have a large impact on the speed of processing transactions in Inventory Control, Order Entry, and Purchase Orders. If you need to speed up order processing, switch to costing inventory when you run Day End Processing (in I/C Options), and create G/L transactions using the Create G/L Batch icon.

    Note: This option changes depending on the options you chose on the Costing tab of the I/C Options screen.

  • On Request Using Create G/L Batch Icon. This option lets you create general ledger transactions at any time that's convenient for you. More...

    Once you create the transactions, you cannot print the G/L Transactions report in Inventory Control. If you wish to print the report, select the On Request Using G/L Batch Icon for this option. You must then print the report before you use the Create G/L Batch screen to create the transactions.

    You can change your selection any time. If you were using the Create G/L Batch screen to create the transactions, print a copy of the latest G/L Transactions report, then create any outstanding transactions before changing your choice for the option.

You can also choose whether to add new general ledger transactions to new batches or create new batches and optionally post them automatically to the general ledger.

You can:

  • Add general ledger transactions to an existing Sage 300 General Ledger batch.
  • Create a new General Ledger batch each time you generate G/L transactions.
  • Create a new General Ledger batch each time you generate G/L transactions, and automatically post the batch in the General Ledger program.

Note: If you are using Serialized Inventory and Lot Tracking, you cannot use this option to create and automatically post G/L batches during I/C transaction posting.

If you want to post batches automatically, you should choose the option to create subledger batches during day end processing (on the I/C Options screen).

Tip: Remember to create and post G/L batches for outstanding transactions before locking periods for General Ledger.

To have only one General Ledger batch to which all transactions are appended, turn on the Append G/L Transactions To Existing Batch option. Inventory Control must use the same database as Sage 300 General Ledger.

If you do not use Sage 300 General Ledger—or if your Sage 300 General Ledger system is at another location—Inventory Control appends its general ledger transactions to a file in your company’s data directory called icgltran.csv, which can be imported by a remote site Sage 300 General Ledger, or transferred to another general ledger that you use. The file is in a Comma Separated Values (CSV) format.