{% set baseFontFamily = "Roboto" %} /* Add the font family you wish to use. You may need to import it above. */

{% set headerFontFamily = "Montserrat" %} /* This affects only headers on the site. Add the font family you wish to use. You may need to import it above. */

{% set textColor = "#565656" %} /* This sets the universal color of dark text on the site */

{% set pageCenter = "1100px" %} /* This sets the width of the website */

{% set headerType = "fixed" %} /* To make this a fixed header, change the value to "fixed" - otherwise, set it to "static" */

{% set lightGreyColor = "#f7f7f7" %} /* This affects all grey background sections */

{% set baseFontWeight = "normal" %} /* More than likely, you will use one of these values (higher = bolder): 300, 400, 700, 900 */

{% set headerFontWeight = "bold" %} /* For Headers; More than likely, you will use one of these values (higher = bolder): 300, 400, 700, 900 */

{% set buttonRadius = '40px' %} /* "0" for square edges, "10px" for rounded edges, "40px" for pill shape; This will change all buttons */

After you have updated your stylesheet, make sure you turn this module off

Importing Data from Excel

by salespad on October 15, 2014

workflow rules - sequence matters.jpg

Whether you are starting a new company in  Great Plains and SalesPad Desktop, or just updating your current data in the system, you often have to face the stress of manually entering all those records in Microsoft Dynamics GP one by one.

No need to worry about that anymore. Desktop has a powerful tool called Import Manager that allows you to mass import data into Desktop from an Excel spreadsheet or CSV file. With just a few clicks, you can add thousands of items in your database, or create prices and inventory with the same ease.

HOW DOES IT WORK?

Importing data from an Excel spreadsheet or CVS file using the Import Manager is simple and requires only a few steps.

For instance, say we need to create new items in Great Plains. We start with our data in a file like this:

The import definition is saved for future use; this way we don’t have to create a new mapping every time, making the import even faster. Now that we have the definition ready, all we need is to click “Run Import,” select the file to open, and run the tool. Within a couple of seconds (depending on the amount of data), we imported our new items into Great Plains and SalesPad.

ONLY FOR ITEMS?

Certainly not. Import Manager is not only for item numbers.

Currently, this tool supports the following tables:

  • Alternate Item
  • Custom Price (Special Pricing)
  • Inventory Adjustment
  • Inventory By Location
  • Item List Price
  • Item Master
  • Item Price List
  • Purchase Line Item (on existing Purchase Orders)
  • Sales Line Item (on existing Sales Documents)
  • Vendor Item

So, for instance, after we imported our items through the Import Manager, we can add pricing (list price and/or price list), and the inventory (this will require posting in GP). After that, everything will be ready to be used in sales documents.

But what if I need to import data to a table that is not listed?

At SalesPad, we strive to make our product more powerful and complete, and we appreciate requests of customizations that help our flagship application become better.

We often receive requests to add new table definitions to the tool. So, if you are in need of importing data into a table that is not currently available, let us know and we will be more than happy to add it. To learn more about setting up and running Import Manager, visit our support documentation.

Frederic Paladin

Topics: SalesPad Insights

Get Blog Updates

Recent Posts

Popular Posts