Multi-company

SET UP MULTI COMPANY ENVIRONMENT

The steps to set up a multi company environment are given below. The same steps can be followed when converting a single company to a multicompany environment.

ACTIONS OUTSIDE T24

The following must be agreed before setting up or changing to a multicompany environment

	- The digits of the account number to identify the company to which it belongs.
	- The Transaction Codes/Category Codes for Inter Company accounts and transactions.
	-How the Company group number and sequence number in the Company key are to be   used.
	- How the Company 'code' numbers in the Account Number are to be allocated for each company.
	- How the Sub division code for identifying each company is to be allocated.

ACTION  TO BE TAKEN WITHIN T24

	- Add to the applications for the existing company the application code MC.
	- Run the application CREATE.MASTER.COMP.BATCH. This will reverse out all the  old Batch records and create new records for the existing company with the company mnemonic at the front, except for the DATE.CHANGE record. This is because this Process must be run only once and will cater for all companies in the system at the time.
	- Input and authorise the record INTERCO on the ACCOUNT CLASS file. This record contains the category code for the Inter Company Accounts.
	- Ensure you are the only person on the system.
	- Input and authorise the record SYSTEM on the INTERCO.PARAMETER file, .
	- Sign off and on the system before proceeding further.

MAIN PROCESS FILES

INTERCO.PARAMETER FILE

The presence of this  file indicates a multi company accounting environment, and identifies  the unique part of the customer account number for each company.

This record must be input and authorised before creating the second company, but the INTERCO record must be present on the ACCOUNT.CLASS file prior to this.

				Key - SYSTEM
				- Indicates the presence of multi company accounting
				- Defines the unique Branch Identifier
					Length/Position/Codes of the unique account identifier
				- Indicates the length of the customer account
				- Defines the CR/DR Trn Codes for Interco Transactions.
				- LINKS to ACCOUNTS

COMPANY CONSOL FILE

This file holds the Group identifier and descriptions of Companies to be grouped together for combined CRF reports. The group number is part of the data entered at report production stage Each record is independent of the others and there is no hierarchical relationship between them.With regard to the exchange rates used at report production time. Special rates can be used or the standard rates from the currency file(s) can be used. therefore it is necessary to enter some default conditions.

				Key -999 UNIQUE ID
				- Indicates the COMPANY NAME for report headings
				- Defines the unique Branch Identifier
				- Defines the Code of Companies to be consolidated
				- Specifies the default Report CCY
				- Specifies the default Company CURRENCY Table
				- Specifies the default LCY
				- LINKS to RE.CONSOL.REQUEST

RE.RPT.CCY.RATE

If Special Currency Rates are required for Combined Reporting this file holds the rates to be used. The key to the file is currency followed by a ‘sequence’ number thus allowing more than one set of rates to be loaded per reporting currency. This allows for the cases where Head Office require a different rate from other branches.

When converting to the reporting currency, the ‘local’ currency amount field is the one converted not the foreign currency (original currency) field, meaning only rates between the reporting  currency and the local are loaded. Where one or more companies share the same local currency, then the exchange rate between the local and reporting currency will be shared by all.

				Key CCY.-999 CCY . UNIQUE ID
				- Defines the Quotation, Base, Exchange Rate/Report Rate
				- LINKS to RE.CONSOL.REQUEST

RE.CONSOL.REQUEST

This file holds details of requests for different consolidations of CRF reports. They may  be run as part of the end of day processsing in the Batch process called EB.CONSOL.PRINT or online using the V verification function for this application.

				Key . UNIQUE ID e.g DAILY, WEEKLY, MONTHLY
				- Identifies the Description and Language.
				- Specifies the level of reporting i.e. Detail, Summary, Both
				- Defines the CCY, and CONSOL.GROUP
				- Specifies the Exch Rate - SPECIAL, COMPANY, DEFAULT

DEFINITIONS

DEFAULT LCY/COMPANY/CURRENCY RATE TABLE

