Here is a list of our current Import Utilities:

JEImportsql.exe -  Journal Entry Import using an xlsx template to import Journal Entries into Manex System

• Place executable in Manex Desktop Directory. 
• Input information in JEImport.xltx
• Run JEimportsql.exe and select your JEImport.xltx 

UpdateSupplierStatusType.exe - Used to update Mass numbers of Suppliers Status and Type

• Place executable in Manex Desktop Directory
• User has to fill in the template (SupplierUpdateStatusType.xlt) with Supplier ID, Supplier Name, Status and type. The ' Supplier Status' and 'Supplier Type' entered in the template have to exist in the system setup first. 
  
• Run UpdateSupplierStatusType.exe and select your SupplierUpdateStatusType.xlt to import

Standard Cost Rollup Import - Please note this is designed to work with buy parts only because Make Parts need to be leveled and rolled differently

•  Start costroll for Buy parts in SQLManex Desktop module as normal
• Run the GetRollSql.exe to export that current open costroll into the template CostRollimport.xltx. Program will prompt to locate this file after starting program
• Populate calculated cost in Excel File created from template (will time stamp with today's date)
• Run ImptStdCostSql.exe It will prompt to choose the Excel File that you modified in the previous step.
• Open Cost Roll Module in Manex Desktop and verify that the changes have been entered and  ' User calculated cost' checkbox is checked. Once verified or saved if additional manual changes made again in module and then click the roll costs button to update the costs in inventory and generate the necessary GL transactions.

AddTargetPrice2Invt.exe- Used to do mass update of the Target Price in Inventory

• Place executable in Manex Desktop Directory
• Input and save your information on TargetImportSQL.xls 
• Run executable and begin import process and follow prompts.

PartClassTypeImport.exe - Import mass number of Part Class Types using an xlsx template (typically used during Manex implentation)

CustomerImport.exe - Import Mass number of new customers using an xlsx template (typically used during Manex implementation) 

SupplierImport.exe - Import Mass number of new Suppliers using xlsx template (typically used during Manex implementation

ImportInventoryReceiving.exe -  Import mass numbers of Beginning receiving entries (typically used during Manex implementation)

Partclasstypeimport.exe - Import mass number of Part Class Types using an xlsx template (typically used during Manex implentation)

ImportRouting.exe- Import mass number of new routings using xlsx template (typically used during Manex Implementation)

Please contact manex if you have any further questions or need a template for any of the following Import Utilities.