1. Home
  2. /
  3. Setup Guides
  4. /
  5. Financials
  6. /
  7. Loading data
  8. /
  9. General prerequisites

General prerequisites

Related topics

Before you continue, make sure that the following tables have been completed with the mandatory data during installation.

Mandatory data

The following tables are mandatory:

Table/File To do
Company table EU reporting inactive. See Setting up the EU Reporting functionality
Currency table At least the system currency must have been defined. The remaining currencies you need must be entered before you can maintain the Business partner file.

For DC1 Financials you should also define how many decimals to be used in the in-put and out-put fields. Other values set on currency level are:

  • values for A/R and A/P hidden discounts
  • minimum value for over-due interest invoicing
  • minimum value for reminders
  • invoice rounding rules

Note: Differences may appear between DC1 Distribution and DC1 Financials in the stock valuation if the Currency table is set up with different number of decimals for amount and cost respectively.
Country table At least the system country must have been defined. The remaining countries you need must be entered before you can maintain the Business partner file.

A number of values are set on country level. These are:

  • postal code to be printed left or right of city
  • necessary values for EU and VAT handling
  • calculation method and percentages for overdue interest invoicing

If the EU Reporting function is active, make sure you enter the program id for the EU VAT sales report (the standard program is FSC623), and the Intrastat declaration (the standard program is GCFC632).

Note: You must restart the company to work with by using option 88 on the menu, to reload the LDA, after having defined the system currency and system country.
Language table This table is already defined at system set-up, but you may need to change the codes for YES/NO and text strings etc. If the system language for your company is not part of the system set-up, you must also add it. The remaining languages you need must be entered before you can maintain the Business partner file.

Apart from the codes for YES/NO etc., the language table is where you define the date format and date separator, i.e. as follows:

/   –   ,   .
DC1 user profile table All users of the system shall exist in this table, but user SYSTEM is sufficient during implementation, since it is the default for all users without a user profile of their own. This default SYSTEM user must be activated to be able to use it to sign in. On the user profile entry option defaults and user specific sets of enquiries are defined.

The Language library can also be defined. When you log on to a company it replaces the fictitious entry *LANGBAS in the library list. If this is not entered, the system language library in Work with companies is used. (The language library of each additional language has to be loaded to the iSeries.)

In addition, the following information should be defined:

  • Allow change of accounting period
  • Group profile
  • Enquiry access via the function keys per template
  • Process jobs interactively

The template defaults and enquiry program defaults can be entered later, since they are not vital for the implementation.

Note: When all user profiles are added, it is recommended that you delete the user profile SYSTEM to prevent any user (without a user profile) from running the system.

Related topics