Skip to main content

Statement Substitution Table

Statement Substitution Table​

The substitution tables allow you to run reports using a single Financial Statement Table. If you have multiple companies or cost centers which share a common Chart of Accounts, you can format your Financial Statement Table for one cost center, and tell the computer to run the same statement substituting a different cost center(s) for the original.

This concept assumes that you use the same Statement Table format for any substitution that is done, whether company or cost center.

 For example, assume that you have five (5) cost centers:

 00 - Administration

 10 - Boat Sales

 20 - Ships Store

 30 - Storage

 40 - Service

You set up your Profit and Loss Statement assigning only the G/L accounts with the 00 - Administration cost center attached to statement lines. The Profit and Loss Statement format is shown below.

 Sales

 Cost of Sales

 ------------------

 Gross Profit

 Expenses

 ------------------

 Net Income

By using a Substitution Table, you can tell the system to run this statement for any combination of cost centers; 10 alone, 10 and 20, 20 and 40, etc. or consolidated (all cost centers). The system will print the statement extracting the values for only the accounts in the cost centers in the Substitution Table. This same concept holds true for multiple companies also.

From the menu select General Ledger, Maintenance Functions, Statement Substitution Table.

  1. Enter a Table ID or press F6 to list the existing tables. Note:DockMasterrecommends that you enter a separate Substitution Table for each company or cost center you report on. From our previous example, you would have five (5) substitution lists called 00, 10, 20, 30, and 40. Since there is only one company in our example, you need not make a list ID for the company.
  2. Enter a Description for this table. You should use your cost center or company name, since the description will print in the heading of the Financial Statement when run on an unconsolidated basis.
  3. Select the Method for G/L replacement for this table. The options are: Company, Cost Center, or Company-Cost Center.
  4. Click in the Value column to enter a value for this Substitution Table. This entry depends on the selection made at the Method prompt. If you selected Company, enter a company number; if you selected Cost Center, enter cost center numbers, and if you selected Company-Cost Center, enter a company number ‘-‘ cost center number. The system will display the description of your entry.
    • Press F6 to display a list of valid options. While in the F6 listing window, press F8 to select all Companies or Cost Centers. You may NOT use the F6 option for Company-Cost Center replacement.