Import Sales Order from Excel to SkyBiz Distribution

  Financial

Below are guideline(s) on How to Import Sales Order from Excel to MySQL

Step 1: Go to Data Excel Conversion Sheet

Go to Local Disk C>>MyERP>>Sample>>Data Conversion Sample

 

Step 2: Key in all data on Excel Conversion under Sales Order

Click “Sales Order” on worksheet tabs at bottom of excel >> key in all the data >> save the document

N/B: Note that RED titles are compulsory field.

 

 

Step 3: Open SkySyn

Go to Local Disk C>>MyERP>>SkySyn

 

 

Step 4: Go to File > Excel to MySQL2

 

 

Step 5: Synchronize Data

Select Database >> Choose File Location of Data Excel Convert >> Click Show Excel Sheet >> Tick Sales Order >> Click SQL Convert

 

 

Step 6: Wait until “Process Convert Completed” message shown then press “OK”.