Run Copy Tables

You can use this function to run copy tables, which copy values between the accounts you specified in the copy table within a company or a group.

All journal types, including reported values, will be copied. Only automatic journals of type BASE (blank) will be copied. If you select the option to clear before copying, existing values in target accounts for the current selections, will be overwritten.

Procedure

  1. On the Company menu, click Copy/Run Copy Table. The Copy - Run Copy Table window opens.
  2. In the Actuality and Period text boxes, enter the period and actuality for which you want to copy values.
  3. If you want to copy values for companies within a specific group, select the Group option button. In the Consolidation type and Group text boxes, enter the consolidation type and the group for which you want to copy values. Select the Include Subgroups check box to copy values for all subgroups within the specified group.
  4. If you want to copy values for one or several companies, select the Company option button and enter the company code(s) in the Company text box.
  5. In the Currency Type text box, enter the currency type for which you want to copy values.
  6. Select the Clear All Existing Target Accounts (According to Copy Table) for Current Selections Before Copying to delete any values in the target accounts, based on the copy table, before copying the values.
  7. Click Run. The values are copied according to the copy table.

Results

  • All journal types, including reported values, will always be copied.
  • Only the automatic journal type BASE (blank) will be copied.
  • Copying to an account of type A, L, E, I or C may cause differences in the active/passive reconciliation. Therefore, it is advisable to generate reconciliation reports after copying values.