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:

Author's Bio: 

Since 1984, NSA Professional Services has been helping successful wholesale distribution businesses grow and prosper by leveraging and implementing world class software and processes. Our mantra is simple and clear – the right product, the right process, and the right people to ensure a successful project and a long-term relationship.