The Customer module, located in the Sales group, allows customer information, including addresses, groups, and details to be added and edited.
Save saves any changes made to the customer.
Delete deletes a customer.
Check Balance Gets the customer's balance from the accounting system. This is also available on the sales order.
Print sends the default module report to the printer.
How To opens this article in a web browser.
Refresh reloads whatever is currently open in the module.
Create a new customer
The only required fields when creating a new customer are the name and the street address. Once a customer has been created, the information entered may be edited at any time. Follow these steps to create a new customer in the Fishbowl database.
- In the Sales module group, choose the Customer module. This will open the Customer Details window. All existing customers are listed on the left below the search pane.
- Click the New button on the module toolbar to launch the New Customer Wizard.
- Enter the customer's name and account number (optional) in the appropriate fields. To help with searching, Fishbowl requires that all customers have a unique identifier. No two customers can have the same name. This makes it possible to quickly distinguish between customers in the customer drop-down boxes found throughout Fishbowl. If the database already contains a customer with the name being added, add a unique identifier to the name using numbers, zip codes, area codes, or a business name.
- If desired, specify a Customer Job. This makes it possible to associate any number of sub-customers with an existing customer. Use the drop-down to choose the desired parent customer. Once the information on step 1 has been entered, click Next.
- Enter a Main Address for the customer and click Next. If a customer needs multiple addresses, for billing shipping, etc., these may be added via the Customers import or through the Address tab.
- Enter the customer's phone number, fax number, mobile number, other number, and e-mail address, and click Next.
- The Customer Details step displays some of the fields found on the Details tab of the Customer module.
- If desired, use the arrows in the center of the Customer Group window to add the new customer to any existing customer groups. If the desired group has not yet been created, create a customer group first and then add the customer to the group later using the Groups tab on the Customer Details screen.
- Use the Customer custom fields step for including any additional customer information. Custom field types can be modified in the Custom Field module.
- Click Finish to add the new customer to Fishbowl. It is possible to skip steps in the New Customer Wizard by clicking Finish any time after step 1. Customers can also be imported from a spreadsheet.
Modify an existing customer
Customer information may be modified at any time. To edit a customer, double click on the customer in the search pane. Changes may be made by clicking the various tabs. For an explanation of each tab, see the TABS section. Remember to click the Save button on the module toolbar after making any modifications.
Delete a customer
Delete a customer
A customer may only be deleted when new and unattached to any orders. Once an order has been made, a customer cannot be deleted and therefore should be set as inactive.
Inactivate a customer
Fishbowl will still store history and information about an inactive customer. However, making a customer inactive will hide that information from any list containing customer names. You may view an inactive customer by clicking the Advanced Search button and choosing the Show inactive only or Show all options at the bottom of the window. Follow these instructions to inactivate a customer.
- Double-click the customer in the search pane on the left.
- Under the Account Info tab, deselect the Active box located at the top right of the screen.
- Click the Save button on the module toolbar.
Pipeline integration can be enabled in the module options. This adds two module buttons used to synchronize customers with Fishbowl Pipeline. Access to these buttons can be set via access rights in the User Group module. Pipeline is Fishbowl's cloud-based CRM. Read more about Pipeline here or visit the Pipeline wiki.
- The Push To button uploads or syncs the currently open Fishbowl customer to Pipeline.
- The Pull From button downloads or syncs all accounts from Pipeline that are set to be synchronized.
Products, inventory quantities, location groups, taxes, and UOMs can also be synced with Pipeline using the Product module.
Create customer groups
Customers can be organized into groups. These groups can then be used to create pricing rules. Follow the steps below to edit customer groups, or import data from a spreadsheet to assign many customers to a group.
- Open a customer in the Customer module and click the Groups tab.
- To add or remove a customer from a group, double-click the group name or use the on-screen arrow buttons.
- To create a new group, click the Manage Groups button. Groups can also be edited and deleted in this window.
The Search pane on the left can be used to filter by Name, City, or State. Records can also be found by typing in the table. Click the Advanced Search button to search the Custom Fields and the following search options.
Update a customer address
To see a customer's purchase history, open the customer, and click the History button. The same button is also found in the Sales Order module. To change the report that is loaded when clicking the History button, open the Reports module options and select a different report next to Customer Purchase History.
The Account Info tab can be used to view and modify basic customer information.
- Name - View and edit the customer name. Click the Save button after making any changes.
- URL - A clickable URL for the customer. Clicking the link can open local files, websites, etc. Click the Edit button to modify the link.
- Active - A setting that determines whether a customer is visible in the default search. Uncheck this box to make a customer inactive.
- Address - A read-only field showing the customer's address. To edit this information, use the Address tab.
- Change History - A read-only field showing the date the customer was created in the database and the date the customer's details were last changed.
- Address Information - A read-only field showing additional contact information for the customer, such as email and telephone numbers. To edit this information, use the Address tab.
- Currency - The default currency and rate specified for the customer. Check Use Currency Default to use the default rate set in the Currency module. This field is only visible if currency conversion is enabled.
- Credit Limit - The credit limit set for the customer. A dialog box will display this limit whenever a new sales order is created for the customer.
- Status - A customer's current status. Normal is the default, but it may also be set to Preferred, Hold Shipment, Hold Sales, and Hold All.
- Issue Status - Allows a customer to have a different issue status from the Issue Sales Orders module option.
- Default Terms - Default payment terms for the customer. Payment terms can be created and modified in the Payment Terms module.
- COD - Cash on delivery is used for customers who pay at the time of receipt.
- CIA - Cash in advance is used for customers who must pay in advance.
- CCD - Cash concentration and disbursement is a format for Automated Clearing House (ACH) payments, or payments dealing with electronic transactions.
- Net 30 - Net terms specify the number of days a customer has to pay.
- Default Carrier - The default shipping method for the customer.
- Default Carrier Service - The default shipping service for the customer.
- Shipping Terms - The default shipping terms for the customer. These include Prepaid & Billed, Prepaid, or Freight Collect.
- Salesperson - This is the customer's default salesperson. The Salesperson field in a sales order will default to this person unless this option is disabled in Sales Order module options. A salesperson will only be able to view those sales orders under his or her name unless the See All Customers access right is enabled.
- Class - The default class for the customer. The product class will take precedence over all other classes. If the product doesn't have a class, then the customer class will be used. If the customer doesn't have a class, then the location group class will be used.
- Account Number - The number associated with the customer.
- To Be Emailed and To Be Printed - Searchable options that will transfer to the Details tab of the Sales Order module when this customer is selected on the order.
- Tax Rate - The default tax rate for the customer. Tax rates available in the drop-down list have already been created in the Tax Rate module.
- Tax Exempt - A customer's tax-exemption status. If the customer is tax exempt, check the box and enter the tax number in the available field.
- Alert Note - A field for recording important notes about the customer. Alert notes are displayed in a pop-up window when the customer is selected on a sales order.
The Address tab has a pane on the left showing all of a customer's saved addresses. To add a new address, click the New Address button on the top left and enter the desired information. Be sure to select an Address Type, enter an Address Name, and choose whether the address will be the default address for the selected type. Each address type may have a default. A unique address name tied to a specific address type will allow a user to create and update customers and their addresses through the Customers Import. To delete an address, click on it, and then click the Delete Address button at the top left.
To edit an address, click on the desired address in the left column and modify the information shown on the right side of the screen. After any changes are made to an address, make sure to click the Save button located on the module toolbar. To add contact information such as an email address or phone number, click the New button on the right of the Address Information section and enter a name, type, and the desired information.
Click the Map button to the right of the address type to view the address on Google Maps.
If a customer uses a different number than the Fishbowl product number, that information can be stored on the Parts tab.
- Customer part numbers can be added by clicking the Add button on the component toolbar to the right. Enter the existing product name or number for the desired item as well as the customer's new name or number to link to it.
- Customer part numbers can also be set in the Sales Order module by clicking the Customer Number cell in the item table, or by double-clicking a line item and entering it into the Customer Part Number field. When the sales order is saved, the customer part number record will also be saved.
- When an order is fulfilled, the Last Price will be updated automatically for parts that have a customer part number.
- The Last Price can also be edited manually and used as a basis for pricing rules.
- If a customer part number is linked to the product number in Fishbowl, that item can be added to a sales order by typing the customer part number into the Product field.
The Memo tab is for internal use and allows users to enter notes regarding a specific product. The top portion of the screen displays the date a memo was created, by what user, as well as a preview of the memo. Click on the preview to view the entire message in the window below.
Use the component toolbar on the right to Add a new memo, Edit an existing memo, or Delete a memo. To print all of the memos for a product, click the Print button.
The Custom tab stores additional fields for the order that can be customized to fit the needs of each company.
- Custom fields can be created and modified by opening the Custom Field module and selecting Customer from the drop-down at the top of the module.
- Custom fields with the same name and type will transfer from the customer to the sales order if the module option is enabled. For example, if a customer has a custom field that stores priority and there is a matching custom field for sales orders, the data in the custom field will transfer when creating a new order for the customer.
- To search for customers using the custom fields, click the Advanced Search button in the search pane to the left and then click the Custom tab.
Some aspects of the Customer module can be customized by opening the module, clicking the Tools menu, and then selecting Module Options.
- Add custom fields to SO
- If this option is enabled, custom fields with the same name and type will transfer from the customer to the sales order. For example, if a customer has a custom field that stores priority and there is a matching custom field for sales orders, the data in the custom field will transfer when creating a new order for the customer.
- Enable Pipeline Integration
- If this option is enabled, the module buttons for Pipeline will be visible.
- Issue Sales Orders
- To prevent a sales order from being issued before a payment has been received, select Paid in Full or Partially Paid. A customer's default issue status can also be set on the Details tab. If the Issue button is clicked before payment has been received, a warning will be displayed with the option for a manager override. To override, a user must have the Customer-Override Hold access right.