Chapter 02
Customers
The record for private and business customers, tax numbers for customers from any country, checking EU VAT numbers in VIES, and merging records of the same customer. Look here when you create a customer or tidy up the database after an import.
6 articles · 5 ready
Articles in this chapter
- 01Customer record — private individual and companyThe form changes its fields depending on who is buying, and enforces only the data without which a document can’t be issued. We describe what’s required, what’s worth filling in straight away and what can wait.
- 02Company details and tax numbersWhich numbers a business customer’s record needs depends on where the customer is registered. We explain the fields for EU and non-EU companies, the representative who signs the contract, and where these details end up.
- 03Checking an EU VAT number in VIESVIES is the European Commission’s system for checking EU VAT numbers. If your company is based in the EU, you check a business customer’s number in it straight from the customer form. We cover what the check shows, what VIES doesn’t know and what to do when it doesn’t respond.
- 04Merging duplicate customersThe same customer ends up in the database twice surprisingly often — once after a phone call, once after a showroom visit. We show how the system detects such pairs, how to combine the records into one and how to undo a merge.
- 05Importing your database from ExcelComing soonLoading customer data from an XLSX/CSV spreadsheet.
- 06QuickView — quick previewA customer preview that opens without leaving the list: contact details, the value of the relationship and tabs with contracts, measurements and service. We show what’s in it and when it comes in handy.
