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
Refer to the documentation on Implementation
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 in order 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/city name
Click Search to display the search results at the bottom of the screen.
The search is carried out on the supplier base.
Sselect Select to close this screen and return to the selected record.
Category (field BSGCOD) |
This is the category associated with the supplier.
|
Active (field ENAFLG) |
This field is used to activate or deactivate a transaction. |
Supplier (field 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 check box 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 check box is selected.
Note: 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 check box 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 (field BPRSHO) |
This field specifies the customer's company name. |
Acronym (field BPRLOG) |
BP's acronym. |
field BPRNAM |
Business Partner company name. |
Natural person (field 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 body. |
Mailing prohibited (field BPRFBDMAG) |
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. |
REX number (field REXNUM) |
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 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 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) |
No WL verification (field WLFLG) |
For Polish suppliers, select this check box to exclude this supplier from Whitelist verification. If selected, N/A displays in the WL column in the Bank details grid for that supplier. Note: This field only displays for Polish suppliers.
|
Intersites
Intersite (field BETFCY) |
This flag is designed to indicate if this is an inter-site BP:
|
Site (field FCY) |
The site code for a BP within the frame of multisite exchanges. The following data need to be entered:
|
Roles
Customer (field BPCFLG) |
This field is automatically ticked when the BP is a customer. |
Sales rep (field REPFLG) |
This field is automatically ticked when the BP is a sales representative. |
Prospect (field PPTFLG) |
This field is automatically ticked 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 ticked 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 checked 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
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 (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) |
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 formats of the title and of the entry 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 supplier. |
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 this is the default address. |
Telephone
field XTEL1 |
The format depends on the country. |
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 check box 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 check boxes 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 (field ABCCLS) |
Select a code to identify the ABC category of a business partner. |
Free freight threshold (field 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 (field 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 (field SEVLIN) |
Select this option if orders over several lines are authorized for this supplier. |
Ack. reminder (field OCNFLG) |
Select this option if the supplier needs to send an order acknowledgment receipt. |
Delivery reminder (field FUPFLG) |
Select this option if a reminder letter needs to be sent to the supplier when expected goods are not delivered. |
Price list structure (field 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 (field 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 (field BPTNUM) |
This field indicates the code that identifies the Carrier liable for the transportation of the goods. |
Delivery mode (field MDL) |
Code checked in the Delivery modes table, and used to define the information related to the transport and delivery. |
Location (field 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. |
Incoterm (field 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 establishement 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 (field 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 (field 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 (field DUDCLC) |
The date used to calculate open items. It can be Invoice date or the Receipt date. |
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. |
Return (field WRTNTEX) |
Discounts and charges
No. (field NOLIG) |
Element (field INVDTA) |
Number of the invoicing element identifying the associated amount, charges, freight, packing, discount, in percentage or in amount, and so on. |
Description (field SHO) |
This field indicates the short title of the invoicing element. |
% or amount (field INVDTAAMT) |
This is the information related to the invoicing footer. The displayed invoicing elements come from the supplier category. |
Currency (field WWCUR) |
This field indicate the supplier currency in which the amount is expressed. |
Reports
Order form (field NORPRNFLG) |
Select this checkbox if order notes need to be printed for this supplier. |
Receipt note (field NREPRNFLG) |
Select this checkbox if the receipt notes need to be printed. |
Return slip (field NRTPRNFLG) |
Select this checkbox if return notes need to be printed. |
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. |
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 conditionned by the value of the corresponding check box: 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.
Miscellaneous
Supplier type (field BPSTYP) |
This field is used to identify the supplier type from amongst the following:
|
Our customer no. (field BPCNUMBPS) |
This optional field makes it possible to define a "supplier code" for the company on the customer system. |
Rate type (field 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 (field MATTOL) |
Use this field to specify a match code for the current supplier. Reminder: 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 (field 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. |
Credit
Credit control (field 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 (field 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. |
field ACCCUR |
Credit level total (field TOTAMT) |
Payment hold (field 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 (field 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 (field BPSNOTE) |
Select this icon to:
Notes are limited to a screen inquiry and cannot be printed. For further 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 (field INVORIMOD) |
Grid CAI assignment
Type (field TYPDOC) |
CAI number (field CAI) |
This field indicate the number root. |
Validity date (field DATVLYCAI) |
This field indicates the validity date of the root, which is provided by the admin. |
Tab Financials
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 check box 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 (field BPSINV) |
This field is used to enter the invoicing supplier code, initialized by default to the supplier code entered in the header. |
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 (field 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 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 (field BPSGRU) |
This supplier group code, initialized by default with the supplier code entered in the header. |
Risk BP (field 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). |
Accounting code (field ACCCOD) |
This field is used to specify the supplier accounting code. |
Account structure (field DIA) |
The account structure is not compulsory data. |
Payroll interface distribution (field BPRDSP) |
DAS2 (field 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 (field FLG281) |
Service supplier code (field 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. |
1099 form (field 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 (field 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. |
Grid Analytical
Dimension type (field DIE) |
This grid is automatically loaded with the default dimension types associated with the 'Supplier' basic data. |
Dimension (field 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 (field PTE) |
Enter the code associated by default to the current BP, used to define the payment conditions.
When managing this table, it is possible to simulate the calculation rules applied in entry mode. |
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 Bank accounts field. |
Expense allocation (field 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. The following codes are suggested:
|
Withholdings
Withholding code (field RITCOD) |
List of retention codes to be applied to the supplier. |
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. |
Amount type (field 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 (field AGTPCP) |
This field is used to specify if the supplier is also the tax receiver. |
Regional taxes (field AGTSATTAX) |
Once checked, this box is used to specify that the provincial taxes must be applied to the selected customer. |
Withholding tax
Allowance rate (field RITRAT) |
Special allowance rate specific to the supplier. |
VAT Spain
Cash VAT tax rule (field CSHVAT) |
Cash VAT limit date (field CSHDAT) |
Name of partner (field RITPARNAM) |
Partner held (field RITPARCOE) |
No help linked to this field. |
Regional taxes
Province (field SATTAX) |
Description (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 (field FLGSATTAX) |
This field is designed to specify if the customer is a tax collector for this provincial tax. |
Tab Ranking
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 (field TEXT0) |
Coefficients (field TEXT1) |
Lead time (field 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. |
Price (field 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. |
Quality (field 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 (field 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. |
Free (field RSKMRK) |
This is a maken 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. |
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 (field DESMRK) |
This field indicates the title of the grid line. |
Lead time (field LTIMRKVAL) |
Price (field PRIMRKVAL) |
Quality (field QLYMRKVAL) |
Quantity (field QTYMRKVAL) |
Free (field RSKMRKVAL) |
Block number 3
Block number 4
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.
Grid
Addr. (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. |
Bank account number (field BIDNUM) |
This number identifies the bank account of a given bank, for a given country. For the entry of the Bank ID number to be correct, it is necessary to predefine the entry format in the Country table and to activate the option IBAN management for those countries supporting the IBAN format.
In case of an IBAN this field has to contain the bank account part only, beginning from the 5th character of the IBAN. The first 4 characters of the IBAN (country code and check digits) are calculated automatically and displayed in the field IBAN pref. |
Default (field BIDNUMFLG) |
This field indicates that the Bank ID number is used by default for payments (in the absence of a more precise rule). |
WL (field WLISTA) |
This field displays the Whitelist status for the supplier as follows:
|
Curr. (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.
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 further examples, see the documentation of the Contacts function.
Grid
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) |
Indicate 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 :
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 |
OrdersClick this action to view the orders for this specific supplier. Order lineClick this action to view the order lines for this specific supplier. ReceiptsClick this action to view the receipts for this specific supplier. Receipt lineClick this action to view the receipt lines for this specific supplier. InvoicesClick this action to view the invoices for this specific supplier. Invoice lineClick this action to view the invoice lines for this specific supplier. ReturnsClick this action to view the returns for this specific supplier. Return lineClick this action to view the return lines for this specific supplier. Accounting / AccountsClick this action to access the supplier account management (including all control accounts by default). Accounting / BP situationClick 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 analysisClick this action to display the BP situation when directly positioned on the information relative to the supplier financial risk. Accounting / Last operationsClick 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 balanceClick this action to access the aged balance of the supplier at the given date. |
Create orderClick 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 invoiceClick 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. |
Click 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 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. |
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