Need more info or you couldn't find what you were looking for, let us know by sending an email to: support@dancik.com.

Sales Portal

The Dancik Sales Portal is intended for salespeople and the mobile devices that they use while they are in the field. The application gives salespeople direct access to their accounts. It delivers real-time data on items, pricing and availability of stock, open orders, invoice inquiry marketing and display programs, and general sales statistics.

Device and Browser Support

Set-up

Customer Look-up

Inventory Lookup

My Sales

Device and Browser Support

Mobile/Tablet Browser

 

Supported

Safari (iOS only)

 

Yes

Chrome App

 

Yes

Recommended Devices

OS Version

Supported

iPad (2nd, 3rd, 4th Generation and Air)

iOS 7.0 or higher

Yes

iPhone (4, 4S, 5, 5S, 5C, 6, 6 Plus)

iOS 7.0 or higher

Yes

Samsung - Galaxy 4 and higher

Google Android 4.0 or higher

Yes

Google Nexus 5 and higher

Google Android 4.0 or higher

Yes

Set-up

Logging in to the Portal

Granting Permission to Sales Portal Features

Logging in to the Portal

There are a couple of ways to log into the portal:

Control User File Maintenance (Menu option NAV 5)

Notice the two settings for adding an alternate Email Address as a user name and the related password.

salesportal19.jpg 

Note:  If an email address and password are entered, the Sales Portal automatically uses those entries when the salesperson tries to log in.

Notes:

Option to Send out an Email for Setting up an Alternate Password

Option “Z”on the Control User File Maintenance (NAV 5) that allows an administrator to send out a mass email to all the salespeople that have an email entered in the Email Address. This allows the salespeople to create their own password and manage their sign in name/email address.

Enter a “Z” into the Opt field of the salespeople that have an email address assigned.

salesportal20.jpg 

Press Enter to access the following screen.

salesportal21.png 

Make changes to the Subject and Message as needed.

The Verify Domain/URL is imported in from the Work with Web Application URLs (menu option WEB 100).

Granting Permission to Sales Portal Features

Access can be granted at the:

- Menu option NAV 5

- Enter option "W" for a user

- Enter an "A" for the Sales Portal

- Grant or deny access to the different parts/functionality of the Sales Portal.

Customer Look-up

The Customer account portion of the Sales Portal lets you quickly and easily check and perform the following:

salesportal17.png 

When first accessing the Customer Look-Up window, you are presented with the accounts that are assigned to you.

salesportal9.png 

Note:  Accounts are assigned to Salespeople via the Billto File.

Select one of the accounts in the My Accounts listing or search for an account and select it. The Customer Information window appears.

Use the icons at the top of the window to perform the following functions.

Icon

Function

Presents a list of account contact phone numbers pulled from the Phone Number screen of the Billto File.

Opens up Google Maps at the account’s location.

Opens up your default email application.

If there are multiple email contacts assigned to the account they are all listed. If there is only one it is automatically used in the email.

Displays additional details about the account.

 

At a glance you can see a sales history for the account:

Inventory Look-Up

Accessing the Inventory Search from within the Customer Information window directs the Sales Portal to display inventory viewed by the active account.

Note: For more information on Inventory Look-up, refer to See “Account Specific Inquiry”.

Send a Pricelist

This option creates a new price list option(s) based off user built templates. These templates are manufacturer/item specific and use Dancik supplied keyword code that correspond to price list data values.

Creating the Price List Template

Using Navigator to Create and Update the Links to the Dynamic Price List Templates

Sending the Price List

Creating the Price List Template

The Price List templates are built using specific keyword values supplied by Dancik. These specific keywords correspond to a database value or conversion process, e.g. SF per Carton pricing, quantity break pricing and carton and pallet pricing variance for the same item.

After the template(s) are built, save them to the IFS where they are accessible to the Sales Portal.

List of Sample Template Codes

Note: Click here to access the template codes in an Excel spreadsheet.

Instructions for Code Usage

${item(enter item number).getqtyavail().for-uom(enter uom)}

Example Template

Using Navigator to Create and Update the Links to the Dynamic Price List Templates

