Fiscal years

Creating a new fiscal year

When a new fiscal year starts, follow the steps below:

  1. In your financial application, create a new database for every company.
  2. In the Financial module, navigate to the Financial databases form, and register the financial databases in Isah.
  3. Open the Financial module, navigate to the Reports and scripts folder, open the Additional basic data folder, and then open the Business code by database form.
  4. Link the financial databases for the new fiscal year to the relevant companies.

Note: On the Financial databases form, make sure that the active databases relate to only one fiscal year. The reason for this is that the import processes for open items retrieve the data from all active financial databases that are linked to the logistic database from which you are starting the process.

Exporting data to a different fiscal year

At the beginning of a new fiscal year, you may want to export journal entries from the previous fiscal year to the new fiscal year or vice versa. Multicompany assigns the database based on the date of the journal line, however, and will therefore not assign the correct fiscal year to the journal entry. In order to avoid this from happening, perform the steps below:

  1. Open the Financial module, navigate to the Reports and scripts folder, open the Additional basic data folder, and then open the Business code by database form.
  2. Use the Business code by database form to link the company, the fiscal year and the financial database.
  3. On the line for the old fiscal year, change the financial database into the database used for the new fiscal year. You may now have two lines for the same company with the same financial database, but with different fiscal years (see the example).
  4. In the Financial module, navigate to the Reports and scripts folder, open the Additional processes folder, and then start the Assign database code process.
  5. If desired, restore the data on the Business code by database form to their original values.

Example: Exporting data to a different fiscal year

Company code

Description

Fiscal year

Database

Financial database description

10

Production Inc.

2012

5

Production Inc. 2013

10

Production Inc.

2013

5

Production Inc. 2013

20

Domestic Sales Inc.

2012

6

Domestic Sales Inc. 2013

20

Domestic Sales Inc.

2013

6

Domestic Sales Inc. 2013

30

International Sales Inc.

2012

7

International Sales Inc. 2013

30

International Sales Inc.

2013

7

International Sales Inc. 2013

Note: On the Business code by database form, you need to change the settings before you start assigning database codes.