Creating or Editing a Customer
Select ‘Customer’ from the main menu and then click the + (plus) button.
This will bring you to the customers main address screen. If creating a new customer the minimum data entry required is the customer code and a customer name.
Save – Saves a customer and leaves the customer window open
Save/Close – Saves a customer and closes the customer window
Delete – Deletes a customer.
- NOTE: A customer with history cannot be deleted.
Update Orders – This button will search for open sales orders and update any address changes including email addreses.
Navigation buttons – Allows the user to navigate the customer list. The navigation order will respect the filters and sort that was set before editing the customer.
Code – Must be unique
Name – The customer name that will appear on reports/forms
On Hold – If this check box is selected then no transactions can be entered for this customer.
Status – The customer can be set to one of 3 statuses, Active, Inactive or Prospect. A customer can only be made inactive if they have no balance in accounts receivable. A prospect setting is normally used when we are still trying to earn a company’s’ business. All of these statues can be used to create filters so that you can view only the ones that you want.
- NOTE: A user needs to have the security setting of “Customers/Show Inactive Customers” on to see be able to see inactive customers.
Colours – Each customer can be colour coded with a background and test colour for whatever reason. For example a company may want their foreign customers to stand out on their customer list and therefore colour code them in blue.
Addresses – Click on the + button to add any number of ship-to addresses. You can also delete ship-to’s by clicking the X icon. The button between the 2 gives allows you the ability to append the currently highlighted address to a new ship-to. By default only the billing address is put onto a sales order, however you can change this by selecting one of the ship-to addresses to be ‘default’. Then every sales order will default to having the billing address and this ship-to address.
Map – This button opens the address in either Google Maps. OpenStreetMap or Bling.
Contacts – These 3 contact labels can be edited to suit your requirements in Company Settings/Customer.
Hold Address – This puts a ship-to on hold so orders cannot be created for it
Email Addresses – All of the email addresses including those in the ship-to’s are available when emailing reports or forms to a customer.
Created / Modified by – The user and date/time the record was created and the last time it was edited.
Sales Taxes Tab
Sales Taxes – The sales tax code can be selected from the list that was setup in Edit/Sales Taxes. Once it is selected the code, the description and the rate will be displayed. An exemption number can also be added if the customer is exempt for a tax. This exemption number will then be added to a sales order when it is created.
Order Default Tab
Warehouse – If the company setting ‘Sales Orders/Use customer’s default warehouse’ is on then this warehouse it will be used by default on a sales order.
Shipping Method – This is the customers default shipping method will get added to sales orders. It is selected from a list that is created under Edit/Ship Via.
Territory – This is the customers default territory and will get added to sales orders. It is selected from a list that is created under Edit/Territory
Salesperson – This is the customers default salesperson and will get added to sales orders. It is selected from a list that is created under Edit/Salespeople
Pricing – A customer can be set for 1 of 20 different sell prices. This will then set the item at the corresponding level set in inventory. The multi-currency setup can further define a price level for a particular currency. Then when a customer is set for that currency it will select that price level automatically.
Communications – A communication or note can be added to a customer for later follow-up. If it is assigned to a user and it has a due date added, then this will be presented to the user when it is due or overdue every time they log into Spire. The communications tab will also be red if there are any notes for this customer.
Any number of notes can be added to a customer and have several options:
Subject – Gives the note a subject
Type – This groups notes by a type and must come from lookup list if used
Body – The details of a note
Assigned To – Who is responsible for this note or task
Number – A numeric field that be used for custom reports
Due Date – When the assigned communication/task is due for completion. If the user logs into Spire and there are communications that are due today or earlier they will be ‘popped’ in a message.
Completed Date – Enter a date here when the task is completed.
Print – Select if the contents should be printed on one of below:
Where – Select what document the message should be printed on. Spire’s stock reports have these messages on them, however they are defaulted to hidden so your consultant can un-hide them for you. The choices are:
- Packing Slip
- Picking Slip
- Booking Order
- Order Confirmation
- Purchase Order
- Sales Order
- Work Order
- Alert on Orders – If the message is set as an alert, the message will be presented to the user when the customer is added to a sales order or when it is edited. If the alert is not set, the communications ribbon at the top of the sales order, will indicate that there is customer communication.
Customer Attachments – Any number of attachments can be added to a customer. When double clicked it will open the attachment with the default viewer for that type of document.
User Defined Tab
User Defined Fields – UDF’s can be added to a customer to track extra information that Spire does not keep by default. The user can add additional tabs and define the fields and field types to store this data. The structure for the customer billing address can be different than the ship-to addresses.
Account Information – Shows the aged accounts receivable for this customer. The aging days that are used are setup in Company Settings/Accounts Receivable.
Statements & Invoices – User can select how the customer invoices and statements are sent. The choices are Form, Email, Form and Email or none. When printing, Spire does not use these settings, however this field is one of the columns on the customer list so the user can sort or filter by this and select all of the customers by form type before sending.
Discount – The default discount that is applied to the total sales order.
- Caution – this discount is applied after the line by line discounts.
Balance – The customers accounts receivable balance.
Limit – The customers credit limit.
Apply Finance Charges – When checked, finance charges will be applied to the customers AR. The ‘Apply Finance Charges’ button can be checked on the accounts receivable list or inside a customer AR screen.
Approved By – The initials of the user that lasted edited the customers credit type and/or limit.
Clear Approval – Clears the credit limit to zero.
Average Days to Pay – The average time it takes a customer to pay their accounts receivable.
Receivables – The GL account that this customers AR is posted to
Currency – The currency that the customer is billed in.
Payment Terms – The default terms that get added to a sales order. Once on the sales order it can be changed to other terms.
Bank Information – For Canadian banks, this is used for EFT to create a CPA1464 file (aka005) from all accounts receivable transactions that have payment terms of ‘PAD’
- Transit Number – The Customer’s bank transit number
- Institution – The Customer’s bank institution number
- Bank Account – The Customer’s bank account number
PO Number Required – When saving or editing a customers sales order the user will be warned that a purchase order number is required by this customer. Once the sales order is Processed, Shipped or Invoiced the PO number will be required.
Service Charge Default Exempt – If the Company Setting Sales Orders/Surcharges is active, this customer will not be charged this fee.
Inventory Levy Default Exempt – If a levy is set on an inventory item, this customer will be exempt from it.
Customer General Tab
User Type – This is an alphanumeric field that can have its label changed in Company Settings/Variables. This field is usually called ‘Customer Type’ and Spire’s price matrix uses this to define pricing for groups of customers. This field also has an associated table where values can be selected from.
Misc. – This is an numeric field that can have its label changed in Company Settings/Variables.
Special Code – A code from A-Z can be added to the customer. It is not used anywhere in the program but simply a way to rank a customer and be able to filter by it.
Customer Sales Order Tab
Sales Orders – Here a user can see all of the customers sales including active sales orders and their statuses. They can be viewed at the order header level of the detail level. The orders can be edited, processed, shipped to and invoiced just like they can in the sales order module.
Customer Sales History Tab
Sales History – This is a list of all of the customer’s sales history. It can be viewed at the invoice header level or details of all invoices. Filters can be set to limit the amount range of invoices shown. The invoice can also be drilled into to view and edit non financial information if the user has security to do so. The invoice can also be copied or credited when viewing it.
Customer Accounts Receivable Tab
Accounts Receivable – This gives full access to the accounts receivable for this customer. Data can be added here and invoices can be paid here. You can also view the applied accounts receivable data for this customer. If a customer has a balance of zero and everything is fully applied, then this is the only place to be able to see a customers accounts receivable info.
Customer Price Matrix Tab
Price Matrix – On this tab you can add/edit/delete and report on a customers special pricing. See the ‘Price Matrix’ Module for a full description.