Changing I/C General Ledger Integration Options

You use the I/C G/L Integration screen to select options and settings that determine how your Inventory Control ledger interacts with your general ledger.

Important! Make sure that no one else is using the Inventory Control data and that no other Inventory Control screens are open for the company before you save changes to the G/L Integration screen. You cannot change I/C G/L integration settings if other Inventory Control screens are open, or if other users are working with the Inventory Control database.

  • Print the G/L Integration report from the Setup Reports folder so you have a record of your G/L Integration settings before you start.
  • If you want to change from using the Create G/L Batch screen to produce your general ledger transactions to creating them during day-end processing, be sure to run Create G/L Batch to process any outstanding transactions first, to avoid accidentally omitting transactions from your general ledger batches.

To change G/L integration options:

  1. Open Inventory Control > I/C Setup > G/L Integration.

  2. On the Integration tab, modify settings as needed. More...

    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. More...

    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.

Print the G/L Integration report from the Setup Reports folder to check that the settings were changed correctly.