| Line 41: | Line 41: | ||
:01. Enter the '''Server Name''' or '''IP Address'''<br /> | :01. Enter the '''Server Name''' or '''IP Address'''<br /> | ||
:02. Click the button & select the '''Database''' to be export out.<br /> | :02. Click the button & select the '''Database''' to be export out.<br /> | ||
:03. Select the '''Output Path''' | :03. Select the '''Output Path''' folder (where DKSH file to be exported to) <br /> | ||
:04. Enter the '''Organization prefix''' provide by DKSH<br /> | :04. Enter the '''Organization prefix''' provide by DKSH<br /> | ||
:05. Click '''Test Connection''' to make sure is successfully Connected.<br /> | :05. Click '''Test Connection''' to make sure is successfully Connected.<br /> | ||
Revision as of 08:47, 2 November 2016
Introduction
Is External Shareware Program which Export Data for DKSH System.
Document Type Export
- Maintain Customer - Cust.txt
- Maintain Item - Item.txt
- Maintain Agent - Salesman.txt
- Sales Invoice - InvDtl.txt
- Sales Credit Note - CN_Dtl.txt
Limitation
- 1 Computer only can export 1 Company Database only
DKSH Specification
Export Program
- Version (1.0.0.1) - 25 Aug 2016
- Evaluation Limit : 30 Times Export
- http://www.estream.com.my/downloadfile/Fairy/SQLAccDKSHExport-setup.exe
- MD5 : 2EBB0FBD588134AF2F39C1A97B434866
History New/Updates/Changes
--Build 1--
- Item missing RefPrice field.
- Remove , for Currency field.
--Build 0--
Todo
Settings
Firebird
During Installation of Firebird make sure the option (see Below picture) is selected
Export Program
- 01. Enter the Server Name or IP Address
- 02. Click the button & select the Database to be export out.
- 03. Select the Output Path folder (where DKSH file to be exported to)
- 04. Enter the Organization prefix provide by DKSH
- 05. Click Test Connection to make sure is successfully Connected.
Below steps is to export data
- 06. Select Date Range data to Export
- 07. Click Export Output... button to export the data
SQL Accounting
Maintain Customer
Menu: Customer | Maintain Customer...
- 01. Click Edit
- 02. Enter the DKSH Outlet Type at CompanyName2
- 03. Click Save
Stock Item
Menu: Stock | Maintain Stock Item...
- 01. Click Edit
- 02. Enter the DKSH Product Code at Description2
- 03. Click Save
See also
- FAQ
- Others Customisation