Warning: mysqli_connect(): (HY000/2002): No route to host in /home/skybizgl/public_html/ticket/header-uc.php on line 38

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /home/skybizgl/public_html/ticket/header-uc.php on line 39

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/skybizgl/public_html/ticket/header-uc.php on line 40

Import Purchase Order from Excel to SkyBiz Distribution
Knowledgebase
SkyBiz Support Ticket > SkyBiz Support Ticket > Knowledgebase

Search help:


Import Purchase Order from Excel to SkyBiz Distribution

Solution

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

Step 1: Go to Data Excel Conversion Sheet

Go to local disc C >> MyERP >> Sample >> Data Conversion Sample

 

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

Click "Purchase 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 disc 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 Purchase Order >> Click SQL Convert

 

 

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

 

 

 
Was this article helpful? yes / no
Related articles Import Sales Order from Excel to SkyBiz Distribution
Import Fixed Asset from Excel to SkyBiz
Import Item Master/Product Master from Excel into SkyBiz System
where to get data excel conversion
Guides on How to Import Text file to Excel format
Article details
Article ID: 267
Category: SkyBiz SkySyn
Date added: 2017-06-05 09:06:06
Views: 268
Rating (Votes): Article not rated yet (0)

 
« Go back

 
Powered by Help Desk Software HESK, brought to you by SysAid