Setting Up Intercompany Transactions

Set up Intercompany Transactions to create and distribute transactions across multiple companies.

Note: You do not activate ICT in intermediate or destination companies—only in the company originating transactions (that is, in the "originator").

  1. Create a company database (the ICT company) that will be used only for originating intercompany transactions. For more information about creating company databases, see the Sage 300 Installation and Administration Guide.

  2. In this company, activate the following programs:

    • Intercompany Transactions
    • System Manager
    • General Ledger

  3. If you use Accounts Payable in a remote company, or if you will be creating A/P transactions in the ICT company, activate the following programs in the ICT company:

    • Accounts Payable
    • Tax Services
  4. If you use Project and Job Costing in a remote company, activate Project and Job Costing in the ICT company.

To set up ICT:

  1. Open Intercompany Transactions > ICT Setup > Options.
  2. If the ICT company is a multicurrency company, a multicurrency option appears beside the Functional Currency field. To allow multicurrency transactions between companies, select this option, and then click Save.

    Important! As elsewhere in Sage 300, once you select the multicurrency option and save it, you cannot change it.

    • After selecting the multicurrency option, you must click Save before inserting companies.
    • When you select multicurrency, the functional currency of ICT A/P and ICT G/L transactions is determined by the originator.
    • When you select multicurrency, the source currency of ICT A/P transactions is determined by the vendor's currency (as in A/P).

    • The source currency of a G/L transaction entry created in originating, intermediate, and destination companies is the functional currency of the ICT G/L transaction entry from which it came, if either of the following is true:

      • The originating, intermediate, or destination company is single currency.
      • The route level setting is No for the Keep Source Currency option.

      Otherwise, the source currency is the same as in the ICT G/L line.

  3. Click the Update Company Information button.

    Companies become available for selection in the Company column of the table.

  4. Enter posting and account information for each company for which you will be entering transactions. More...
    1. In the Company column of the table, click the Finder , and then select a company.
      • The Finder displays companies that use the same system database as the ICT company. These companies must have the same versions of the same programs activated as those in the ICT company (for example, G/L). Companies that use other system databases do not appear in the Finder.
      • If no companies appear in the Finder, or if the Finder does not open, click the Update Company Information button again. If the Finder still does not open, check that the remote companies you want to use for transactions are using the same system database as the ICT company, and that their programs have been activated.

      After you select a company, the company name, status (active or inactive), and functional currency appear in the table.

    2. Specify whether to post G/L and A/P batches for the company.
    3. Select an A/P Clearing Account for the company. (This cannot be a control account for a subledger and must be a multicurrency account for all currencies when multicurrency is on.)

      Note: ICT Invoice Posting uses the A/P Clearing Account. After you select the account, users do not need to specify it each time they post.

  5. Click Save, and then close the screen.
  6. Add routes. For instructions, see Adding Routes.
  7. If you will post expense-separately taxes to separate G/L accounts in the destination company for each tax authority, add tax accounts. For instructions, see Adding Tax Accounts.
  8. If you need to define standard groups of distributions to general ledger accounts in destination companies that you use when entering vendor transactions, add distribution sets. For instructions, see Adding Distribution Sets.

If you change G/L account information for any of the companies you have set up, open the ICT Options screen and click the Update Accounts button.