After the template(s) are built, save them to the IFS where they are accessible to the Sales Portal. The option, Dynamic Price List Template, in the Navigator File Management provides access to the user created templates.

The Price List Templates stored here are the ones that will be displayed in the Sales Portal.

Creating Links to the Dynamic Price List Templates

1. Access the File Management application within Navigator.

2 Select the Dynamic Price List Template option.

3. Under Records click Create.

4 The Create Record window appears.

Note: The actual templates are user built spreadsheets built using Dancik supplied code and formulas. The screen shown below provides the IFS location the Sales Portal needs to access the templates.

3. The Template File Location is where the Sales Portal is going to look for the template.

4. The Merged File Name will be the title of the attached price list when it is sent out via email.

Updating a Dynamic Price List Template

1. To update an entry, click the option arrow to the left of the record and select Update.

The Update Record window appears.

The Template File Location is where the Sales Portal is going to look for the template.

The Merged File Name will be the title of the attached price list went it is sent out via email.

Sending a Price List

1. On the Customer Information window, click Send Price List.

2. On the window that appears, select a pricing template. The pricing templates are stored and maintained through Navigator File Management.

The recipient(s) displayed are pulled in from the account's Phone Number file (part of the Billto file). All the contacts that have been set up to receive emails are displayed.

Orders

This option list all the open and pending orders for the account.

salesportal11.png 

Click an order to see its details.

salesportal12.png 

Invoices

This option allows you to search for an invoice for the account.

salesportal13.png 

Note:  Use the Inventory Inquiry to get a listing of invoices for the account.

Marketing

This option gives you a quick glance into the marketing programs this customer is participating in.

salesportal14.png 

The date shown is the date the marketing program was created. Marketing programs are created using the Fund File.

Customers are assigned to Marketing Programs in the Billto File.

Note:   On the Green Screen, the marketing codes are assigned via the F14 - Codes function on the Billto Profile.

Display Types

The Sales Portal automatically tracks composite sales of all customers that have each display. You can use display types for sample tracking by creating a display code for each major sample category. Display types can also use marketing programs and displays for assigning promotional prices and for generating reports, mailing lists, and recurring invoices.

salesportal15.png 

Note:   Note:   Displays must be established in the Classification Codes File and are assigned to customers in the Billto File.

Inventory Lookup

As shown in the following flowchart, an inventory inquiry can be account specific or generic.

salesportal16.png 

Account Specific Inquiry

General Inventory Inquiry

Account Specific Inquiry

1. Select the Customer Look-up option on the Sales Portal dashboard.

2. Search for and then select a customer.

3. Click Inventory Look-up to view inventory and pricing specific to the active account.

4. When the Inventory Look-up link is clicked, the Inventory Look-up window appears with three buckets of selectable information.

  Recent - Shows the 10 most recent items searched on by this account.

  Top Sellers - Displays the top 25 best selling items for the account.

  All - Allows for a search through all items.

The Include Discontinued Items feature has to be activated via the setting Default Option for Discontinued Items in Item Search in the System Wide Setting - Options to Enable Item Keyword Search. Items are designated as discontinued by the following settings in the Item File:

5. After performing a search in any of the three buckets, Recent, Top Sellers or All, click on an item to access the Item Details window.

Note:  Product images can be uploaded via the Item/Image Cross Reference File (menu option SET 307).

6. Click Pricing and Requests to see pricing that is specific to the active account.

7. Enter a quantity and click Roll or Cut (if it is a rolled item) to toggle between the prices to see the differences. A roll (R) or cut (C) indicator precedes the price.

8. To toggle between the prices, click the price you want to see and then click Recalculate.

9. Use the Special Price feature to request special/promotional pricing for this customer. The price shown is the List Price. In this example, we are giving the customer roll pricing.

Enter the new special price. The system checks to see if the new price falls into the GP% margin set-up for the item. Here is a breakdown of how the system calculates the GP% for an item:

  The standard cost AND the cost from the SKU file for the customer's warehouse are checked. The higher of the two costs, plus the GP% are sent back.

