Skip to content

Customers

Customers are the master accounts shared across CRM, Revenues, and other modules. Set them up before creating opportunities or quotations.

Navigation: left sidebar → CRM → Customers (/crm/customers).

Customers list
ColumnDescription
CodeAuto-generated customer ID.
Customer nameDisplay name.
Phone / EmailPrimary contact.
Account HandlerAssigned sales person.
Industry / Lead source / NationalityClassification fields.
RemarkNotes.

From the list, use the Sales History icon on a row to open Customer Sales History for that customer.

Use Upload on the Customers list (requires customer.create) to import or update customers from Excel.

  1. Click Upload and download the Customer Template (/assets/customer-upload-template.xlsx).
  2. Fill the sheet. Only name is required (for individuals you can supply first_name / last_name instead when is_corp is false). Use (auto) for code to let Auto Numbers assign the next code.
  3. Upload the file. Import runs in the background — you can keep working and will be notified when it finishes. The list refreshes automatically when done.

Rows match an existing customer by name (case-insensitive) or by code (when code is not (auto)). Matched rows are updated; others are created.

Column Notes
code Use (auto) for new auto-numbered codes
name Required (or first/last name for individuals)
is_corp Corporate vs individual
first_name / last_name / title_of_courtesy / gender Individual fields
vatin / id_card Tax ID / national ID
industry / nationality / lead_source / price_level / tax_category (or tax_type) Matched by list-of-values name
credit_term (or credit_terms) Matched by Credit Terms name
account_handler Matched by employee name
expat Yes/No
phone_1 / phone_2 / email / fax / website Contact
address_line_1 / address_line_2 / city / province / postal_code / country Free-text address (Area hierarchy and map location are not in the Excel import)
remark / special_note Notes

Click + Create.

Create Customer form
  1. Choose type: Individual (name fields) or Corporate (company name, VAT/sales tax ID).
  2. Set account handler, industry, nationality, lead source, tax category, Price Level, and Credit Terms as needed.
  3. On the Address tab, enter contact and location details (see below).
  4. On the Contacts tab (corporate): add contact persons.
  5. Save.

Customer code is auto-numbered — configure numbering under Auto Numbers if needed.

Price Level (list of values) sets the default selling price tier for this customer. When you add items on quotations, sales orders, and invoices, unit prices resolve from the item’s price table for that level (falling back to Regular when unset). Configure levels and prices on each Item.

Credit Terms sets the default payment terms for this customer (for example Net 30). The field is optional and searchable; you can create a new term inline.

When you select this customer on a quotation, sales order, or invoice, Credit Terms is copied onto the document. On invoices, changing Credit Terms recalculates Due Date from the document date plus the term’s Due days. Maintain the catalog under Credit Terms (Setup → Credit Terms).

On the Address tab:

Field Description
Phone / Email Primary contact details
Address line 1 Street / building
Address line 2 Filled automatically from the area selection
Country Country list of values
Area Hierarchical picker (province → district/city → commune/sangkat → village) from Areas
Postal code Optional
Map location Latitude,longitude — use Select in map to pick a point, or open the link to view in Google Maps

Area names come from the Areas master data. Maintain the hierarchy under Setup → Areas before relying on the picker.