Details only need to be entered when there is more than one currency file for the same local currency. Suppose that company C and company D both have the Local currency as DEM and for specific reasons the exchange rates used in each company are different. Then either company C’s or D’s exchange rates must be used when creating a combined report  To achievethis  DEM must be entered in the record, and either company C or D associated with it.

MULTI COMPANY – SET UP NEW COMPANY

SET UP A NEW COMPANY

This section outlines the steps to be taken in setting up a new company.within a Multi Company environment

ACTIONS OUTSIDE T24

The following information about the new company must be obtained  before creating company record

	- The Company Number and Mnemonic. ii)
	- The Local Currency.
	- The Financil Year End.
	- The Sub division number.
	- The Level of the files to be shared or not shared.
	- The Applications to be run under the Company.
	- The Applications requiring Auto Id function.
	- Name and Address of the Company.
	- From other company records the type of rate and tolerance data to be loaded.
	- From other company records the account number  check digit type and format.

CREATION OF THE COMPANY RECORD

	- Ensure you are the only user on the system.
	- If necessary create new record on the COMPANY.GROUP file if the company number contains a
	   new group number.
	Run application COMPANY.INS.
	This runs the creation of a Company record using a special run through the Company application with zero authorisers.
	This routine will  
	Create all the required files.
	Set up the Batch records on the Unauthorised file. 
	Will copy to the Unauthorised file in IHLD condition the records/files requested on the FILE.SETUP.DETAIL file. Check the FILE.SETUP.DETAIL so that the requiredfiles are copied.

AFTER CREATION OF THE COMPANY RECORD.

The following steps are to be performed before letting other users back onto the system.

	- Modify USER records so that access to the New Company is allowed.
	- Input and Authorise the DATES record for the new company. On this record the Run Date and
	  Next Working Day date must be the same as on the first company created. 
	- Create an Abbreviation for changing to New Company.
	- Update the Interco.Parameter file SYSTEM record.
	- The above is done before signing onto the New Company. It will be necessary to sign off and on
	  again to obtain use of the modified details to the USER and INTERCO.PARAMETER files

	- Input and Authorise Data on the following files (this list assumes shared Customer and Nostro
	  Files) if files have been created for New Company.   For these files data will have been written to
	  the Unauthorised file. in HLD status

FILE NAME

	CLASIFICATION	NOTES

CURRENCY

	CCY	Only set for New Local Currency

TRANSACTION

	FTF	Only set for New Local Currency

TAX

	FTF

FT.CHARGE.TYPE

	FTF

FT.COMMISSION.TYPE

	FTF

FT.TXN.TYPE.CONDITION

	FTF

FT.GROUP.CONDITION

ACCOUNT.ACCRUAL

	INT	One record with key of Company Code

GENERAL.CHARGE

	FTF

FX.TEXT

LMM.CHARGE.CONDITION

LMM.INSTALL.CONDS

	FIN	One record

LMM.TEXT

	Input and Authorise Data on the following files (this list assumes shared Customer and Nostro
	Files) if files have been created for New Company.   For these files data must be entered

FILE NAME

	CLASIFICATION	NOTES

PERIODIC.INTEREST

	CCY	Only when New Local Currency

FORWARD.RATES

	CCY	Only when New Local Currency

GROUP.CAPITALISATION

GROUP.DEBIT.INT

GROUP.CREDIT.INT

Other Interest and Charges tables

ACCOUNT

Default accounts in the Local currency for  the suspense accounts etc.

DE.ADDRESS

		Create record for new company

DE.PRODUCT

		Create record for new company

Check Parameter files for all installed applications. Many may need a need a new record for the new company

 e.g.

FD.PARAMETER

FRA.PARAMETER

MD.PARAMETER

MG.PARAMETER

	Input and authorise the records on the Batch file that have been created above.

	Run AUTO.ID.START for appropriate applications.

	Run INSTALL.SYS.RECS for new company.	Check printed output to ensure that there are no 
	missing records.