If the new price falls within the specified GP% for the item, the message “Price is within margin. GP%” appears along with a Start and End date for the new pricing, which is essentially a promotion.

10. Enter a Job Name and/or Job Number and determine if the promotional pricing file is going to be for an Item or for an entire Price Class.

Note: The Job Name and Number is added to the promotional file that gets created when/if the approving manager approves the special pricing.

11. Use Apprv Mgr drop down menu to select an approving manager.

Note: Approving Managers are designated by entering a “Y” in the Pricing Approving Mgr field of a user’s Control User File Maintenance (path: NAV 5>option “U”, the setting is on the first screen).

12.  When Send Request is clicked an email is sent to the Approving Manager.

sales19.png 

13. A record for the special pricing request is entered into the Sales Portal Pricing Request section on the Navigator File Management application. The record can be found by using the Job Name or Job Number filters.

sales20.png 

14. To approve or deny the special pricing request, the manager clicks the option arrow to the left of the record and select Update. The settings pertaining to the Sales Portal pricing request, including the Approval Status setting, are located near the bottom of the window.

sales21.png 

15  When the manager approves or denies the special pricing request, an email is sent to the sales person alerting them of the pricing request status.

sales22.png 

16. If the manager approves the special pricing request, a new promotional pricing file is created. It can be found by using the Job Name and/or Job Number filters.

17. To look into the details of the newly created promotional pricing record, click the Options arrow and select Update.

sales23.png 

General Inventory Inquiry

By clicking the Inventory Look-up link in the top menu bar you can perform a search on all inventory in the system.

Note:  The last 10 items searched on are listed under Recent.

The Include Discontinued Items feature has to be activated via the setting Default Option for Discontinued Items in Item Search in the System Wide Setting - Options to Enable Item Keyword Search. Items are designated as discontinued by the following settings in the Item File:

Click on an item to display its details.

salesportal8.png 

This information is the same as described above under the Account Specific Inquiry. However, the pricing shown is List Pricing and does not include any account specific pricing information that affects pricing such as funds or requests for different prices.

My Sales

This functionality allows a salesperson or sales manager to view sales statistics.

Set-up

Granting Permission to My Sales - Salespeople or Sales Managers have to been access to the My Sales functionality via the Navigator menu.

Use of the following Navigator Menu options:

System Wide Setting - Options for Sales Portal - This System Wide Setting contains two options that limit the orders a salesperson can see in the My Sales and Customer Information portions of the Sales Portal. For more information, refer to Options for Sales Portal.

Salesperson File - The Sales Manager setting ties the salesperson to a sales manager and allows the sales manger to access the salesperson’s statistics.

Nav 5 - Control User File Maintenance - Two fields can limit access to sales information.

The Salesperson ID field is validated against the Salesperson File and the Sales Manager ID is validated against the Sales Manager File.

The Limit to Salesperson#, Salesperson ID, and Sales Manager ID fields work together as follows:

How the Salesperson ID and Sales Manager ID settings work:

Salesperson ID

Sales Manager ID

Both a Salesperson ID and a Sales Manager ID is entered

Checking My Sales

1. Access the Sales Portal and click the My Sales icon.

Note:  If the My Sales icon does not appear, check the Control User File Maintenance (NAV 5) to ensure a salesperson is entered into the Limit To Salesperson# setting.

2. If a Sales Manager is accessing the information, as in this example, they have access to all the salespeople that report to him.

3. Click a Salesperson to access the following sales information:

Sales Statistics

Note:   The information displayed is imported in from the Salesperson File.

You can toggle between the following time periods:

Sales Month-By Month

You can check the month-by-month sales for the Past 12 months or the Previous 12 months.

Open Orders

This part of the Sales Portal lets you check on Open and Pending orders for a salesperson. If the order was assigned to multiple salespeople, the order displays in all the assigned salespeople’s My Orders inquiry.

Note:  An order is shown if it has at least one detail line or message line that includes a dollar amount and that line has not been invoiced.

Click the arrow at the extreme right of the window to view the order details.

Review the order as needed and/or click the mail icon to send an email to the contacts set-up as internet contacts (Number Type I) on the Phone Number screen of the Billto File.