Customers
Use this function to maintain the Customers table and its associated tables: Business partner, Addresses, Contacts, and Bank details. In this function, you can create, view, and update customer information and BP information. Because a customer is also a business partner, it is defined in Business partner (BP) and in Customers records.
Prerequisite
Refer to the Implementation documentation.
Screen management
- Header
- Identity tab
- Addresses tab
- Commercial tab
- Management tab
- Financial tab
- Ship-to customer tab
- Bank details tab
- Contacts tab
Because a customer is also a business partner, records in both functions share data. Information on the Identity, Addresses, Bank details, and Contacts tabs is common to this function and the Business partner function (GESBPR). Any modification made on one or more of these common sections is automatically saved to the Business partner table. All the sections can be accessed from the Customer record.
Those four common sections are described in the BPs documentation.
The other four sections specific to customers are described below in this documentation.
Header
This section details basic information about the customer.
Category (field BCGCOD) |
This is the category associated with the customer.
|
Active (field BPCSTA) |
Use this field to activate or deactivate a customer. You can make a customer inactive even though transactions are still in progress. Making a customer inactive does not prevent transactions from completing. For example, you can generate a delivery for a customer made inactive after entering the order. When a customer is inactive, you cannot create a document that is part of a complete transaction. |
Customer (field BPCNUM) |
Enter a unique code used to identify the customer. For an existing customer, you can enter or select it from the Customer table. |
field BPCNAM |
Enter the customer's corporate or company name. For existing customers, you cannot edit the name here. |
Identity tab
EU VAT ID validation
You can interactively validate the EU VAT no. by selecting the EU VAT ID validation icon.
A message box displays with the validation results. The exact content varies depending on the check results and web service used.
- If the validation is successful, you receive a confirmation message and the Verified checkbox is selected.
- If the validation fails, you receive a message that displays the reason for the failure.
- If the validation could not be completed (for example, if only the VAT number was validated and not the address), you have the option to accept the results as valid or not. If you select Yes, the Verified checkbox is selected.
Note: The validation results are stored in a table.
If a previously-validated VAT number is modified, the Verified checkbox is cleared.
Validation levels:
A Qualified validation verifies the EU VAT no. and company name and address. All data must be valid.
An Unqualified or simple validation only verifies the EU VAT no. Note that the EU validation web service performs only unqualified validations.
Address management:
Results are recorded with the original address code.
For the main EU VAT no., the standard company address is used.
You can manually revalidate VAT numbers using the EU VAT ID revalidation (EVCBAT) function.
Note: This field is only available if a web service is identified by the EVCSERVICE – Webservice for EU VAT ID parameter (CPT chapter, VAT group) and the sender's EU VAT number is set by the EVCCOMPANY—EU VAT ID source company parameter (CPT chapter, VAT group)
See the documentation on BPs for more information.
Identity
Short description (field BPRSHO) |
Title used in some screens or reports when there is not enough space to view the long title. By default the short title, the long title, or the column header of a data are saved in the connection language of the user.
A user who logs on with this language sees the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions are available in the folder language. The connection language needs to be defined as a default language for the folder. |
Acronym (field BPRLOG) |
Business partner's acronym. |
field BPRNAM |
Business partner company name. |
Natural person (field LEGETT) |
When selected, it means the customer is a physical person. If not, it is a corporation. If the BP is corporation, you must enter the VAT identification number and the Site tax ID number if required for their country. |
Mailing prohibited (field BPRFBDMAG) |
Select this option to prevent mail from being sent to this customer. |
Country (field CRY) |
This code is used to identify the Country and determines the following formats and if they are required or not for the country:
|
Language (field LAN) |
Enter or select the default language. |
Currency (field CUR) |
This code is used to identify the currency of a site, a BP, etc. It is controlled in the currency table. |
Site tax ID no. (field CRN) |
Unique identification number for the company.
The entry format depends on the setup carried out at the level of the Country record. In France, this number, assigned by the INSEE on registering a company with the national registrar of companies, contains 9 numbers, is unique and cannot be changed. This is used by all public organizations and the administrations in contact with businesses. |
SIC code (field NAF) |
This fields displays the SIC code (subject to activity code KFA), according to the French company's activity codification. |
EU VAT no. (field EECNUM) |
This is VAT identification number. The EU tax number depends on the BP country and the associated validation process. |
EU VAT ID validation (field EVCVAL) |
Note: This field is only available if a web service is identified in the EVCSERVICE – Webservice for EU VAT ID parameter (CPT chapter, VAT group) and the sender's EU VAT ID is set in the EVCCOMPANY—EU VAT ID source company parameter (CPT chapter, VAT group) Select the Validation action to interactively validate your EU VAT ID or GB VAT number. A message box displays with the validation results. The exact content varies by check result and web service used.
Note: Successful validation results are stored in a table. If a previously-validated VAT ID is modified, the Verified checkbox is cleared. Validation levels:
Address management:
You can manually revalidate IDs using the EU VAT ID revalidation function (EVCBAT). |
Verified (field EVCVALDON) |
If a previously-validated VAT ID is modified, the Verified checkbox is cleared. A message box displays with the validation results. The exact content varies by check result and web service used.
Note: This field is only available if a web service is identified in the EVCSERVICE – Webservice for EU VAT ID parameter (CPT chapter, VAT group) and the sender's EU VAT ID is set in the EVCCOMPANY—EU VAT ID source company parameter (CPT chapter, VAT group) |
Intersites
Intersite (field BETFCY) |
Select this checkbox to indicate if this is an intersite BP:
|
Site (field FCY) |
The site code for a BP within the frame of multisite exchanges. The following data needs to be entered:
|
Roles
Customer (field BPCFLG) |
This field is automatically selected when the BP is a customer. |
Sales rep (field REPFLG) |
This field is automatically selected when the BP is a sales representative. |
Prospect (field PPTFLG) |
This field is automatically selected when the BP is a prospect. |
Public sector (field BPPFLG) |
This field can be accessed if the MAXPD - Maximum period (companies) activity code is activated. Select this checkbox to specify that the BP is a public sector organization. In that case, the maximum number of days for the last payment due date of an invoice is defined by the DMAXPAYP - Maximum period (Public sector) parameter (TC chapter, RSK group). If this BP is a private sector company, the period for the last payment due date of an invoice defined by the DMAXPAY - Maximum period (companies) parameter (TC chapter, RSK group). However, you can have a special agreement with this BP and grant them a longer period. Enter this period In the BP function in the Contractual period field (PAYDAY), on the BP/Company tab. |
Supplier (field BPSFLG) |
This field is automatically selected when the BP is a supplier. |
Miscellaneous BP (field BPRACC) |
This field is automatically ticked when it concerns a miscellaneous BP. |
Service supplier (field PRVFLG) |
This option is used to include a BP among the list of after-sales service providers. An after-sales service provider is an organization that may be called on to conduct an intervention to be carried out for a service request (Repair, advice, audit, quote etc...) For each service provider, it is possible to register their skills, their geographic intervention area, their price list conditions for invoicing. |
Carrier (field BPTFLG) |
This field is automatically selected when the BP is a carrier. |
Service caller (field DOOFLG) |
The contractor represents the actual customer for whom a service request is made. |
Addresses tab
See the documentation on BPs for more information.
Addresses grid
Address code (field CODADR) |
Address code of the business partner (BP). |
Detail
Address code (field XCODADR) |
This code is used to identify the various addresses associated with the current record.
You cannot modify or delete an address code when it is used for a Bank ID number or for a contact. |
Description (field XBPADES) |
Enter information linked to the address. |
Country (field XBPACRY) |
Enter or select the country code, managed in the Country table. The country determines certain formats including:
|
Description (field XCRYNAM) |
Title associated with the previous code. |
field XADDLIG1 |
This table lists the various address lines. The title and entry formats are defined in the country table. |
field XADDLIG2 |
field XADDLIG3 |
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 function, 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 ITINERAIRE |
Select to open a mapping site and locate the entered address. |
field XSAT |
This field contains the geographical subdivision corresponding to definition of the postal address. It could be a department, province, state, and so on. The description and format are defined in the Country function. This field loads automatically after you enter the postal code and city based on the Postal codes settings. |
Website (field XFCYWEB) |
Enter a website for the customer. |
External identifier (field XEXTNUM) |
You can enter a stock variable identifier, which can be used for specific processing. |
Default address (field XBPAADDFLG) |
When selected, this checkbox indicates that the address is the default address. Only one of the addresses in the selected record can be selected. This always corresponds to one of the BP's addresses. |
Address validation (field VALADR) |
Select to send an address to the Sage Sales Tax (SST) address validation service. If this address is found, it is updated according to the US Postal Service format. The SST address validation service is defined in the Sage Sales Tax settings. |
Validated (field XADRVAL) |
If selected, it means the address was validated with SST address validation service. If not selected, the address is unknown. |
Telephone
field XTEL1 |
The format depends on the country. |
field XWEB1 |
Enter an email address of the contact. |
Commercial tab
Use this section to enter commercial information related to the selected customer.
- The customer ABC class.
- Order criteria such as loan management for this customer, which has a similar option in the Product function, or the balance of partial orders that are not completely shipped.
- Delivery criteria such as not allowing the delivery of lines created from different orders on the same packing slip, or setting delivery constraints such as not allowing deliveries on an order unless it is fully delivered, or not allowing the delivery of a line with an incomplete quantity, fully delivered or not, or no constraints.
- Commercial and invoicing criteria such as minimum order amount, method, and invoice scheduling, number of invoice copies to be printed, ex-tax price or price including tax by default, invoicing condition used for non deliverable products, original date for the payment due date calculations, either the invoice date, or the shipment date, and the freight invoicing rule that can be always Invoiced, Not invoiced or Up to the threshold as defined in the Carrier record.
- The sales representatives and secondary representatives:
This section also contains 2 Sales rep. fields to assign the sales representatives responsible for the customer account. In addition to the principal sales representatives, you can enter sales representatives by role and by the product commercial group. From the Actions icon, you can access the Second representatives window from either of the two fields. When new employees become involved in the commercial relationship, you can save their identity and their role with respect to the customer and their expertise with the product commercial group. When a customer wants more detail on a particular subject, it is then easy to identify the qualified employee for the specific customer details and field concerned.
The Commission category field is used to identify, in the Sales rep. field, the default commission rates.
- The Order and Invoice checkboxes in the Texts sections indicate that texts associated with the order and the invoice were created using the Texts menu located at the top of the screen.
A checkbox is available to specify that an order acknowledgment is printed for this customer and the code of a Print template can be specified to associate, to this customer or group of customer, a list of reports to use as a priority. - The discounts and/or charges (as a percentage and/or as a value) used to give the default values of the invoice footer elements in the customer invoicing. These elements are defined in the Invoicing elements setup function.
Order
ABC class (field ABCCLS) |
Select a code to identify the ABC category of a business partner. |
Minimum order (field WORDMINAMT) |
Minimum tax excl. amount, expressed in folder currency, below which customer orders cannot be saved. |
field XCUR |
This is the folder currency. |
Allow order close (field ORDCLE) |
This information, initialized by the sold-to customer, is used to authorize or not the closing of a line or the order. This information is modifiable on order entry if the transaction allows this. |
Loan authorized (field LNDAUZ) |
This indicator is designed to define whether a loan of goods for this customer is authorized. |
One order per delivery (field ODL) |
This information, initialized by the sold-to customer, is used to prohibit the grouping of several orders in the same shipment. This information is modifiable on order entry if the transaction allows this. |
Partial delivery (field DME) |
This information, initialized by the sold-to customer, is used to specify how the order is delivered. There are three possible values:
Note: When you select Complete line or Complete order, you can ignore this warning message and force the partial delivery. |
Price/Amount type (field PRITYP) |
Select this checkbox if the prices of products (sales invoices) and amounts (customer BP invoices) include or exclude taxes. This affects the price list search. Only those price lists defined in a mode or those accepting a price conversion are included. The document price/amount type excludes or includes tax depending on the type defined at customer level. If the supplier is connected with a customer category, this information is initialized by the amount type defined at the level of the field Price type/Amount type of the category. |
Invoicing
Freight invoicing (field FREINV) |
Determine if freight is invoiced to the customer or not. Or you can select which thresholds are defined in the carrier record.
For more details, see the FRENUM - Carrier invoice element (VEN chapter, INV group) parameter settings. |
Invoicing mode (field IME) |
This information is initialized by the sold-to customer and is used to define the customer's invoicing mode. This invoicing mode is used subsequently to invoice the delivery notes or the direct invoicing orders by regrouping or splitting them. This information is used in the automatic invoicing process and in the manual invoicing function, where a control is performed with respect to this information. The available invoicing modes and their impact on the delivery invoice are as follows:
How your selection affects delivery generation: orders with One/order or One/closed order are never grouped on the same delivery. In addition to these invoicing modes, information that varies from one delivery to the next prohibits the grouping two deliveries. See automatic delivery invoicing. How your selection affects direct invoicing orders:
|
Invoice period (field INVPER) |
Select when invoices are generated:
|
Invoicing term (field INVCND) |
Use this field to specify the Invoicing term. This information is optional. |
Due date origin (field DUDCLC) |
Select which date to use when calculating open items. |
Accept electronic invoice (field AEIFLG) |
Sales reps
Commission category (field COMCAT) |
Commission category used to select the commission rate of the sales representative record for the commissioning calculation. |
field REP |
Code of the sales representative associated with the customer and controlled in the sales representative table. The sales representative of the sold-to customer has priority over the sales representative of the ship-to customer. An activity code is used to define the number (maximum of 2) of sales representatives submitted as the default value for an order. |
field MORREP |
Discounts and charges
No. (field INVDTA) |
This is the code for the invoicing element. |
Description (field SHO) |
This is the short title for the invoicing element. |
% or amount (field INVDTAAMT) |
This is information relative to the invoicing footer. The invoicing elements correspond to the category of customer used or to the elements set up to be displayed on the customer record if no category has been associated to the customer. |
field INVDTATYP |
This column specifies if this is a percentage, an ex-tax amount, or a tax-incl. amount. |
Curr. (field WWCUR) |
This is the customer currency. |
Text
Order (field WORDTEX) |
This checkbox is selected if an order text exists for this customer. This text is used on each order so it can be printed on the order acknowledgment. |
Invoice (field WINVTEX) |
This checkbox is selected if an invoice text exists for this customer. This text is used on each modified invoice. |
Reports
Print acknowledgement (field OCNFLG) |
Select this checkbox if receipt acknowledgements need to be printed for orders. |
Template code (field TPMCOD) |
Enter a print template listing the reports to use and the number of copies with the documents used in commercial management. You can specify the reports and to assign them to specific BPs. To enable an electronic invoicing for Portuguese legislation, you mustneed to select a PDF print template code or invoice report compatible with Portuguese legislation. The archive destination for the template in PDF format is determined by the EFATPRT – Default destination for EFAT parameter (LOC chapter, POR group) setting. |
Electronic invoice
Electronic invoice (field ELECTINV) |
Select this checkbox to send an electronic invoice to the customers who agreed to receive electronic invoices. To activate the electronic invoicing feature, you need to select an archive Print template code. This field only applies to Portuguese legislation and is available when the EFAT activity code is active. The electronic invoice is in compliance with the legal requirements of the Portuguese tax authorities. Please refer to the EFAT communication documentation for further information. |
Contact (field CNTEFAT) |
You can only enter a contact with a valid email address linked to the customer record. This field is only available if the Electronic invoice checkbox is selected. |
Start date (field STRDATEFAT) |
This field is only available when the Electronic invoice checkbox is selected. The start date determines the beginning of this type of communication. Only invoices that were posted after this date are included in the electronic invoicing process.
|
Management tab
Use this section to enter management information, such as:
- The Customer type: Normal or Miscellaneous. The default type is Normal.
When you select Miscellaneous, an address entry window opens for all the commercial documents. These customers type are not distinguished in accounting. - The number under which the company is known as one of the customer's suppliers. This is for information only.
- The rate type used to determine the default rate for posting sales documents. The list of rate types is defined in local menu 202, whose standard values can be modified.
- The type of control applied to the customer credit amount and to the authorized credit level, if controlled.
- The credit insurance threshold, for information purposes only, and the definition date, and the insurance company cod, if defined as a miscellaneous BP.
- Comments in the Notes section display when entering a sales document.
- The Business and Source fields are used for customer segmentation. Each sales representative needs to enter the relevant information.
- The information used by customer support, specifically credit and debit. You can also view the remaining points.
Miscellaneous
Customer type (field BPCTYP) |
You can select Normal or Miscellaneous. Normal is the default value. |
Our supplier no. (field BPCBPSNUM) |
The number under which the company is known as a supplier for the customer. |
Rate type (field CHGTYP) |
This is the rate type used to determine the default rate to determine the posting rate of sales documents. You can modify the standard values. |
Customer relations
Business (field BUS) |
This field is used to qualify the economic activity of the customer with a level of segmentation adapted to the segmentation needs of the commercial team. |
Source (field ORIPPT) |
This field is used to record the commercial channel at the origin of the identification and qualification of a business partner. |
Customer since (field BPCSNCDAT) |
This field is used to specify the date from which the BP has been a customer of the company.
|
Block number 5
Token credits (field PITCDT) |
This field displays the total number of tokens credited by the customer as a result of their different orders. |
Manual supplement (field PITCPT) |
This field is used to perform a manual addition of points (tokens) for the customer, independently of the receipt of a sales order. |
Total token credit (field TOTPIT) |
This field displays the total number of tokens credited by the customer as a result of their different orders. |
Points debit (field BPCPITDEB) |
You can enter a point debit rule directly for a customer. |
Value 0 (field NULPIO) |
This option is used to block the tree of rules for debiting points during the analysis of a service request coverage. |
Service contract (field COTCHX) |
This field is used to indicate the service contract template that will be automatically offered to the customer each time enough tokens have been accumulated. |
Tokens necessary (field COTPITRQD) |
This field displays the minimum number of tokens necessary for a customer to be offered a service contract. This information has priority over its equivalent in the service contract template. |
Credit
Credit control (field OSTCTL) |
Select the type of control that you want to apply on the customer credit amount:
The WIP is controlled with respect to the risk BP of the customer. If the risk BP is shared by several customers, it means that the WIP of each customer will be controlled the same way with respect to the risk BP by cumulating the total of the different customers movements.
|
Authorized credit (field WOSTAUZ) |
Maximum credit amount authorized for this customer. This amount is expressed in the currency of:
|
field XCUR |
Credit level total (field XOST) |
This is the total credit amount, which is calculated automatically.
On the relevant documents, the credit amount:
Does not include: Invoicing elements Global VAT adjustment. |
Credit insurance (field WCDTISR) |
Amount of the insurance secured to cover the customer risk in case of default. This amount is expressed in the folder currency. |
Insurance date (field CDTISRDAT) |
End date of the insurance secured to cover of the customer risk in case of default. |
Insurance company (field BPCCDTISR) |
The insurance company is defined as a miscellaneous BP. This information field is designed to associate essential descriptive details to the insurance companies (titles, addresses, contacts, etc.). |
Notes
Customer notes (field BPCNOTE) |
Select this icon to:
Notes are limited to a screen inquiry and cannot be printed. For more information, see the documentation on Notes. |
Statistical groups
field TSCCOD |
You can enter a code to link a statistical group to the customer. This code is controlled in the table of statistical groups. It can be used in statistics, price list settings, or as a selection criteria in specific automatic processes. |
Financial tab
Use this section to enter financial or accounting information such as:
- The bill-to and pay-by customer (customer activity) and the factoring organization if there is one for this customer.
- The customer group, which is a part of the customer organization and can be modified on each document.
- The risk BP on which is based the calculation of the customer's balance.
- The accounting code associated with the customer is designed to characterize in accounting the postings linked with the customer (invoices, credit memos, pre-payments, outstanding debts…) by describing the control accounts, the accounts or even parts of accounts used by default in the automatic journals.
- If the account structure, even though it is not mandatory, is loaded, it is submitted to be applied upon the creation of a customer invoice (once the invoice tax excl. amount has been entered).
- The tax rule and the agreement number in case of a partial exemption.
- The payment conditions, a discount/charge code used to define the charge rates for late payments, and the discount rates on early payment, a default payment bank if it corresponds to one of the company' s banks (this is used to assign the payments to the bank in question, in order to minimize the bank charges)
- The reminder type and group and the minimum reminder amount, which condition how the reminder reports are printed (No reminder, By invoice, which means that a reminder letter will be created for each invoice to be reminded, Global, which means that a unique reminder letter will be created for the due date items together, Global by level or Global by lead-time, which will regroup the due date items to be reminded according to the number of reminders already issued or according to the lateness thresholds). The standard reminder report FUP uses these parameters, the open items management is designed to filter if required the open items to be reminded individually.
- The statement type is used to determine the frequency of the due date item statements for this customer.
- The analytical dimensions along with each dimension type, which can be used as the default value in the different documents linked to the customer management, thanks to the corresponding setup.
- If the KPO activity code is active and the customer is based in Portugal, the information regarding the VAT rule is enabled. In this block, it is necessary to specify if the Cash VAT applies to the current customer, and also the application periods.
BPs
Bill-to customer (field BPCINV) |
It is the code for the bill-to customer, which is initialized by default with the customer code entered in the header. It is possible to search a customer or several customer grouped under the same criteria by selecting 'Quick customer search'. A list of matching items is generated on tabulating to the next field. |
Address (field BPAINV) |
This field is designed to indicate an invoicing address code for the selected invoiced customer. It is the default address of the customer. |
Pay-by customer (field BPCPYR) |
This field is used to enter the pay-by customer code, initialized by default to the customer code entered in the header. The invoice payment schedule will be allocated to this BP. |
Address (field BPAPYR) |
This field is designed to indicate a payment address code for the selected pay-by BP. It is the default address of the customer. |
Factor (field FCTNUM) |
Code of the factor proposed as a default value on the invoices for this customer. |
Group customer (field BPCGRU) |
The group customer code is initialized by default to the customer code entered in the header. |
Risk customer (field BPCRSK) |
Code of the customer on which the credit control is performed. |
Accounting code (field ACCCOD) |
This field is designed to specify the accounting code of the BP. |
Account structure (field DIA) |
The account structure is not compulsory data. |
Payment
Payment term (field PTE) |
Enter the code linked to the current BP by default, and which is used to determine:
When managing this table, it is possible to simulate the calculation rules that will be applied in entry mode. |
Payment days (field J1) |
The payment days in the payment terms are replaced by the payment days introduced in the customer record. |
Unavailable period (field UVYCOD2) |
In this field a predefined unavailable period can be indicated. In this case, the calculated due dates for this customer cannot be in this unavailable period. They are then postponed to the first available date. |
Settlement discount (field DEP) |
Enter the code linked by default to the current BP, which is used to identify the early discount and late charge rates (up to 12). These rates will be applied to a payment depending on a number of early or late days compared to the due date. |
Payment bank (field PAYBAN) |
This code is controlled in the table of Bank accounts. |
Reminder group (field GRP) |
Reminder group with which the customer is associated. The reminder group is used to define a group of management rules that are applicable during the launch of the reminder letters. |
Reminder type (field FUPTYP) |
Type of reminder process for the customer. The reminder type, and reminder threshold, taken into account by the reminder report are those of the customer record (and not those of the reminder group which are only used upon initialization). This field is controlled by a local menu and can take the following values: By invoice: The customer receives as many reminder letters as invoices that are late for payment. Global: A single reminder level is addressed to the customer for all the late invoices. Global by level: The open items are grouped by identical level and the customer receives a reminder letter by level. Each reminder level contains all the open items overdue for a given level. Global by date: The open items are grouped by late open item ranges (for example, all open items that are overdue by 30 to 60 days). The customer receives one reminder letter per late open item range, or more, depending on the reminder group. |
Minimum reminder (field FUPMINAMT) |
Minimum amount below which a reminder letter is not issued for this customer. |
field FUPCUR |
This field displays the currency of the reminder threshold, based on the value of the CURSHRFLD - Common field currency parameter. |
Open item statement frequency (field SOIPER) |
Flag used to determine the frequency of the open item statements for this customer. |
Credit card (field SEBPC) |
Select the Credit card icon to open the Payment gateway customer data window. Use this function to add and maintain multiple payment cards for a customer. This button is available if the SEPP - Credit card integration activity code is activated. |
Taxes
Tax rule (field VACBPR) |
A tax rule represents the tax territoriality principle, in other words, the calculation rules to be applied to determine the tax amount. |
Exemption no. (field VATEXN) |
This field is designed to enter the number assigned to the tax exemption. |
VAT collection agent (field AGTPCP) |
Regional taxes (field AGTSATTAX) |
Once checked, this box is used to specify that the provincial taxes must be applied to the selected customer. |
Subject to tax (field BELVATSUB) |
If this box is checked, the customer is subject to VAT. This box is checked by default when the BP country is Belgium. |
Analytical
Dimension type (field DIE) |
The dimension types that are preloaded in the grid match the default dimension types associated with the customer base data. |
Dimension (field CCE) |
The setup determines if the analytical dimensions can be modified. They are initialized based on the setup of the default dimension. In creation mode, 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. In creation mode, as in modification mode, if an order line is entered and the project code is modified, the analytical dimensions are not reset. |
Regional taxes
Provinces (field SATTAX) |
This fields is designed to specify the provinces for which provincial taxes exist. |
Provinces (field DESSAT) |
This is the title of the province. |
Application (field TYPAPL) |
This field is used to define whether the tax applies upon entry in the region, upon exit, or always. |
Collection agent (field FLGSATTAX) |
This field is designed to specify if the customer is a tax collector for this provincial tax. |
Cash VAT (Portugal)
Tax rule (field CSHVATRGM) |
This field can only be entered when the following conditions are met:
You use this field to indicate if the customer is subject to article 23 of the Portuguese law 71/2013 on VAT rules. If yes, all invoices sent to this customer will go through a specific process at the payment level, once the invoices have been settled. The payments must indeed be subject to a tax return, which means that the customer must be provided with a special payment notice listing all VAT amounts by tax level. |
VAT start date (field VATSTRDAT) |
This field is mandatory when the customer is subject to article 23 of the Portuguese law 71/2013 on VAT rules. |
VAT end date (field VATENDDAT) |
This field is only available when a start date has been entered.
If no date is entered, article 23 of the Portuguese law 71/2013 will apply from the start date.
|
Ship-to customer tab
Use this section to enter information on the ship-to customer(s) attached to this customer. Each ship-to customer corresponds to a line in the selection list and is identified by an address code defined in the Address section. The main section on the screen shows details on the delivery point.
The following information can be found in this section:
- Sales representatives (2 maximum) assigned to the delivery point used by default when no representative is defined on the Commercial section.
- The default shipping site for this delivery address.
- The receipt site corresponds to this address when the customer is an inter-site type defined as a purchase site. This information can only be accessed in this context.
- A loan location, which is used to define a location assigned to the customer (for loans). This location must set to Customer.
- A subcontractor location is used to define a location by subcontractor supplier address, who must be defined as a customer. This location must be set to Subcontractor and will be used for subcontractor deliveries.
- The round number, defined in local menu 409, where the standard values can be modified, which can be used as filtering criteria for the allocation and management of deliveries.
- The shipment priority, defined in local menu 410, where the standard values can be modified, the titles being used to define the increasing priorities, which can be used as filtering criteria for the allocation and management of deliveries.
- The carrier and the delivery method suggested by default on order entry, as well as an average delivery lead-time designed to define the preparation date from the requested delivery date.
- The customs information, as well as the information necessary to establish the exchange of goods declaration, reported and editable in the delivery notes. The default value used for the freight terms, the flag defining the location of the delivery by default, the forwarding agent reference and address, the EU identification and increase rate used by default to calculate the statistical value from the fiscal value.
- The availability information for the delivery, work day calendar, and open days of the week.
- Language code to be used for the translatable elements in the documents linked to the delivery.
- Two checkboxes, Preparation and Delivery in the Text block, which cannot be modified but are automatically updated if standard texts linked to the preparation and delivery are used for this ship-to address. To enter these texts, click the Actions icon from the address code displayed in the delivery address selection list.
- Two checkboxes specifying if the pick ticket or packing slip must be printed.
Grid
Address code (field BPAADD) |
Use this field to codify the shipping address of the ship-to customer. |
Block number 2
Address code (field XBPAADD) |
It is the code for the delivery address unavailable in this context. |
field XBPADES |
Description of the address (for internal usage). For instance: temporary address, principal warehouse address, and so on. |
Active (field XENAFLG) |
This checkbox is used to specify if the delivery address is active or not. |
Language (field XLAN) |
This code indicates the language of the delivery address, used in the reports linked to this delivery. |
Default ship-to customer (field XBPDADDFLG) |
This checkbox is selected to indicate that this is the default customer. |
Company name 1 (field XBPDNAM0) |
It is the company name for the delivery address mentioned in both fields. |
Company name 2 (field XBPDNAM1) |
It is the company name for the delivery address mentioned in both fields. |
Tax/sales rep.
Tax rule (field XVACBPR) |
Enter the tax rule associated with the ship-to customer. This tax rule is controlled in the table of tax rules. When creating a sales document, the tax rule applying to the delivery address is suggested by default, if this address uses a specific tax rule. |
Entity/Use (field XSSTENTCOD) |
Enter the Entity/use code to calculate the precise tax amount for the customer. This tax code is compatible with the Avalara system and makes it possible to determine the customer type for fiscal purposes. This field is available for all countries. The Entity/Use code can be entered for any delivery address when a document is being processed for a country that is tax-exempt. When the Calculate all
documents connection with SST is set to No and
an Entity/use code is entered, the document is exempt from tax and not subject to processing costs. |
Sales rep 1 (field XREP0) |
Enter the codes of the sales representative associated to the delivery address and controlled in the sales representatives table. |
field REPX |
Sales rep 2 (field XREP1) |
Enter the codes of the sales representative associated to the delivery address and controlled in the sales representatives table. |
Text
Preparation (field TWPRPTEX) |
Delivery (field TWDLVTEX) |
Delivery
Shipment site (field XSTOFCY) |
This is the storage site code from which the customer is generally delivered. This site, which is controlled in the site table, must be identified as a warehouse. This information can only be accessed if the order is of the inter-company or inter-site type. It is used to indicated which shipping site will be used by the sales company that the intersite/inter-company supplier identified. It will then serve to initialize the shipment site for each line of the purchase order. It is mandatory in this context. The shipment site is initialized by order of priority, as follows:
If after this search, the site is still not identified, you must then manually enter it. A control is applied to check if the entered site belongs to the same company as the supplier site and if the site is a storing site. The Actions icon is used to view all the sites available for selection. Automatically-generated purchase orders: If the shipment site is still not identified after the execution of the previous steps, the shipment site is initialized using the first warehouse site found, in alphabetical order, in the list of storage sites for the company identified by the supplier. When generating the corresponding sales order, the shipping site of the sales order header is equal to the site defined here. |
Receiving site (field XRCPFCY) |
This is the storage site code where the customer is generally delivered. |
Loan location (field XBPCLOC) |
Name of the location where the products will be transferred to when validating a loan delivery (location change) to identify the loan products. |
Subcontract location (field XSCOLOC) |
In this field, enter a location by subcontract supplier address (where the supplier is defined as a customer). This location must be of the Sub-contractor type and will be used for sub-contractor deliveries. This filed is only available if a shipping site is entered on the delivery address. The location necessarily belongs to this site. |
Route no. (field XDRN) |
Number of the round, controlled by a local menu. |
Delivery priority (field XDLVPIO) |
In this field, specify the delivery priority (Normal, Urgent, Very urgent). The priority is used to classify orders during the delivery preparations. The order lines applying to non-deliverable products are not impacted by this information. |
Delivery mode (field XMDL) |
Enter the code used to define the information related to the transport and delivery. This code is managed in the table of delivery methods. |
Delivery lead time (field XDAYLTI) |
Enter the delivery lead-time for this customer, expressed in a number of days. This lead-time is used to calculate the shipment date according to the delivery date requested by the customer. |
Carrier (field XBPTNUM) |
This code identifies the carrier in charge of the carriage to determine the costs linked with the goods transportation at the customer. |
Reports
Pick ticket (field XNPRFLG) |
This box, when selected, is used to specify that the delivery notes must be edited for this customer. |
Pckg. slip (field XNDEFLG) |
This box, when selected, is used to specify that the picking tickets must be edited for this customer. |
Work days
Monday (field XUVYDAY1) |
This indicator is used to identify which days of the week are work days for the customer. |
Tuesday (field XUVYDAY2) |
Wednesday (field XUVYDAY3) |
Thursday (field XUVYDAY4) |
Friday (field XUVYDAY5) |
Saturday (field XUVYDAY6) |
Sunday (field XUVYDAY7) |
Unavailable period (field XUVYCOD) |
Use this code to specify the unavailability periods of the business partner, such as vacation days or holidays. During the order process, the delivery date is automatically moved to the first available date. This code is controlled in the table of unavailable periods. |
Incoterm®
Incoterm (field XEECICT) |
The Incoterm® codes, set by the International Chamber of Commerce, standardize the terms the most used in the international commerce by defining the respective responsibilities of the seller and the buyer for the sales contract by a unique word similarly understood throughout the world. The Incoterm® code, controlled in Incoterm® table is used in the INTRASTAT file (Exchange of goods declaration). It can also be used to define the price lists. |
Incoterm town (field XICTCTY) |
It is the city associated to some types of Incoterm®. For example: FOB Le Havre. A selection window is used to choose a city listed in the system. It is however possible to enter a city that is not listed. |
Freight agent (field XFFWNUM) |
The forwarding agent field is used to identify a BP appointed by the sender or the recipient to ensure transport continuity when the goods need to undergo several successive transports. The forwarding agent is controlled in the Carriers table. The forwarding agent and their address are used in the Intrastat file to declare the flows of goods between the forwarding agent’s address and the sender’s address, or between the forwarding agent’s address and the recipient’s address. For example, this situation applies to the shipment of goods abroad, since customs formalities are performed by a forwarding agent in another EU country. An Intrastat declaration needs to be submitted for the transfer of goods to this other EU country. |
field XFFWADD |
This is the address code of the forwarding agent. It is initialized with the default address of the BP corresponding to the forwarding agent. This address is used to determine whether submitting an Intrastat document is necessary for this flow. |
EU information
EU VAT no. (field XEECNUM) |
This is the VAT identification number of the buyer. |
Intrastat increase (field XEECINCRAT) |
This field is subject to the Exchange of goods declaration (Intrastat). This conversion factor is used in the Intrastat declaration for the exchange of goods. It is used in supplier invoices and applied to the fiscal value of the product line to obtain the statistical value. |
EU VAT ID validation (field EVCVAL2) |
Note: This field is only available if a web service is identified in the EVCSERVICE – Webservice for EU VAT ID parameter (CPT chapter, VAT group) and the sender's EU VAT ID is set in the EVCCOMPANY—EU VAT ID source company parameter (CPT chapter, VAT group) Select the EU VAT ID validation action to interactively validate your EU VAT ID or GB VAT number. A message box displays with the validation results. The exact content varies by check result and web service used.
Note: Successful validation results are stored in a table. If a previously-validated VAT ID is modified, the Validated checkbox is cleared. Validation levels:
Address management:
You can manually revalidate IDs using the EU VAT ID revalidation function (EVCBAT). |
Validated (field EVCVALDON2) |
If a previously-validated VAT ID is modified, the Validated checkbox is cleared. A message box displays with the validation results. The exact content varies by check result and web service used.
Note: This field is only available if a web service is identified in the EVCSERVICE – Webservice for EU VAT ID parameter (CPT chapter, VAT group) and the sender's EU VAT ID is set in the EVCCOMPANY—EU VAT ID source company parameter (CPT chapter, VAT group) |
Intrastat transp. location (field XEECLOC) |
A transport location must be specified in the EU exchange declaration. It is combined with the Incoterm code in order to determine the delivery conditions referring to the sales contract terms that specify the respective obligations of the buyer and seller. This information is not used in the French declaration. |
Pick ticket text |
Use this action to create a text that will be loaded in all pick tickets linked to this ship-to address. The SALTEXPRP parameter is used to set up the assignment of this text. |
Delivery text |
Use this action to create a text that will be used on all packing slips related to this ship-to address. The SALTEXDLV parameter is used to set up the assignment of this text. |
Market sector |
Use this menu to view the market sector associated with the address code of the ship-to customer based on a sector code. |
Bank details tab
Use this section to record bank details and associated paying banks. The entry format of the Bank account no. depends on the country where the bank is based.
The information related to international transfers can be accessed in record mode, usually the Intermediate bank. An intermediary bank is often used in commercial relationships with non-western countries at the request of the BP or issuing bank.
If the conditions are met, the Enter bank details window is automatically displayed when leaving the Country field. In this window, you can enter the bank details in your local format.
Please refer to Enter bank details window documentation for more information.
Bank details
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. |
Country (field BIDCRY) |
This code is used to identify the Country and determines the following formats and if they are required or not for the country:
|
IBAN prefix (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 function. |
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 only contains the bank account, 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 IBAN pref field. |
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). |
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 requires the KSW – Swiss localization activity code to be active. You use it to enter the ISR customer number for the given bank account. This number is used for payments with ISR number (inpayment slip with reference numbers). For suppliers, the ISR customer no. is also used to search for a matching BP account if support for ISR code line entry on purchase invoices is active in the SWIPURBVR - Swiss ISR usage purchasing parameter (LOC chapter, SWI group). Refer to the Swiss legislation guide on the How to tab for more details regarding payment and ISR setup. |
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) |
Copy bank details |
Enter bank details |
Use this window to enter the bank details in your local format. The information entered is then automatically recovered in the fields of the Bank details section. This window automatically opens when leaving the Country field, but only if the following conditions are met:
|
Contacts tab
In this section, you can list the contact persons for the BP in the Contacts table. You also need to indicate the default contact.
To add a new contact:
- Select an existing Contact (relationship).
- Create a new contact:
- Enter a code
- Add details: The code is automatically created when saving the record.
In both cases, the contact is automatically recorded in the Contacts table.
The management of contacts, from the Contacts function, ensures that each individual record is unique. A contact with a particular role can be recorded as one Contact amongst many business partners. Based on the record of one contact, you can create relationships across records, provided that they have a Contact section.
A contact can only be recorded as a person or individual. Only identification information such as the last name, first name, date of birth 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 the 'relationship' contact level, the information is considered as being personal; at the general contact level, the information is considered as being professional.
For further examples, see the Contacts function documentation.
Contacts
Contact 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) |
Indicates the family name of the contact. |
Detail
Contact 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) |
This fields specifies the language of the contact. |
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, 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. |
Mailing prohibited (field KCNTFBDMAG) |
This indicator is designed to specify that the contact cannot be selected in a mailing. |
Default contact (field KCNTFLG) |
When this box is checked, the selected contact becomes the default contact. |
Contacts |
Copy contacts |
Reports
By default, the following reports are associated with this function :
BPC1 : Customer record
BPCOSTCTL : Customers with authorized credit exceeded
BPCUSTOMER : Customer list
This can be changed using a different setup.
Specific buttons
Products |
Menu bar
Notes P/R not due 1Use this action to display the query windows that give you access to the financial risk information, in particular the notes payable and receivable not due. Reminder: Three types of notes payable and receivable can be managed. This is defined in the setup of the payment transactions. When an intermediate posting is performed, you must go to the Steps section to indicate if a group, or "portfolio", of notes payable/receivable not due must be updated and, if yes, which one (for the group of notes P/R number 1). Notes P/R not due 2Use this action to set up the second type of notes payable/receivable (see "Notes P/R not due 1" in this documentation). Notes P/R not due 3Use this action to set up the third type of notes payable/receivable (see "Notes P/R not due 1" in this documentation). Doubtful receiptsUse this action to view the detail of the doubtful payments if any. ExtensionsUse this action to view information on extensions when some notes payable and receivable have been postponed. |
QuotesUse this action to view the list of quotes for the selected customer (with filtering criteria on the company, site, customer, converted quotes, non-converted...). For more information see the help on the Quote inquiry function. From each line, an action is available to jump to the corresponding quote. Quote lineUse this action to view the quote lines for this customer. OrdersUse this action to view the list of orders for the customer (with filtering criteria on the company, site, customer, order category, shipped orders, open orders...). For more information see the help on the Order inquiry function. From each line, an action is available to jump to the corresponding order. Order lineUse this action to view the order lines for this customer. DeliveriesUse this action to view the deliveries for the customer (with filtering criteria on the company, site, customer, shipment type, confirmed shipments, non-confirmed...). For more information see the help on the Shipment inquiry function. Delivery lineUse this action to view the quote lines for this customer. InvoicesUse this action to view the list of invoices for the customer (with filtering criteria on the company, site, customer, validated invoices, non-validated...). For more information see the help on the Invoice inquiry function. Invoice lineUse this action to view the quote lines for this customer. AccountsUse this action to view the customer account (all the control accounts together by default). For more information see the help on the Account inquiry function. Installed baseUse this action to jump to the Customer base function and filter the customer base records on the selected customer. For more information, see the help on the Customer base management. Installed base by addressUse this action to view the installed customer base for a specific address. Aggregated installed baseUse this action to view the customer base, according to a set of criteria. BP situationUse the BP situation action to get an overview of the customer based on their assigned due dates, financial and commercial credit levels and the last operations they performed. Risk analysisWhile the BP situation action provides you with an overview of the customer status (financial, commercial, due dates, performed operations...), the Risk analysis action gives you direct access to information on customer financial risk. Last operationsWhile the BP situation action provides you with an overview of the customer status (financial, commercial, due dates, operations performed...), the Last operations action gives you direct access to information on the last operations performed by the customer. Aged balanceUse this action to access the aged balance for this customer at this date. |
Associate order giversUse this action to define if the selected customer is an internal customer, a customer of an order-giver (or service caller), or both. If the customer is internal, select the Internal customer check box. If the customer is not an internal customer, enter all the order-givers that the customer is linked to. To do so, enter the Service caller field, or use the Selection icon to choose from the list of available service callers defined as BPs. Market segmentsUse this action to view the market sector associated to the address code in the customer record based on a sector code. Points debitThis function is used to access the points debits points debit rule currently in use for the customer. It is possible to manage both the contractual rules and the additional points debits. HistoryThis function is used to view all the Pre-sales and After-sales activity for the current customer. The actions carried out are sorted from the most recent to the oldest, whilst the actions to be carried out are sorted in the opposite direction. All the following record types are grouped within this history:
A contextual menu, Detail, is available on each line in the grid. This is used to access the complete record for each action displayed in the history. ProjectsThis function is designed to directly access the projects object. |
BP ID validationThis option is only available if you have the license for Data Clean and Control.
This validation functionality is available in several functions. It is limited to French companies, which are listed in the French government SIRENE database. You can use it to confirm data related to an existing BP and to help build an accurate BP record when creating a new BP. You can access this functionality from the Site tax ID no. field or from the Actions menu in these functions:
How to validate a BPThis only applies to French BPs registered in France. For an existing BP: You can compare data in your record with the SIRENE database. The BP information block displays data in the current record that is compared against the SIRENE database. For a new BP: You can find information about a new BP to complete the new record. In this case, the fields in the BP information block are empty. If you are validating an existing BP, you can update your record. Performing an update overwrites existing data with data from the SIRENE database.
In the Site tax ID no. field, select BP ID validation from the More actions icon. Or select BP ID validation from the Actions menu. In the BP ID validation screen that opens, you can search the SIRENE database according to the search criteria you enter. You can search by 1 or up to all 4 criteria. All entered criteria are considered in the search. For example, if you search by a company name and a city, results match both inputs. If you enter a Company name, you can search for all companies that begin with the characters entered in that field or for all companies that contain those characters. If there is no match, try removing 1 or more criteria and search again. Searches are performed for all criteria entered.
This is helpful if you know the company name but not the SIREN or SIRET number.
The Company information grid displays results, if any, found in the database based on all criteria entered. The Site information grid displays a list of sites with unique SIRET numbers that share the same SIREN number. If you search by Company tax ID no. and Site tax ID no., there is only 1 result in the grid because SIRET numbers are unique for each company site. Working with search resultsThe Company information and Site information grids display results from the search of the SIRENE database. Each grid only displays up to 200 records. If there are more than 200, you need to refine your search criteria to reduce the number of results. The EU VAT no. is not part of the SIRENE database. Sage X3 calculates the number that displays in the grid.
The grids highlight fields where the data in your record and the database do not match. If a field is highlighted in yellow, the SIRENE data does not match your records. If you are creating a new BP, the columns are highlighted yellow but there are no reasons. If a row is highlighted in red, that company is listed as closed in the SIRENE database. The Reason column details why a field or fields are highlighted such as
In the Site information grid, select a site with an address that is a match for the company you want to validate. The matching company in the Company information grid is automatically selected and the Site information grid only displays the site or sites for that company. For an existing BP: If the records are different, you can select Update to overwrite the current BP record with the data from SIRENE. This action cannot be undone. Be sure it is the same BP before your update the record.
For a new BP: Selecting Update populates the new BP record with the data from SIRENE. Plan/AppointmentsIt is possible to plan an appointment/meeting from a customer record. The information relative to the customer is automatically initialized if an appointment is created with this function. The appointments displayed in the different left lists are those related to the customer. Plan/CallIt is possible to plan a call from the customer record. It will be by default an out-going call. The information relative to the customer is automatically initialized if a call is created with this function. The calls displayed in the different left lists are those relative to the customer. Plan/TaskIt is possible to plan a task from a customer record. The information related to the customer is automatically initialized if a task is created with this function. The tasks displayed in the different left lists are those relative to the customer. Create/QuoteThis function is designed to directly access the quotes object. Create/OrderThis function is designed to directly access the orders object. Create/InvoiceThis function is designed to directly access the invoices object. Create/AppointmentsThis function is designed to directly access the appointments object. Create/CallThis function is designed to directly access the calls object. Create/TaskThis function is designed to directly access the tasks object. Create/ProjectThis function is designed to directly access the projects object. Create/Service requestIt is possible to save a service request from a customer record. Create/Warranty requestIt is possible to save a warranty request from a customer record. Create/Service contractIt is possible to save a service contract from a customer record. |
Error messages
In addition to the generic error messages, the following messages can be displayed:
The four sections common to customers and business partner have the same error messages. Please refer to the Business partners documentation to know more about those messages.
The error messages specific to this function are listed below.
Non-existent address code
This message is displayed if the address code entered for the ship-to customer is not defined for this business partner.
Tables used
Refer to the Implementation documentation.