How to Create a Process ID in Sage 300 G/L Consolidations


  1.  Open General Ledger > G/L Consolidations > G/L Consol. Setup > Export Setup.
  2. Enter a code of up to eight characters to describe the export process, and enter a description for the process in the field to the right.
  3. Use the Main tab to specify the unit ID of the source company from which you are exporting data, and to select data to be exported.
    1. Enter a Unit ID of up to four characters that identifies the source company when the data is imported into the destination company.
    2. Select a unit balancing account that will be used in situations where exported data is not balanced. For more information, see “About Consolidating Transactions” (page 9).
    3. In the Data area, select the type or types of data to export.
    4. If you want to be able to clear data selections on the G/L Consol Export screen later, select the Allow Runtime Edit option.
  4. If you selected Transactions in the Data section on the Main tab, use the Transactions tab to select options specific to transactions.
    1. Select an export method (net changes, balances, transactions by posting sequence, or transactions by fiscal period).
    2. If you use Transaction Analysis and Optional Field Creator and you selected Transactions By Fiscal Period or Transactions By Posting Sequence, select the Transaction Opt. Fields option so that optional fields attached to the transactions will be included in the export.
    3. Select the transaction source ledger to use for each imported journal entry.
    4. Select the default source code.
    5. If you want to limit the number of transaction details per general ledger entry, enter the number of transactions and specify the transaction balancing account that will receive balancing details.
    6. If you selected Transactions By Posting Sequence or Transactions By Fiscal Period as the export method and you are converting source codes, use the Source Code Conversions table to specify how source codes are converted during export.
  5. If you selected Budgets on the Main tab, use the Criteria tab to specify the budgets to be exported.
    1. If you want to restrict export data to accounts that have a particular segment in the account number, or to a particular range of values associated with that segment, select the Specify Segment Code for Export option, and specify a range of segment number values to include.
      • Note: If you select Specify Segment Code for Export, you must also select a balancing account on the Main tab. For more information, see “About Specifying Account Segments for Export” (page 5).
    2. If you selected budgets for export on the Main tab, select the budget sets (1 to 5) for exporting, and select the fiscal year containing the budget sets to be exported.  If you are using a mapping table to consolidate accounts (in other words, if you are merging many source ledger accounts into one destination ledger account), select the Consolidate option to consolidate the budgets for all of the source accounts that are
      being merged.
      • If you select Consolidate, the relevant budget amounts will also be consolidated according to the mapping table.
      • If you do not select Consolidate, only the budget for the last merged source ledger accounts will appear in the destination accounts.
  6. If the destination company is multicurrency, use the Currency tab to set up multicurrency options.
    1. If the destination company is multicurrency, select Multicurrency Destination Company.
    2. If the source and destination companies use the same functional currency, specify the default rate type.
    3. If the source and destination companies do not use the same functional currency, set up currency translation.
      1. Select the Translate to Different Functional Currency option.
      2. Enter the currency code for the destination company’s functional currency.
      3. Specify the default rate type for transactions and budgets.
      4. In the Translation Rate Date area, specify how exchange rates will be applied.
        • Fiscal Period. The program will base the exchange rates on the last day of the source (exporting) company’s fiscal period when the transaction occurred.
          • Note: The fiscal period used for the exchange rates is not affected by the offset.
        • Transaction Date. This option is available only if detailed transactions are being exported (instead of balances or net changes).  The exchange rate will be based on the rate in effect on the actual dates of the original transactions in the source (exporting) company.  
        • Specified. If you select this option, you will be required to enter a rate date at the time of export.
      5. Specify currency translation accounts for gain and loss.
  7. Use the Mapping tab to specify whether or not a mapping table is used for the export process, and to map General Ledger account segments.  For more information about mapping tables, see “G/L Consol. Mapping Table” (page 73).  If you will use a mapping table for this process:
    1. Select the Use Mapping Table option.
    2. Select a mapping table. For information about setting up, see “Setting Up a Mapping Table” (page 22).
    3. Specify a mapping method to use.
    4. If you selected Segment Codes on the Main tab, use the Segment Number Substitution table to select a source segment number and map it to a target segment number.
  8. Click Add to add the new export process.