Most SX.e/CSD users will utilize the standard data conversion toolkit for initially loading data into the SX.e database in preparation for going live with the software. What many fail to recognize is that there are conversion programs which can be used on an ongoing basis to add and maintain data.

The programs allow you to prepare your data using common tools like Excel or Access to manage the files before loading into SX.e. These tools offer powerful data manipulation services that are not available within SX.e. Features like:

  • Identifying and removing duplicate records
  • Manipulating columnar data
  • Splitting one field into multiple
  • Stripping out undesirable characters
  • Combining data elements
  • Translating values to be consistent with the target format (dates, capitalization, etc.)

The Data Conversion Programs Are Often Used When Adding Records to Various SX.E Tables.

A few examples are:

  • Kit Bill of Materials (KPSK)
  • Fabricated Products (VASP, VASPS)
  • Customer Pricing Records (PDSC)
  • Vendor Pricing (PDSV)
  • Vendor Contract Pricing (PDSVC)
  • Rebate Records (PDSR)
  • Table Values (buyers, categories, ECCN codes, country codes and many more)
  • Product Notes (NOTES)
  • Contacts and Methods (CONTACTS, CONTACTS-ROLES)
  • Budgets (GLSB)
  • Product Cross References (ICSEC)
  • Product Specific Units (ICSEU)
  • Freight Bill Account Numbers (SASTF)

Many times, we see users setup custom tables (SASTZ) where they want to maintain extra data that may be needed for reporting purposes. They then proceed to manually enter the data into SX.e to populate the table when they could be importing it from a .csv file using a standard tool. After 30 years of working with SX.e, I try to do as much data maintenance as I can in tools that are designed to manipulate data and then import it into the database.

If you think you may have a need to programmatically load data and are not sure if there is a standard tool that already exists to help, feel free to call NSA. We can review what is available and the best way to use the existing tools. If you need custom loads or data manipulation, we can help with that as needed. Please contact our team to get started.

 



WebPresented provides a fully-integrated CRM, Quoting, and BI tool built specifically for the wholesale distribution industry.

WebPresented CRM, or WPCRM, uses the existing data in your ERP to provide key information to the sales reps so they can work better and smarter - whether that’s saving time, closing more business, or increasing margins. WPCRM was designed for the sales reps to be easy-to-use, valuable, and accessible.

billtrust logo
Customers often ask how Microsoft deploys its own technologies. What were the initial catalysts for change? The challenges? The benefits? You’ll find those answers here. Microsoft IT Showcase provides what no one else can—the inside story of how Microsoft does IT. By detailing how Microsoft rolls out technology solutions across its own enterprise environment, we will inspire and equip you with the resources to inform your most crucial IT business decisions.

We love to talk about IT. It’s our passion. And we’re armed with some of the best technical minds in the industry. Our IT experts know what they’re doing and pride themselves on digging in to get the most out of technology. Our entire platform is based on their knowledge and we’re better for it.

sparxiqBusiness Intelligent and Pricing Analytics.SPARXiQ delivers analytics, software, and training to help companies get the most out of both their data and people. SPARXiQ provides data-driven price optimization solutions that enable companies to quickly and easily improve margins and profitability. With the launch of an entry-level pricing solution, Switch™, clients can get results more quickly than ever using integrated modules for leading electrical industry ERP systems. Since our inception in 1993, SPARXiQ (formerly SPA) has generated billions of dollars of profitable growth for hundreds of organizations, including twenty-five Fortune 500 companies. For more information, contact Brian Weaver at NSA.

billtrust logo
We know that a proper security strategy must include networks, servers and devices—all devices—managed easily through the cloud. Sophos products allow you to secure every end point of your network, from laptops to virtual desktops and servers, to web and email traffic and mobile devices. What’s more, securing these devices is made possible through products that fit your precise needs. We can ensure your network’s security by providing the one thing no one else can: Single sourced simplicity.

Sophos began producing antivirus and encryption products nearly 30 years ago. Today Sophos products help secure the networks used by 100 million people in 150 countries and 100,000 businesses, including organizations such as Pixar, Under Armour, Xerox, Ford, Avis, and Toshiba. As IT networks grow in complexity, we wanted a solution for our clients that was focused on keeping IT security simple and reliable.