Changing I/C General Ledger Integration Options

Learn more

Changing Inventory Control Processing Options

Changing Posting and Day End Processing Options

I/C G/L Integration Screen

Setting Up Inventory Control

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 your Sage 300 database.

ClosedBefore you start
  • Make sure that no one else is using Inventory Control data.
  • Become familiar with the G/L integration options you want to change. For more information, see I/C G/L Integration Screen.
  • If you plan to change the setting for Create G/L Transactions from Manually Using I/C Create G/L Batch Screen, print a copy of the latest G/L Transactions report and create any outstanding transactions (using the I/C Create G/L Batch screen) before changing the selection, 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.

    1. You can change options that determine how and when to process general ledger batches as well as whether to consolidate the batches.
    2. You can change the code indicating the type of transaction in the Source Type column.
    3. Click Save.

    Note: Any changes you make apply only to general ledger transactions created after the change, and do not affect existing general ledger batches.

  3. On the Transactions tab, make changes as needed to change the information that is included with general ledger transactions posted from Inventory Control:

    1. Click the Edit icon to the right of the field you want to change, which opens the G/L Integration Detail screen.
    2. Make your changes to the segments or segment separator. More...
      • In the Segment Separator field, you can change the character used to separate segments of information.

        Note: The separator is used only if you assign more than one segment.

      • To add a segment, choose it in the Choose Segments From List list, and then click Include. The selected segment moves to the Segments Currently Used list and appears in the Example.
        Notes:
        • You can assign a maximum of five segments to a G/L field.
        • If the combined length of the segments and separators exceeds 60 characters, the assigned information is truncated when the transaction is posted.
        • The available segments depend on the transaction type.
      • To remove a segment, choose it in the Segments Currently Used list, and then click Exclude. The selected segment is removed from the Segments Currently Used list and from the Example.
    3. Click Save.
    4. If you want to make other changes to the fields for that transaction type, select the G/L Transaction Field, and then repeat steps 3b and 3c.
    5. If you want to make other changes to the fields for another transaction type, select the Transaction Type, select the G/L Transaction Field, and then repeat steps 3b-3d.
    6. When you finish making changes,close the G/L Integration Detail screen and return to the I/C G/L Integration screen.

Published: September 11, 2020
© 2020 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks