How to change General Ledger integration options on Sage 300 Inventory Control


  1. Open Inventory Control > I/C Setup > G/L Integration.
  2. On the Integration tab, modify settings as needed.
    • You can change:
      • When I/C creates transactions for posting to the General Ledger.
      • You can choose to create transactions when I/C costs inventory items (this is set in the I/C Options screen) or using the Create G/L Batch screen.
        • 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.
      • Whether I/C adds new transactions to existing G/L batches or creates new batches (and, optionally, automatically posts the new batches).
      • Whether I/C consolidates G/L transactions to send less detail to the general ledger. (This choice can also limit drilldown from the general ledger.)
      • The codes attached to each transaction sent from Inventory Control.
      • 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.
        • Note: Any changes you make apply only to general ledger transactions created after the change, and do not affect existing general ledger batches.
  3. To change the information that appears with G/L transactions, use the table on the Transactions tab. The table lists the types of transactions Inventory Control creates, along with the information that is currently used for the entry description, detail description, detail reference, and comment fields in the G/L transactions created from these I/C transactions
    1. Select (highlight) the line for the information that you want to change, and then click Open, or double-click the line.
    2. On the G/L Integration Detail screen that appears, select information to add to or remove from the transaction field, and then click the Include or Exclude.
      • Note: You can assign one or more pieces of information (segments) to each G/L transaction field, provided that the combined length of the segments and separators does not exceed 60 characters. Fields exceeding this limit will be truncated when you post the general ledger transactions.
    3. Click Save to save the contents of the G/L transaction field.
    4. When you have finished, click Close to return to the Transaction tab.
  4. Click Save to save changes to the I/C G/L Integration screen.


If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.