Companies
Use this function to set up a company or companies. A company can be a division, a branch, or a site. A company can have 1 or a multiple sites.
After creating a company, you can use the Site/company groupings (GESAFG) function to link sites to this company. If the company you created is not the main company with an accounting structure, you need to add the site to a group linked to the main company.
Prerequisites
Refer to Implementation documentation
Screen management
Header
On this tab you can define a unique company code, name, and short description.
Company (field CPY) |
Enter or select the company code. |
field CPYNAM |
This the company or trade name that displays on external documents. It can contain up to 35 characters. |
Short description (field CPYSHO) |
The short description is used internally for easier identification. |
General tab
On this tab, you can enter information such as the capital or currency, legislation, country, and so on. You can also upload a logo image to be used in reports.
General
Legal company (field CPYLEGFLG) |
Select this option if the company has an accounting system linked to it. The default value is Yes. You cannot change this value after your save the record. |
Legislation (field LEG) |
This field displays the legislation code for the country, for example FRA for French legislation. This code determines certain rules and parameters necessary to fulfill country-specific legal requirements. It can include calculation rules, legal reports, legal declarations, tax management, and so on. Legislations are defined in Miscellaneous table 909. General parameters can also be defined at the legislation level. |
Legal form (field CPYLOG) |
Used to define the legal form under which the enterprise is established. |
Information
Registered capital (field RGCCUR) |
Enter or select the currency for this company or for a new company. |
field RGCAMT |
This field displays information about the company capital. |
Main site (field MAIFCY) |
You can define a main site for a company that is the default site in other operations. |
Country (field CRY) |
Enter the country code for the company. This value determines which legal data field is available and certain formats, such as:
|
Company tax ID no. (field CRN) |
Use this field to define the company tax registration number assigned by the relevant government agency. The format is determined by the country. Numbers could be, but are not limited to a:
|
SIC code (field NAF) |
This is the Standard Industrial Classification (SIC) code, which characterizes the principle activity of the business partner and can be used for selection, sorting, reporting, and so on. The code format depends on the country. |
Unique identification number (field NID) |
Unique number identifying the companies. The format depends on the country. For example, in France:
Refer to your government website for more infor |
EU VAT no. (field EECNUM) |
This is the European tax number, which must be assigned to all invoices within the European Community (EU). This number starts with two letters identifying the company's country followed by a variable number for that the country. |
Additional number (field NUMADD) |
This field is linked to the German legislation and the INTRASTAT portal. The additional number is used to identify a company or group of companies. A group of companies sends a unique tax declaration to the tax authorities with a unique tax number (VAT tax entity). |
Self-certification of origin (field ORICERFLG) |
REX number (field REXNUM) |
Division code (field DIVCOD) |
This field is not used. |
VAT collection agent (field AGTPCP) |
Tax rule (field VACCPY) |
Tax code used in the Argentine legislation. |
Federal state (field STAFED) |
Cy's pr. activity (field KACT) |
EORI number (field EORINUM) |
If the country profile for this entity has the EORI identification field selected, you can enter an EORI number, which is prefixed with the country's ISO code. Note: This number is needed for entities doing business within the UK and for EU companies importing and exporting goods and services with UK companies. |
Logo
field LOGO |
You can upload a company logo that is used in reports and other documents. |
Acct tab
Use this tab to define features that can be used when generating entries linked to the company.
Financials
Account core model (field ACM) |
This field is used to indicate an existing account core model used by the company. It is required for company with an accounting system. It links the company to an account core model defining the chart of accounts, which can include the bookkeeping currencies, analytical dimensions, and so on. |
First fiscal year (field STRPER) |
It is possible, for each of the non automatic ledger types of the company template, to define different fiscal year ranges. |
Accounting currency (field ACCCUR) |
This is the company currency code used for accounting. The accounting movements are registered, when not in this currency, in the transaction currency and the reporting currency. |
X3 folder (field FDRX3) |
Accounting code (field ACCCOD) |
Use this field to specify the accounting code of the site. |
field SCT1 |
field SCT2 |
Service ID (field SERVICEID) |
Parameters
Consolidation (field GRUCOD) |
This code is used during the data extraction operation in prevision of the consolidation. Used to identify the company from which the entries are extracted. |
Retained (field RTZFLG) |
Select this checkbox if this company manages withholdings. If selected, withholdings are calculated. |
Direct declaring site to the payment balance (field DCLDIRBALP) |
Select this checkbox to indicate a general direct declaring company to the payment balance. According to the French decree from March 7, 2003, a general direct declaring site is a company or group of companies whose foreign transactions reach at least 30 million EUR in at least one of the following areas:
When you select this field, Economic reason field is available. |
Economic reason (field BDFECOCOD) |
Enter the economic reason code for the payment balance declaration. How the economic reason code works If the company is the direct reporting company, the economic reason code must be entered under Accounting in the Company record. If the company is not the direct reporting company, the economic reason code must be entered for each nonresident BP. To do so, you need to follow these prerequisites:
This way, the economic reason code is defaulted, but you can change the value if required. In Payment proposal,the economic reason code value defaults in the payment generated following same rules. The economic reason code is loaded or not according to the context. It is not required when setting up the payment entry transaction. |
SEPA creditor identifier (field SCINUM) |
The creditor identifier contains 35 alphanumerical characters maximum.
You need to follow this format you receive a warning that the value entered is not correct. |
Grid Dimension types
Dimension type (field DIE) |
This field is used to enter or select any dimension view set up in the database. |
Analytical dimension (field CCE) |
The setup determines if the analytical dimensions can be modified. They are initialized based on the setup of the default dimension. When creating a new company record, if no order line has been entered and the project code is modified, the analytical dimensions are reset based on the setup of default dimensions. When creating or editing a record, if an order line is entered and the project code is modified, the analytical dimensions are not reset. |
Mandatory (field OBYDIE) |
When this box is checked, it will be mandatory, for instance when entering an entry, to assign at least one dimension view for this ledger. |
Upstream entry (field DACDIE) |
This value only affects the entry of dimension types in BP invoices and within the payment lines. If a dimension type is set to No, the Dimension field of the dimension type is displayed in the BP invoices header but cannot be entered. The initialization is, as usual, carried out by the default dimension codes. The dimension is not displayed in the BP invoice and payment lines but it follows the usual operation and it is initialized by the default dimension settings. |
Addresses tab
Use this tab to define a list of addresses associated with the company.
Each address is identified by a code and the set of related data.
Select the Address by default checkbox for the address to be set by default for the company.
Grid Addresses
Address (field CODADR) |
This code is used to identify the various addresses associated with the managed record such as user, company, site, business partner, and so on.
You cannot modify or delete an address code associated with a bank account number or for a contact. |
Detail
Code (field XCODADR) |
This code is used to identify the various addresses associated with the managed record such as user, company, site, business partner, and so on.
You cannot modify or delete an address code associated with a bank account number or for a contact. |
Description (field XBPADES) |
Enter a description for the address. |
Country (field XBPACRY) |
Enter or select the country code for this address. The country can determine formats such as:
|
Description (field XCRYNAM) |
The full country name |
Type (field XADDTYPSA) |
Select the address type:
|
Service type (field XADDSRVTYP) |
Unit/postal number (field XADDPOSNBR) |
Complex (field XADDCPXSA) |
field XADDLIG1 |
This table lists the various address lines. The formats of the title and of the entry are defined in the country table. |
field XADDLIG2 |
field XADDLIG3 |
Suburb/District (field XADDSUBSA) |
Postal code (field XPOSCOD) |
Enter the postal code for the city according the country-specific format, as defined in the Country table. If defined, when the postal code is changed or entered, the city name automatically displays. The reverse is true is you enter the city name. Specific cases:
The control of this information is required if the POSCOD - Nonexistent postal code alert parameter (SUP chapter, INT group) is Yes. |
City (field XCTY) |
Enter the city. If defined in the Country table, the postal code automatically displays. If the CTY - Nonexistent city alert parameter (chapter SUP, group INT) is set to Yes, a control warns you that the postal code is missing. Notes:
|
field XSAT |
This field includes the geographical subdivision that is part of the postal address definition. For example, it can be the department for France or the state for the United States. The subdivision title and the potential control on its entry are defined in the Country setup. If it is controlled, this code depends on the corresponding geographical subdivision. This subdivision is automatically populated after you enter the postal code and city, based on the Postal codes setup. |
Federal ID code (field XCODSEE) |
INSEE code for the French commune, which is required in France for specific company returns. |
Website (field XFCYWEB) |
|
External identifier (field XEXTNUM) |
You can enter a variable identifier, which can be used for specific processing. See Bank file definition for more information.
|
Default address (field XBPAADDFLG) |
You need to select 1 company address as the default. When selected, this checkbox indicates that this is the default address. |
Telephone
field XTEL1 |
Enter the phone number. The format depends on the country. |
FAX (field XTEL2) |
Tollfree (field XTEL3) |
Other (field XTEL4) |
Mobile (field XTEL5) |
field XWEB1 |
Enter the email address of the contact. You can enter up to 5 email addresses. |
field XWEB2 |
field XWEB3 |
field XWEB4 |
field XWEB5 |
Bank details tab
Enter the bank details for this contact.
Grid
Country (field BIDCRY) |
This code is used to identify the country associated with the bank account. The country determines certain formats, such as:
|
IBAN pref (field IBAN) |
The IBAN is an internationally agreed standard of identifying bank accounts in a structured format.
Not all countries support IBAN. The IBAN format applied to bank accounts is controlled by the IBAN management option, defined in the Countries setup. |
Bank acct. number (field BIDNUM) |
This number identifies the bank account of a given bank, for a given country. For the entry of the Bank ID number to be correct, it is necessary to predefine the entry format in the Country table and to activate the option IBAN management for those countries supporting the IBAN format.
In case of an IBAN this field has to contain the bank account part only, beginning from the 5th character of the IBAN. The first 4 characters of the IBAN (country code and check digits) are calculated automatically and displayed in the field IBAN pref. |
Default (field BIDNUMFLG) |
This field indicates that the Bank ID number is used by default for payments (in the absence of a more precise rule). |
Address (field BIDBPAADD) |
This field specifies the address code of the bank ID number, controlled in the address codes of the managed entity (company, site, customer, supplier, etc.). This address code is used to define the default bank ID number in payment contexts where an address is known. |
Currency (field BIDCUR) |
This code is used to identify the currency associated with the bank account. It is recommended to use the ISO coding during the creation of a new currency. |
ISR customer no. (field BVRNUM) |
This field is related to the activity code KSW – Switzerland. |
Paying bank (field PAB1) |
This field, which is mandatory for payments, defines the paying bank related to the account number. The first line contains the name of the bank. |
Beneficiary (field BNF) |
This field identifies the bank account's beneficiary (physical or moral person). |
Paying bank 2 (field PAB2) |
Paying bank 3 (field PAB3) |
Paying bank 4 (field PAB4) |
BIC code (field BICCOD) |
To perform the automatic processing of payment requests, the sender's bank needs the BIC code of the recipient's bank. This code is an ISO identifier managed by the international banking system, and namley the SWIFT system, the Society for Worldwide Interbank Financial Telecommunication. The BIC code is the only standardized bank identifier at international level. All banks can have a BIC code, even if they do not belong to the SWIFT network. The BIC code can be comprised of 8 to 11 characters. In both cases, the first 8 characters of the BIC code generally designate the bank's head office and are structured under the form BBBB PP AA, which correspond to the following information :
|
Intermediary bank (field MIDPAB1) |
In some commercial exchanges, upon the request of Business Partners or payment issuing banks, an intermediary bank is sometimes used. For that purpose, the identifiers of this bank must be entered (BIC code, paying bank, country). This information remains optional (it does not need to be entered if no intermediary bank is mandatory). |
Paying bank 1 (field MIDPAB2) |
Paying bank 2 (field MIDPAB3) |
Paying bank 3 (field MIDPAB4) |
BIC code (field MIDBICCOD) |
Country (field MIDCRY) |
BID screen management |
Tab Contacts
Use this tab to list the contact persons of the company in the contacts table. The full contact information linked to the name are displayed next to the grid.
In order to add a new contact:
- select an existing Contact (relationship) or
- create a new contact:
- you can enter a code and detailed information about this contact,
- you can also simply enter the detailed information as the code is automatically created when saving the record.
In both cases, the contact is automatically recorded in the Contacts table.
The contacts management, based on Contacts (relationships), ensures that each individual record is unique. A contact with a particular role can be recorded as one Contact among many companies, sites or BPs. Based on the record of one contact, you can indeed create relationships across records, provided they have a Contact tab.
However, a contact considered as a relationship can only be recorded as a person or individual. Only identification information such as the last name, first name, date of birth and cell phone number are common to the contact (relationship) record and to the details entered at the general contact level.
Other information such as the address, email address, landline number and fax number are managed separately between the relationship contact and each one of his/her contacts. At relationship level, the information is considered as being personal; at general contact level, the information is considered as being professional.
For further examples, see the documentation of the Contacts function.
Code (field CCNCRM) |
Each contact associated with the record is identified by a unique key, which is used to share contacts common to several records. This code defines the unique key in the contact record. This key can be manually assigned or if it is not entered, it can be defined via the CCN sequence number counter. By default, this counter is constructed of a sequence number made up of 15 characters. To ensure the correct functioning of the Contact object, it is strongly advised to conserve these standard characteristics. |
Last name (field CNTLNA) |
Indicate the family name of the contact. |
Block number 2
Code (field KCCNCRM) |
Each contact associated with the record is identified by a unique key, which is used to share contacts common to several records. This code defines the unique key in the contact record. This key can be manually assigned or if it is not entered, it can be defined via the CCN sequence number counter. By default, this counter is constructed of a sequence number made up of 15 characters. To ensure the correct functioning of the Contact object, it is strongly advised to conserve these standard characteristics. |
Title (field KCNTTTL) |
This field associates a closing sentence with a contact's family name. |
Last name (field KCNTLNA) |
Indicate the family name of the contact. |
First name (field KCNTFNA) |
First name of the contact. |
Function (field KCNTFNC) |
This field specifies the position of the contact to choose from a pre-defined list. |
Department (field KCNTSRV) |
This text field indicates the department to which the contact is attached. |
Role (field KCNTMSS) |
This field, used for information purposes, makes reference to the codes entered in miscellaneous table 906. |
Language (field KCNTLAN) |
Date of birth (field KCNTBIR) |
Birthday of the contact, only present for information reasons. |
Category (field KCNTCSP) |
Address (field KCNTADD) |
The value of the contact's address code, controlled in the address codes of the supported entity ( Addressestab), is for information purposes only. This code is used to link the contact to one of the addresses of the relevant entity. |
field KADDNAM |
Title associated with the previous code. |
Email (field KCNTWEB) |
This field is used to specify the email address of the contact. |
Telephone (field KCNTTEL) |
This field indicates the phone number. Its entry format depends on the country. |
Fax (field KCNTFAX) |
This field specifies the fax number where the entry format is identical to that of the telephone and is dependent on the country. |
Mobile phone (field KCNTMOB) |
This field indicates the mobile phone number with an entry format that depends on the country. |
Type (field KRSACNTTYP) |
Mailing prohibited (field KCNTFBDMAG) |
Default contact (field KCNTFLG) |
When this box is checked, the selected contact becomes the default contact. |
Data Protection Officer (field KDPO) |
This check box must be selected for the Data Protection Officer. There can only be one Data Protection Officer by company. |
Contacts |
To access the contact record, click the Actions icon at the beginning of each line of the table or in the Code field and click Contacts. |
Tab Sites
This tab is used to define information relative to the pre-consolidation, to the DAS 2 / 1099 declaration (specific to France), when it is declared at the company level and to the results declaration.
DAS2 address
Company name (field DADCPYNAM) |
The name of the company, entered here on up to 50 characters, is used for the DADS declaration. |
Address complement (field ADDCPL) |
This address used for the declarations related to the French legislation, is entered according to the AFNOR format as demanded for the TDS declarations. This format includes the following fields :
The TDS signals an anomaly if the commune and the distribution office are not entered or if the first two numbers in the postal code are not entered. |
Street number (field STREETNUM) |
field ABC |
The extension number of the route is standarized to the DADS standards: B for Bis; T for Ter; Q for Quarter; C for Cinques; empty if there is no expansion. |
Street (field STREET) |
This address used for the declarations related to the French legislation and is entered according to the AFNOR format as demanded for the TDS declarations. This format includes the following fields :
The TDS signals an anomaly if the commune and the distribution office are not entered or if the first two numbers in the postal code are not entered. |
Municipality code (field POSCTYCOD) |
Municipality (field CTYNAM) |
Postal code (field DADPOSCOD) |
Distributor office (field POSCTY) |
Company tax ID no. (field DADCRN) |
This field corresponds to the SIRET number of the enterprise, as it is used in the DADS declaration in France. It is composed of 14 characters, where the first 9 make up the SIREN number and are common to all the sites in the company. The final 5 form the internal number for the classification of each establishment. If this field is not entered, the DADS declaration will identify an anomaly. |
SIC code (field DADNAF) |
This is the Standard Industrial Classification (SIC) code, which characterizes the principle activity of the business partner and can be used for selection, sorting, reporting, etc. The entry format of the activity code depends on the Country. |
Declaration of results
Initialization site (field DADFCY) |
For the DADS declaration in France, the rule that is used to identify the site that submits the declaration is the following :
|
Site tax ID no. (field DADCRN2) |
This field corresponds to the SIRET number of the enterprise, as it is used in the DADS declaration in France. It is composed of 14 characters, where the first 9 make up the SIREN number and are common to all the sites in the company. The final 5 form the internal number for the classification of each establishment. If this field is not entered, the DADS declaration will identify an anomaly. |
Address complement (field ADDCPL2) |
This address used for the declarations related to the French legislation, is entered according to the AFNOR format as demanded for the TDS declarations. This format includes the following fields :
The TDS signals an anomaly if the commune and the distribution office are not entered or if the first two numbers in the post/zip code are not entered. |
Street number (field STREETNUM2) |
field ABC2 |
The extension number of the route is standarized to the DADS standards : B for Bis T for Ter Q for Quarter C for Cinques empty if there is no expansion. |
Street (field STREET2) |
Municipality code (field POSCTYCOD2) |
Municipality (field CTYNAM2) |
Postal code (field DADPOSCOD2) |
Distributor office (field POSCTY2) |
Sales
Price list structure (field PLISTC) |
This field is used to enter a price list structure code. |
Taxes
Activation (field SSTTAXACT) |
Check the check box next to Activation to use Sage Sales tax calculation for products and invoicing elements. |
Sage Sales Tax company (field SSTCPY) |
Enter the company integrated to Sage Sales Tax (SST) to process the transactions. |
Disc. invoicing element (field SFINUM) |
Enter the SST document discount invoicing element to be used for this company. One SST document discount can be defined for each company. The SST document discount lookup will filter the list of invoicing elements that meet the required setup. The criteria for selecting a SST document discount invoicing element are:
|
Tab Sites
Specific buttons
Portuguese legal data
Click Legal data to view the legal data determined by the legislation for the current record. These fields relate to Portuguese legal data.
The window displayed can be set up in Miscellaneous table 959 - Legal data / legislation. If the company is not a legal one (legislation not mandatory), then the access to legal data is only granted if all the companies of the group share the same legislation and if a window is set up for this legislation in miscellaneous table no. 959. Main
Fiscal
Other
Simplified invoice
Grid Electronic invoice
Human Resources administration
|
Select Legal data to view the legal data for Spanish legislation.
If you received funding through the Digital KIT program, you need to complete certain fields.
These fields relate to Spanish legal data and some data is included in the XML file that is part of the FACTURAE setup.
The window displayed can be set up in Miscellaneous table 959 - Legal data / legislation.
If the company does not have an accounting system, then the access to legal data is only granted if all the companies in the group share the same legislation and if a window is set up for this legislation in miscellaneous table no. 959.
Thresholds
Customer threshold in cash (field SPABPCTSD) |
Minimum amount for customer: Threshold for yearly declaration of cash payments for customers. |
field CUR1 |
This field displays the currency and cannot be modified. |
Supplier threshold in cash (field SPABPSTSD) |
Minimum amount for supplier: Threshold for yearly declaration of cash payments for a supplier. |
field CUR3 |
This field displays the currency and cannot be modified. |
Digital kit
Agreement (field AGREEMENT) |
Enter the agreement number for the Digital KIT program. This number is assigned to you. |
Start date (field INIPER) |
Enter the start and end dates related to your Digital KIT program. |
End date (field FINPER) |
Enter the start and end dates related to your Digital KIT program. |
Solution funding (field SOLFIN) |
This field displays the funding source based on your agreement number. |
Financed amount (field AMTFIN) |
Enter the amount funded for your Digital KIT agreement. |
field CUR4 |
Select Legal data to view the legal data for Polish legislation.
The window displayed can be set up in Miscellaneous table 959 - Legal data / legislation.
If the company does not have an accounting system, then the access to legal data is only granted if all the companies in the group share the same legislation and if a window is set up for this legislation in miscellaneous table no. 959.
Main
Waste DB no. (field BDO) |
Enter the 9-digit BDO (Baza danych o odpadach) for companies linked to waste management. This number is required when printing external documents. |