Suppliers
Use this function to maintain the Suppliers 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 supplier is also a business partner, it is defined in Business partner (BP) and in Supplier records.
Prerequisite
Screen management
- Header tab
- Identity tab
- Addresses tab
- Commercial tab
- Management tab
- Financial tab
- Ranking tab
- Bank details tab
- Contacts tab
These four sections are common to Business partner and Supplier records:
- Identity
- Addresses
- Bank details
- Contact
The information is recovered from the BP record, if this record was created before the Supplier record. You can modify it.
Any modification on one or more of these common sections is automatically saved to the Business partner table.
These sections are described in the Business partner documentation.
Header
Use this section to:
- Enter a supplier code and view its company name.
- Activate the supplier to authorize the entry of documents for their code.
From the Actions icon, on the Supplier field, click Search to open a screen where you can perform a quick search on a Supplier record, based on multiple criteria:
- The start of the company name
- The start of the postal code
- The start of the town or city name
Select Search to display the search results at the bottom of the screen.
Select Select to close this screen and return to the selected record.
| Category (BSGCOD) |
|
This is the category associated with the supplier.
|
| Active (ENAFLG) |
|
Use this field to activate or deactivate a transaction. You can enter information for a supplier in several stages and activate it when all the information is valid. You cannot create a document for an inactive supplier.
|
| Supplier (BPSNUM) |
|
Enter the supplier at the origin of the receipt. The selection lists specific to the intersite and intercompany orders and deliveries available for receipt are filtered to those related to the entered supplier. From the Selection icon, you can:
|
| field BPSNAM |
|
This field indicates the trade name of the supplier, it cannot be reached at that level. |
Identity tab
Use this section to enter the identification data for the business partner such as selecting roles and entering role-specific details.
Select the Service provider checkbox to access the Service provider info from the Actions panel, Functions menu. The term Service provider refers to an after-sales service provider you can call when all internal customer support employees are unavailable.
Select the Service caller (Order-giver) checkbox to access the Order-giver info from the Actions panel, Functions menu. The term Order-giver groups all customers for the account for which customer support services are carried out. That is, service requests that are processed for customers of our customers.
EU VAT ID validation
You can interactively validate the EU VAT no. by selecting the EU VAT ID validation icon.
Note: This includes validating GB VAT numbers.
A message box displays with the validation results. The exact content varies depending on the check result and web service used.
- If the validation is successful, you receive a confirmation message and the Validation checkbox is selected.
- If the validation failed, 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 Validation checkbox is selected.
The validation results for EU VAT IDs are stored in a table. GB VAT numbers are not stored.
If a previously-validated VAT number is modified, the Validation 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 function (EVCBAT).
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)
Block number 1
| Short description (BPRSHO) |
|
This field specifies the customer's company name. |
| Acronym (BPRLOG) |
|
BP's acronym. |
| field BPRNAM |
|
Business Partner company name. |
| Natural person (LEGETT) |
|
When it is activated, this indicator makes it possible to specify that the BP is a physical person. When it is not activated, it is a corporate entity. If the BP is a corporate entity, it is mandatory to enter the VAT ID number and the site tax ID number if their entry has been set up at country level as mandatory. |
| Mailing prohibited (BPRFBDMAG) |
| Country (CRY) |
|
This code is used to identify the Country and determines the following formats and if they are required or not for the country:
|
| Subject to tax (SUBTOTOX) |
|
For French companies, select this checkbox to assign a VAT status to an EU VAT ID number. When selected, the EU VAT ID number is required and the company cannot be a natural person. |
| Language (LAN) |
|
Enter or select the default language. |
| Currency (CUR) |
|
This code is used to identify the currency of a site, a BP, etc. It is controlled in the currency table. The currency suggested by default is the budget currency. |
| Site tax ID no. (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 (NAF) |
|
This fields displays the SIC code (subject to activity code KFA), according to the French company's activity codification. |
| REX number (REXNUM) |
| EU VAT no. (EECNUM) |
|
This is VAT identification number. The EU tax number depends on the BP country and the associated validation process. You can associate a VAT identification number according to the delivery address in function (a BP can be identified in different countries according to the VAT). |
| EU VAT ID validation (EVCVAL) |
|
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.
Successful validation results are stored in a table. If a previously-validated VAT ID is modified, the Validation checkbox is cleared. Validation levels:
Address management:
You can manually revalidate IDs using the EU VAT ID revalidation function (EVCBAT).
|
| Verified (EVCVALDON) |
|
If a previously-validated VAT ID is modified, the Validation checkbox is cleared. A message box displays with the validation results. The exact content varies by check result and web service used.
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) |
| No WL verification (WLFLG) |
|
For Polish suppliers, select this checkbox to exclude this supplier from Whitelist verification. If selected, N/A displays in the WL column in the Bank details grid for that supplier. This field only displays for Polish suppliers.
|
Intersites
| Intersite (BETFCY) |
|
Select this checkbox to indicate if this is an inter-site BP:
|
| Site (FCY) |
|
The site code for a BP within the frame of multi-site exchanges. You need to enter:
|
Roles
| Customer (BPCFLG) |
|
This field is automatically selected when the BP is a customer. |
| Sales rep (REPFLG) |
|
This field is automatically selected when the BP is a sales representative. |
| Prospect (PPTFLG) |
|
This field is automatically selected when the BP is a prospect. |
| Public sector (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 (BPSFLG) |
|
This field is automatically selected when the BP is a supplier. |
| Miscellaneous BP (BPRACC) |
|
This field is automatically selected when it concerns a miscellaneous BP. A miscellaneous BP is only used in accounting.
|
| Service supplier (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 conduct an intervention for a service request such as a repair, advice, audit, quote, and so on. For each service provider, you can register their skills, their geographic intervention area, their price list conditions for invoicing, and so on. |
| Carrier (BPTFLG) |
|
This field is automatically selected when the BP is a carrier. |
| Service caller (DOOFLG) |
|
The service caller makes a request for after-sale services. When a service request does not include Service caller, the service is supplied on behalf of the direct customer of the current organization. When a service request includes a Service provider, the service is provided to the customer by the provider. The customer receiving assistance is not the organization's customer but the contractor's. For invoicing, the data loaded by default is the contractor's, such as the invoiced customer, pay-by BP, and so on. So you need to create a customer record for the contractor. This option is also mandatory to be able to link customers to their contractor(s). |
Electronic invoicing
| Electronic invoice type (EINVTYP) |
| Select Einvoicing generation to enable e-invoices. Not used is selected by default and no other field displays in this block. In this case, e-invoices cannot be used. |
| Service code (INTSRVCOD) |
| This is an internal service code. It can be used for B2G (Business-to-Government) transactions or to construct the electronic address. |
| Routing code (RTGCOD) |
| This code is used along with the tax IDs to manage where the invoice is sent. |
| Electronic address code (ELCADD) |
| This is constructed using the tax ID, routing code, and suffix. |
| Suffix (SUFFIX ) |
| This is used along with the tax IDs to manage where the invoice is sent. |
| Email address (field ) |
| Enter the email address where e-invoices are sent. |
| Outbound mapping code (MAPCOD) |
| If you want a different value than the value in the EINVMAP - E-invoicing mapping code parameter setting at the company level (TC chapter, INV group). This refers to the UBL file and links the BP to an XML format. |
Addresses tab
Use this section to enter the business partner addresses. You need to enter at least one address. When several addresses are linked to the same BP, you must define one of them as the default address. In creation mode, the first address entered is the one suggested by default.
When entering the post code, an automatic control can be performed and the town entered depending on the settings of the CTY - Nonexistent city alert, POSCOD - Nonexistent postal code alert, and POSCODCPY - Multi-country post codes parameters (SUP chapter, INT group).
Grid
| Address code (CODADR) |
|
Address code of the business partner (BP). |
Detail
| Address code (XCODADR) |
|
This code is used to identify the various addresses associated with the managed record (user, company, site, business partner of any description, etc.). Each address code is unique to a given record. In general, it is mandatory to enter an address for each record, and one of them must be declared as the default address using the corresponding box. You cannot modify or delete an address code when it is used at the level of a Bank ID number or for a contact.
In this case, to be able to modify or delete an address code, you first need to remove it from the level of the Bank ID number or contact. |
| Description (XBPADES) |
|
Enter information linked to the address. |
| Country (XBPACRY) |
|
Enter or select the country code, managed in the Country table. The country determines certain formats including:
|
| Description (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. |
| field XADDLIG2 |
| field XADDLIG3 |
| Postal code (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 if 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 (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.
|
| 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 (XFCYWEB) |
|
Enter a website for the supplier. |
| External identifier (XEXTNUM) |
|
You can enter a stock variable identifier, which can be used for specific processing. |
| Default address (XBPAADDFLG) |
|
When selected, this checkbox indicates that this is the default address. |
Telephone
| field XTEL1 |
|
The format depends on the country. The level of control applied to the entered number format depends on the general parameter CTLTEL - Phone number control (SUP chapter, INT group). |
| field XTEL2 |
| field XTEL3 |
| field XTEL4 |
| field XTEL5 |
| field XWEB1 |
|
Enter an email address for the contact. |
| field XWEB2 |
| field XWEB3 |
| field XWEB4 |
| field XWEB5 |
Commercial tab
Use this section to enter commercial information about the selected supplier, such as:
- The ABC class of the supplier, the number under which the company is known as a supplier.
- A checkbox authorizing orders with several lines to be sent to the supplier, a checkbox used to remind the supplier that they have not sent an order acknowledgment, or that the goods have not been delivered.
- Commercial and invoicing criteria, such as a minimum order amount; original date used in the payment open item calculation, based on either the invoice date or the receipt date; the price list structure, which defines the columns for discount or charge type, that displays the commercial documents of the supplier.
- The carrier and the shipment method suggested by default in order entry.
- A location, which is used to define a location assigned to the supplier (stock at the subcontractor). A control is carried out to verify that the entered location is of the subcontractor type.
- The information required to establish the exchange of goods declaration, reported (and that can be modified) on the purchase documents (the default value used for the freight terms, the checkbox defining the default shipment location, an increase rate used by default in order to calculated the statistical value from the fiscal value).
- The availability of the delivery (unavailability periods of the supplier)
- The Order and Return checkboxes in the Texts section indicate that texts associated with the order and the return note have been created using the Text menu located at the top of the screen.
- Check boxes used to specify if you want to print the order note, receipt note, return note for the supplier.
A print template can be specified in order to associate a list of reports to use as a priority with this supplier, or group of suppliers. - 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 supplier invoicing. These elements are defined in the invoicing elements setup function.
Order
| ABC class (ABCCLS) |
|
Select a code to identify the ABC category of a business partner. The ABC category is designed to classify business partners according to their importance in the turnover, for example. Because a new business partner has no statistical data available, the default value is D. |
| Free freight threshold (WORDFREFRT) |
|
The field identifies the total purchase order amount needed to receive free freight. It is a display-only field and does not restrict POS creation. |
| field CURFREFRT |
| Minimum order (WORDMINAMT) |
|
This is the tax excl. amount below which supplier orders can be subject to a control (blocking, warning or no control). The level of control for this amount is defined by the parameter POHMINAMT - Order min amount control (ACH chapter, AUZ group). |
| field CURWORDMIN |
|
This is the folder currency. |
| Multi-line order (SEVLIN) |
|
Select this option if orders over several lines are authorized for this supplier. |
| Ack. reminder (OCNFLG) |
|
Select this option if the supplier needs to send an order acknowledgment receipt. |
| Delivery reminder (FUPFLG) |
|
Select this option if a reminder letter needs to be sent to the supplier when expected goods are not delivered. |
| Price list structure (PLISTC) |
|
Enter a price list structure code. This code determines the sales conditions managed for each purchase document line in the Discounts and charges field. The structure code is defined for one or several suppliers. At least one price list code must be set up for each structure code used by at least one BP. When a price list structure is changed, the new structure must include the previous one.
|
Receipt
| Unavailable (UVYCOD) |
|
The code represents the periods during which a BP or a site is not available, such as the annual closing period. This ensures that the proposed order date of a purchase request does not fall within these time frame. The date is calculated using the requested date minus the time necessary for the purchase. |
| Carrier (BPTNUM) |
|
This field indicates the code that identifies the Carrier liable for the transportation of the goods. |
| Delivery mode (MDL) |
|
Code checked in the Delivery modes table, and used to define the information related to the transport and delivery. |
| Location (LOC) |
|
This is the location code where the products will be transferred during the sub-contracting transfer (location change) to identify the products transferred to the sub-contractor. As far as a sub-contracting operation is concerned, the machine transferred remains the site property. To materialize the goods transfer, the dedicated locations are used. The type of these locations must be a Sub-contractor location.
The transferred quantity for sub-contracting of a product is displayed in the totals of the table Product-sites. |
| Incoterm® (EECICT) |
|
The Incoterm® codes, set by the International Chamber of Commerce, seek to standardize the terms the most used in the international commerce by defining the respective responsibilities of the seller and the buyer agreed upon on establishment of 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. |
| Intrastat increase (EECINCRAT) |
|
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. |
| Transport location (EECLOC) |
|
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.
|
| Due date origin (DUDCLC) |
|
The date used to calculate open items. It can be Invoice date or the Receipt date. |
Text
| Order (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. |
| Return (WRTNTEX) |
Discounts and charges
| No. (NOLIG) |
| Element (INVDTA) |
|
Number of the invoicing element identifying the associated amount, charges, freight, packing, discount, in percentage or in amount, and so on. |
| Description (SHO) |
|
This field indicates the short title of the invoicing element. |
| % or amount (INVDTAAMT) |
|
This is the information related to the invoicing footer. The displayed invoicing elements come from the supplier category. When the invoicing elements are entered and have a default value, this value is retrieved and converted into the supplier currency. The type of supplier credit and the system's current date are used. |
| Currency (WWCUR) |
|
This field indicate the supplier currency in which the amount is expressed. |
Reports
| Order form (NORPRNFLG) |
|
Select this checkbox if order notes need to be printed for this supplier. |
| Receipt note (NREPRNFLG) |
|
Select this checkbox if the receipt notes need to be printed. |
| Return slip (NRTPRNFLG) |
|
Select this checkbox if return notes need to be printed. |
| Template code (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 need 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. |
Management tab
Use this section to enter management information, such as:
A Payment hold checkbox that can be used to forbid payments in case of a major dispute, including on invoices that are good to pay.
The type, which can have the following values Normal, Prospect, Miscellaneous. The Prospect type is only used when sending requests for quotes to the supplier. The Miscellaneous type is used to trigger the automatic opening of an address entry window for all commercial documents (these are 'cover-all' suppliers that are not distinguished in accounting). The default category is Normal.
The customer number assigned to the company by the supplier. This is for information only.
The rate type (local menu where the standard values are editable) used to determine which rate will be used by default to find the currency conversion rate for the posting of invoices.
The authorized credit level, for a financial site and the actual credit level for the company at the supplier (this is used to control in real-time the entry of an order with the authorized credit level). The credit control is conditioned by the value of the corresponding checkbox: No control means that no control is made even if the credit level is updated, Hold means that all orders to the supplier have been blocked, Control means that the control will be carried out.
Based on the OSTSCTL - Credit control level parameter (TC chapter, OST group), the credit control can be performed by company or by folder.
Based on the OSTCHGTYP - Rate origin WIP ctrl. parameter (TC chapter, OST group), it can be performed for an historical rate or revised rate. If this control applies to a revised rate, the OSTTYPCUR - Rate type updated rate ctrl parameter (TC chapter, OST group) provides the type of rate that should be used. When the level of the control on credit is Folder, the control is always processed based on the revised rate, regardless of the value of the OSTCHGTYP parameter.
The supplier credit amount is calculated in the following way: In order + Delivered not invoiced + Invoiced not posted + Accounting balance + Notes P/R (according to parameter OSTSDRAFT - Supplier credit notes P/R amount (TC chapter, OST group)).
The credit is controlled according to the supplier's risk BP. If the risk BP is shared by several suppliers, the company's credit will be controlled the same way according to the risk BP by cumulating all the movements carried out for the various suppliers.
The authorized credit amount cannot be accessed when the supplier is associated with a different risk BP. It can be viewed on the risk BP record. The displayed WIP is the risk BP.
A dispute status, which is used to warn the user during purchase request entry, order entry or invoice entry, or to block any new entry.
A free text that will be displayed during order entry.
The free statistical groups used in the statistics, but also as selection criteria in certain automatic processes.
You can communicate autoinvoice series to the Portuguese fiscal authorities via the webservices. The fields needed to communicate the series in ATCUD management display when you select the Autoinvoice agreement checkbox. In these fields you can enter the Agreement number generated from the "Portal das Finanças" and the type of autoinvoice.
Miscellaneous
| Supplier type (BPSTYP) |
|
This field is used to identify the supplier type:
|
| Our customer no. (BPCNUMBPS) |
|
This optional field makes it possible to define a supplier code for the company on the customer system. |
| Rate type (CHGTYP) |
|
This is the rate type used to determine the default rate to determine the posting rate of purchasing documents. You can modify the standard values. |
| Matching tolerance (MATTOL) |
|
Use this field to specify a match code for the current supplier. This match code comes from the Matching tolerance function. For any new supplier, this field inherits from the code defined at the level of the associated supplier category. This code can be modified. The three-way match is a reconciliation process used to validate the payment of an invoice, with a minimum and a maximum tolerance threshold. The reconciliation is carried out:
|
| Auto invoice code (AUTINVCOD) |
|
This field is used to indicate a value intended to complete the counter used for invoices generated in a self-invoicing process. It is indeed necessary to have a unique sequential number by supplier. This value is mandatory if you create an invoice for this supplier, in a self-invoicing process. |
| Autoinvoice agreement (SLFINVFLG) |
| Select this checkbox if the supplier is a Portuguese company with an agreement number from the "Portal das Finanças." When you select this checkbox, the next two fields display. |
| Agreement number (SLFINVCOD) |
|
Enter the agreement number generated from the "Portal das Finanças." Only an official number can be used.
|
| Autoinvoice supplier type (SLFINVTYP) |
|
Enter or select one of the following:
|
Credit
| Credit control (OSTCTL) |
|
This field is used to enter the control type chosen for the credit level and to check whether the orders risk to be block or not for financial reasons. |
| Authorized credit (WOSTAUZAMT) |
|
This is the amount of the maximum authorized credit level by the supplier. It is used if the credit level is set to the checked value. This amount must be expressed in the currency of the folder.
|
| field ACCCUR |
| Credit level total (OTAMT) |
| Payment hold (PAYLOKFLG) |
|
Select this checkbox if payments for this supplier are blocked. If they are blocked, invoices coming from this supplier are not included when processing automatic payments. |
| Dispute (DOUFLG) |
|
In entry, when in dispute with the supplier, specify the behavior of:
Use this field to define how to manage a dispute from this supplier:
This field does not apply to invoices entered using the Supplier BP invoices function.
|
Notes
| Supplier notes (BPSNOTE) |
|
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 TSSCOD |
|
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. |
Electronic invoice
| Default invoicing module (INVORIMOD) |
| Electronic invoice (ELECTINV) |
| Contact (CNTEFAT) |
| Start date (STRDATEFAT) |
Financials tab
Use this section to enter financial or accounting information such as:
The bill-to business partner, the pay-to business partner and the group supplier.
The risk BP, on which the calculation of the supplier's financial credit is based.
A DAS2 checkbox is used to indicate whether this supplier is likely to invoice services that must be declared for DAS2 (France). This criteria is not the only once taken into account, because this also depends on the account used for each charge line and also the information is modifiable on the invoice line. In this case, a service provider code identifies the supplier for DAS2.
The tax rule and the exemption number in case of a partial exemption.
The payment terms, an early discount/late charge code that is used to define charge rates for late payments and discount rates for early payments, a default payment bank that will be used to pay the supplier, as well as the accounting code, which is used to give the accounting characteristics for the entries linked to the supplier (purchase invoices, fixed asset invoices, invoices to be received, prepayments made, notes P/R to be paid, etc.) by defining control accounts, accounts, or even sub-accounts used by default in the automatic journals.
Analytical dimensions for each dimension type, which can be used as the default value in the different documents linked to the supplier management, using the corresponding setup.
BPs
| Bill-by BP (BPSINV) |
|
This field is used to enter the invoicing supplier code, initialized by default to the supplier code entered in the header. The supplier can be another supplier chosen from the supplier table. |
| field BPAINV |
|
This field is used to indicate an invoicing address code for the selected invoicing supplier. The address by default of this supplier is suggested. When entering the invoice, this address code is suggested. This code is modifiable if necessary. |
| Pay-to (BPRPAY) |
|
This field is used to enter the code of the supplier to pay, initialized by default to the supplier code entered in the header. The supplier can be another supplier chosen from the supplier table. The pay-to BPs are either suppliers or miscellaneous BPs. |
| field BPAPAY |
|
This field is used to indicate an invoicing address code for the selected paid supplier. The address by default of this supplier is suggested. |
| Supplier group (BPSGRU) |
|
This supplier group code, initialized by default with the supplier code entered in the header. |
| Risk BP (BPSRSK) |
|
This field is used to specify whether the BP code risks to be initialized with the invoicing supplier, the paid BP or the BP group (depending on the common data setup INIBPRRSK). This code can be manually modified. The credit control is carried out for this supplier. |
| Accounting code (ACCCOD) |
|
This field is used to specify the supplier accounting code. |
| Account structure (DIA) |
|
The account structure is not compulsory data. If a structure is loaded, it is submitted to be applied upon the creation of a supplier invoice (once the invoice tax excl. amount has been entered). |
| Payroll interface distribution (BPRDSP) |
| DAS2 (DADFLG) |
|
When this box is checked, it indicates that the supplier is a contractor within the framework of the DASD2 declaration (French procedure). |
| 281.5 (FLG281) |
| Service supplier code (PRVNUM) |
|
This information is used to extract the fee lines (linked to a service supplier), the accounting postings (linked to a supplier), in order to generate the DADS. If the Service supplier field is empty, the Service supplier code is the same as the supplier code. |
| 1099 form (FRM1099) |
|
The 1099 form type indicates that a supplier is reportable to the Internal Revenue Service for payments made. Possible valid values are: None. Misc, Dividend or Interest. This value defaults from the supplier to the invoice, but can be changed. |
| 1099 box (BOX1099) |
|
Default box number with respect to which payments must be printed on the 1099 record. Box numbers vary according the 1099 record at use. This value defaults from the supplier to the invoice, but can be changed. Inactive 1099 boxes are not available for selection. |
Analytical grid
| Dimension type (DIE) |
|
This grid is automatically loaded with the default dimension types associated with the basic supplier data. |
| Dimension (CCE) |
|
An analytical dimension is an element of the analytical chart of accounts on which accounting entries can be posted. Each analytical dimension type represents a specific division of the company into a set of analytical payment attributes. An analytical dimension is thus an analytical payment attribute within a dimension type. |
Payment
| Payment term (PTE) |
|
Enter the code associated by default to the current BP and used to define the payment conditions.
When managing this table, it is possible to simulate the calculation rules applied in entry mode. |
| Settlement discount (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 (PAYBAN) |
This code is controlled in the Bank accounts field.
|
| Expense allocation (IPTEXS) |
|
This field is used to define the distribution of bank expenses between the issuer and the beneficiary. At the end of the process, this information is given in the generated bank files. See the documentation on charges posting of the Bank accounts function for more information on bank charges.
The following codes are suggested:
|
Withholdings
| Withholding code (RITCOD) |
|
List of retention codes to be applied to the supplier. |
Taxes
| Tax rule (VACBPR) |
|
A tax rule represents the tax territoriality principle, in other words, the calculation rules to be applied to determine the tax amount. As a general rule, by crossing a tax rule linked to the BP with a Tax level, you can determine the tax code to be applied to the document line and so, to the entry line. In this field, you enter the tax rule associated with the BP: this tax rule will be suggested by default in all the transactions used by this business partner. |
| Amount type (PURPRITYP) |
|
This flag is used to determine whether the amounts of the supplier BP invoices Exclude tax or Include tax. It is initialized from the supplier category value. |
| VAT collection agent (AGTPCP) |
|
This field is used to specify if the supplier is also the tax receiver. This information depends on the Argentinian legislation.
|
| Regional taxes (AGTSATTAX) |
|
Select this checkbox to specify that the provincial taxes must be applied to the selected customer. The regional tax grid can then be accessed. It is only about the management of BP invoices. The regional taxes from the sales and purchase modules are managed via the Tax determination function. |
Withholding tax
| Allowance rate (RITRAT) |
|
Special allowance rate specific to the supplier. |
VAT Spain
| Cash VAT tax rule (CSHVAT) |
| Cash VAT limit date (CSHDAT) |
Table number 4
| Name of partner (RITPARNAM) |
| Partner held (RITPARCOE) |
|
No help linked to this field. |
Regional taxes
| Province (SATTAX) |
| Description (DESSAT) |
|
This is the title of the province. |
| Application (TYPAPL) |
|
This field is used to define whether the tax applies upon entry in the region, upon exit, or always. |
| Collection (FLGSATTAX) |
|
This field is designed to specify if the customer is a tax collector for this provincial tax. |
Ranking tab
Use this section to enter notes (ranking) on the supplier quality for information purposes. The different rankings are weighted according to coefficients in order to obtain a general ranking.
Block number 5
Ranks and weighting
| Notes (TEXT0) |
| Coefficients (TEXT1) |
| Lead time (LTIMRK) |
|
This is the mark given to the supplier for the respect of lead times. |
| field LTIMRKCOE |
|
Coefficient applied to the assigned note for the lead-time adherance for this supplier. This coefficient is initialized by default to a value given to this coefficient in the supplier category table. |
| Price (PRIMRK) |
|
This is the mark given to the supplier for respecting the price list |
| field PRIMRKCOE |
|
Coefficient applied to the assigned grade for price compliance for this supplier. This coefficient is initialized by default to a value given to this coefficient in the sup
plier category table. |
| Quality (QLYMRK) |
|
Grade given to the supplier for quality compliance for this product. |
| field QLYMRKCOE |
|
Coefficient applied to the grade assigned for quality compliance for this supplier. |
| Quantity (QTYMRK) |
|
This is the mark given to the supplier for respecting quantities. |
| field QTYMRKCOE |
|
Coefficient applied to the grade assigned for quantity compliance for this supplier. This coefficient is initialized by default to a value given to this coefficient in the
supplier category table. |
| Free (RSKMRK) |
|
This is a mark given to the supplier according to free criteria. |
| field RSKMRKCOE |
|
Coefficient applied to the grade assigned according to a criterion left free for this supplier. This coefficient is initialized by default to a value given to this coeffici
ent in the supplier category table. |
| Total rank (field GENMRK) |
Grid
| Identifier (field ID) |
|
This is the grid line used as a basis for the graph that contains the notes. |
| Description (DESMRK) |
|
This field indicates the title of the grid line. |
| Lead time (LTIMRKVAL) |
| Price (PRIMRKVAL) |
| Quality (QLYMRKVAL) |
| Quantity (QTYMRKVAL) |
| Free (field RSKMRKVAL) |
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.
Grid
| Addr. (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 (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 (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.
|
| Bank account number (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 (BIDNUMFLG) |
|
This field indicates that the Bank ID number is used by default for payments (in the absence of a more precise rule). |
| WL (WLISTA) |
|
This field displays the Whitelist status for the supplier as follows:
|
| Curr. (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. (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). See the Swiss legislation guide for more details regarding payment and ISR setup.
|
| Paying bank (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 (BNF) |
|
This field identifies the bank account's beneficiary (physical or moral person). |
| Paying bank 2 (PAB2) |
| Paying bank 3 (PAB3) |
| Paying bank 4 (PAB4) |
| BIC code (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 namely 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 (MIDPAB2) |
| Paying bank 2 (MIDPAB3) |
| Paying bank 3 (MIDPAB4) |
| BIC code (MIDBICCOD) |
| Country (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.
There are 2 methods for creating a 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 of the information is considered as being professional.
For more examples, see the Contacts function documentation.
Grid
| Contact code (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 (CNTLNA) |
|
Indicate the family name of the contact. |
Detail
| Contact code (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 (KCNTTTL) |
|
This information can be used on documents to be sent to contacts. |
| Last name (KCNTLNA) |
|
Indicate the family name of the contact. |
| First name (KCNTFNA) |
|
First name of the contact. |
| Function (KCNTFNC) |
|
This field specifies the position of the contact to choose from a predefined list. |
| Department (KCNTSRV) |
|
This text field indicates the department to which the contact is attached. |
| Role (KCNTMSS) |
|
This field, used for information purposes, makes reference to the codes entered in miscellaneous table 906. |
| Language (KCNTLAN) |
|
This fields specifies the language of the contact. |
| Date of birth (KCNTBIR) |
|
Birthday of the contact, only present for information reasons. |
| Category (KCNTCSP) |
| Address (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 (KCNTWEB) |
|
This field is used to specify the email address of the contact. |
| Telephone (KCNTTEL) |
|
This field indicates the phone number. Its entry format depends on the country. |
| Fax (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 (KCNTMOB) |
|
This field indicates the mobile phone number with an entry format that depends on the country. |
| Mailing prohibited (KCNTFBDMAG) |
|
This indicator is designed to specify that the contact cannot be selected in a mailing. |
| Default contact (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 :
BPS1 : Supplier record
PURFCS : Purchase costs
BPSUPPLIER : Supplier listing
This can be changed using a different setup.
Specific buttons
|
Products |
Select this action to access the inquiry related to the Product-supplier record.
|
Menu bar
Notes P/R not due 1You can manage up to three notes payable/receivable, for distinct purposes. This is defined at the payment transaction setup level: on the Steps section, you can choose, define and update a note payable/receivable when an intermediate posting is performed. Notes P/R not due 2Notes P/R not due 3Extensions |
OrdersSelect this action to view the orders for this specific supplier. Order lineSelect this action to view the order lines for this specific supplier. ReceiptsSelect this action to view the receipts for this specific supplier. Receipt lineSelect this action to view the receipt lines for this specific supplier. InvoicesSelect this action to view the invoices for this specific supplier. Invoice lineSelect this action to view the invoice lines for this specific supplier. ReturnsSelect this action to view the returns for this specific supplier. Return lineSelect this action to view the return lines for this specific supplier. Accounting / AccountsSelect this action to access the supplier account management (including all control accounts by default). Accounting / BP situationSelect this action to view the global situation of the supplier, with regards to their schedule, financial and commercial credit levels, and last operations performed for this supplier. Accounting / Risk analysisSelect this action to display the BP situation when directly positioned on the information relative to the supplier financial risk. Accounting / Last operationsSelect this action to display the BP situation when directly positioned on the information relative to the last operations carried out for this supplier. Accounting / Aged balanceSelect this action to access the aged balance of the supplier at the given date. |
Create orderSelect this action to directly access the Order creation function. You can thus view the selection list of performed orders or orders to be performed for the selected supplier. If you click New, the order is pre-entered with the supplier information. The order is then considered as a performed order. Create invoiceSelect this action to directly access the Invoice creation function. You can thus view the selection list of completed invoices or invoices to be completed for the selected supplier. If you click New, the invoice is pre-entered with the supplier information. The invoice is then considered as a completed invoice. |
|
Select this option to check if the supplier's bank account is on the Whitelist. The status and verification date display in the WL column in the Bank details grid as follows:
|
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 300 records. Use the IDVSZ - BP ID validation sizing activity code to define the number of registers displayed in the grid. The default is 300.
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 grids display the full company and site addresses. 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. Address managementThe Site information grid includes the Update address column. To update an address, you can enter or select an address code for the site on the line. If you're adding a new address, you also need to enter a unique address code. The code can contain up to 5 characters. A code is required to update the address. The comparison with the SIRENE database only concerns the default address.
After confirming the new address and code, these are added to the BP record. |
Local menus
In addition to the generic error messages, the following messages can appear during the entry :
The supplier is not activeThis message is displayed when entering the Invoicing BP field when the chosen business partner is a supplier declared as Non active in the corresponding record.
Price structure is not identicalThis message is displayed when entering the Invoicing BP field when the price list structure code associated with the chosen supplier is not identical with that of the supplier being processed. In fact, when the invoicing supplier is different or the supplier in the order, it is imperative that the price list structure that determines the make up of the price is strictly identical in order to avoid any consistency problems during the invoice control.
Tables used
Refer to documentation Implementation