Sales Reps
A sales representative is a business partner (BP). It is identified in the business partner (BP) table as well as in the sales representative table. You maintain the sales representative table and its associated tables: BP and Addresses. You can create, query, and update information specific to a rep as well as those associated with the BP.
You can access this function from the BP function (GESBPR).
Prerequisite
Refer to documentation Implementation
Field help
This section describes the field help for each tab or section.
A sales representative is created with the help of a maximum of three tabs. Two of these tabs come from the BP record that has previously been created. The Identity and Addresses tabs are common to both the BP and Sales representative records. Any modification made on one or more of these common tabs is automatically saved in the BP table. In all cases, all the tabs are accessible at the level of the sales representative record.
The two tabs common to the BP management and the sales representative management are described in the BP documentation. The tab belonging to the sales representative management itself is described below.
Header
Sales rep (field REPNUM) |
Code identifying the sales representative that can be directly entered or chosen from the sales representative table. |
X3 user (field REPUSRX3) |
This box is automatically selected when the sales rep is identified as a Sage X3 user.
|
Identity tab
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 recorded (on creation/update) in the connection language of the user.
A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language. The connection language needs to be the default language for the folder. |
Acronym (field BPRLOG) |
BP acronym. |
field BPRNAM |
Business partner company name. |
Natural person (field LEGETT) |
When selected, it means the BP 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 company. |
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 for a site, BP, etc. It is managed in the currency table. Use the ISO coding when creating a new currency. |
Site tax ID no. (field CRN) |
Unique identification number for the company.
Its 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 the VAT identification number of the BP or the GB VAT number. This European VAT number must be entered on all the invoices destined to or coming from the European Union. This number starts with two letters identifying the business partner country followed by a number depending on the country. In France the number is comprised of FR, then 2 numbers identifying the tax office of the place where the company conducts its activities, followed by the Company tax ID no. (SIREN) of the company. This information must be entered if the Company registration number is set up as being mandatory for the country of the company. |
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 Validation check box 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 Validation check box 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) |
This flag is designed to indicate if this is an inter-site BP:
|
Site (field FCY) |
Site code that has to be identified as a BP within the frame of multi-site exchanges. The following data need to be entered:
|
Roles
Customer (field BPCFLG) |
Sales rep (field REPFLG) |
Prospect (field PPTFLG) |
Supplier (field BPSFLG) |
Miscellaneous BP (field BPRACC) |
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) |
Service caller (field DOOFLG) |
The contractor represents the actual customer for whom a service request is made. |
Tab Addresses
Grid Addresses
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 managed record (user, company, site, business partner of any description, etc.).
You cannot modify or delete an address code when it is used at the level of a Bank ID number or for a contact. |
Description (field XBPADES) |
Specify the information linked to the address. |
Country (field XBPACRY) |
This code is used to identify the country associated with the address. In the Country table, which controls this field, some specific characteristics are used to perform controls on the related information, in particular:
|
Description (field XCRYNAM) |
Title associated with the previous code. |
field XADDLIG1 |
This table lists the various address lines. The formats of the title and of the entry are defined in the country table. |
Postal code (field XPOSCOD) |
The postal code, which entry format is defined in the Country table, is used to define the town/city, state/region and the geographical subdivision, if defined for the country. Particular cases: - for ANDORRA, indicate 99130, When the postal code is defined as mandatory for the country, it must be entered if the Postal Code or City/town fields are entered, or if information is modified in the BP address window. However, this control is not applied in document creation. |
City (field XCTY) |
The city automatically suggested is the one associated with the postal code previously indicated. It is also possible to manually enter the name of a town/city: Notes.
|
field ITINERAIRE |
Click this icon 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. For example, a 'department' for France, and a state for the United-States. The description of the geographic subdivision, as well as the control on the information entry, are defined in theCountries setup. This field loads automatically after the postal code and town/city have been entered and is based on the Postal codes setup. |
Website (field XFCYWEB) |
This field is used to indicate a web site. |
External identifier (field XEXTNUM) |
This free field makes it possible to stock a variable identifier, which can be used for specific processing. |
Default address (field XBPAADDFLG) |
When selected, this check box indicates that this is the default address. |
Telephone
field XTEL1 |
This field indicates the phone number. Its entry format depends on the country. |
field XWEB1 |
This field is used to specify the email address of the contact. |
Tab General
All the information related to the commission method for the sales representative is to be entered. It is firstly necessary to define the commission basis. The choice is between the net price (discounted price), the margin (net price - production cost) and a formula. If a commission basis with a formula is chosen, it will be necessary to then associate a formula code with each role of this sales representative in an invoice (principal or secondary sales representative).
Once the commission basis is determined, on or two commission rates will be associated with the sales representative by commercial category. The first rate corresponds to the rate of the sales representative when they are the principal sales representative on an invoice, the second rate corresponds to the sales representative when they are the secondary sales representative on an invoice.
The commercial category corresponds to correlation with the customers. In fact this information is present in each customer record. If a sales representative is assigned to an invoice involving a customer, their rate will depend on the Customer category. The commercial category is a local menu that can be set up (local menu 403).
The rule for the assignment of the sales representative in the sales cycle is as follows. A sales representative may be associated with a customer or with a shipment address for this customer. If a sales representative is assigned to the customer, they will always have priority over the sales representative associated with the shipment address.
Regarding the commission rules, it is possible to weight the commission rate for the sales representative on each line of an invoice by entering a weighting coefficient. This weighting coefficient can be determined according to certain management rules. These rules are defined in the price list setup function.
The calculation of the commission that must be given to the sales representatives is carried out by means of the COMREP report.
This tab is also used to enter the accounting information such as the accounting code, which is used to provide the accounting characteristics of the postings linked to the sales representative by defining the control accounts, the accounts, even the parts of the accounts used by default in the automatic journals and the analytical dimension for each dimension type, used as default value in the different documents in the sales cycle, thanks to the corresponding setup.
Each sales representative has a "Function" field. If this field is entered, it signifies that the sales representatives record has been created at the same time as a user record: the "Function" is indicated at the level of the user parameter AUSCRMA - Function (CRM chapter, COL group). The function conditions the access to certain fields in the CRM section:
- "User code":
This field is entered only if the sales rep is a Sage X3 user. It indicates the user code to which the sales rep is linked (AUSCRMF - Sales rep parameter - CRM chapter, COL group). - "Daily call objective":
This field is only accessible for the sales representatives whose function is "Tele-sales".
It is used to indicate the daily calls objective assigned to a telesales person. This field is very important to ensure the correct functioning of the call campaign distribution processes. - "Number of late calls":
This field displays the total number of late calls in the employee workbench. This information is principally designed for the service managers in order to measure any overloads imposed on the employees. - "Sales site":
This field indicates the site from which the sales representative manages most of their commercial activates.
Block number 1
Commission base (field COMBAS) |
Flag designed to determine the commission basis used when calculating the sales representative's commissions. |
Commission formula 1 (field COMFOR1) |
Code of the formula controlled in the formulas table and designed to determine the commission basis of the sales rep when this one is entered in the first row of the invoice. |
Commission formula 2 (field COMFOR2) |
Code of the formula controlled in the formulas table and designed to determine the commission basis of the sales rep when this one is entered in the second row of the invoice. |
Grid Commission rate
No. (field NOLIG) |
Sales categories (field COMSDI) |
Comm rate 1 (field COMRAT1) |
Commission rate of the Sales rep entered in the first invoice row. |
Comm rate 2 (field COMRAT2) |
Commission rate of the Sales rep entered in the second invoice row. |
Financials
Accounting code (field ACCCOD) |
Use this field to specify the accounting code of the site. |
Customer relation
User code (field AUSNUM) |
This field which cannot be entered, is used only if the sales rep is a Sage X3 user. It indicates the user code to which the sales rep is linked (AUSCRMF - Sales rep parameter - CRM chapter, COL group). |
Daily call objective (field OBJCLL) |
This field concerns only tele-marketers. |
No. of late calls (field CLLDEL) |
This field displays the total number of calls that are late by sales representative.
|
Sales site (field FCY) |
This field represents the site from which the sales representative conducts their commercial activity. |
Grid Analytical
Dimension type (field DIE) |
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. 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. |
Function
Function (field FNC) |
By default, this field contains the value "Other". The setup used to indicate that the sales rep is a Sage X3 user is provided at the level of the field help "X3 Users". |
Reports
By default, the following reports are associated with this function :
SALESREP : Sales rep listing
This can be changed using a different setup.
Menu Bar
This menu is used to view the sales representative account (all control accounts together by default). The account inquiry allows multiple zooms/tunnels according to the case. User informationIf the sales representative record has been created from a user record, the Sales representative contains a contextual menu named User information. This menu is used to access the user record associated with the sales representative record. The additional information stored in the CRM tab can then be viewed. Sales representative searchBecause of the potentially large number of sales representatives in a commercial database, possessing a rapid and ergonomic tool to access a record is highly recommended. In fact, it quickly becomes difficult to remember the key for each record. Thus the Sales representative field provides an accelerated search function of a Sales representative record available from the contextual search menu Search. The following searches are possible: 1 / Search on the start of the company name. The lower section of the screen displays the results of each search. A search is renewed at the time of each tabulation carried out on one of these criteria. NB : The search is carried out on on the Sales representative population. A click on the Select button closes the window and qualifies the Sales representative with the key of the selected sales representative. A tab on the Sales representative field is used to display the selected sales representative record. Deletion of a sales representativeIf a sales representative record is associated with a user record, it cannot be deleted. The deletion of such a sales representative record is only possible by means of the deletion of the associated user record. |