You can create customers in the following ways:
- Individually, (in the Account Maintenance window)
- In documents, (like quotations or sales orders)
- Bulk import using a CSV file.
You will be able to save a customer on the system if you provide the following information:
- An account number
- A name for the account
It is recommended that you enter as much information as possible on the customer's account, but the above mentioned is the required minimum.
Creating customers individually
Watch this video to see how to create a customer individually or follow the steps below ut.
In order to be able to create a customer, a user has to have the appropriate user right.
Enable the user right by doing the following:
- Navigate to System / Users and Passwords.
- Enter (or select) the appropriate user in the User text box.
- Enter the appropriate password, if required in the Password text box
- Click on the Other tab.
- Enable the Allow Creation of Debtor Accounts user right.
- Click the Accept button.
Navigate to the correct window
- Navigate to Debtors / Account Maintenance.
Create the customer
- Enter a six-character code for the account in the Account Number text box.
- Press Enter on your keyboard.
- Check that the following confirmation window appears: The account does not exist – do you want to create it?
- Click the Yes button.
- Enter the name of the account in the Name text box.
Enter the customer information
- Fill in any other field you deem necessary at this stage.
Save the customer
- Click the Accept button.
Creating customers in documents
Watch this video to see how to create customers while creating a document or follow the steps below it.
In order to be able to create customers in a document like a sales order, a user has to have the appropriate user right as mentioned above.
- Enter the new account number in the Account text box.
- Press Enter on your keyboard.
- Click on the Create Debtor button.
- Enter the name of the customer in the Name text box.
- Enter the rest of the item information, if required.
- Click the Accept button.
Bulk importing customers
Watch this video to see how to create customers in bulk or follow the steps below it.
Download the template
- Download the Excel template at the bottom of this guide.
Create the CSV file
- Complete the spreadsheet with the relevant account information.
- Save the file as a spreadsheet in order to reference it later if needed.
- Remove all headings, instructions and other tabs.
- Save the file as a CSV file.
- Close the file.
You will see that only two columns are required, the rest of the fields are optional. The columns that you do not fill in will be set to the default setting, for example, the account will be active. You can amend all of these details afterwards, except the Account Number.
Navigate to the correct window
- Navigate to System / Import Utilities / Accounts / Import Debtor Accounts.
Upload the CSV file
- Select to overwrite existing accounts in the Overwrite Existing Debtor Accounts checkbox, if you wish.
- Click the Open File button.
- Select the appropriate file and click the Open button.
Check the import
- Make sure that you are happy with all the account information before performing the import.
Import the customers
- Click the Accept button.
Download the template here: