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
Export Program
- Version (1.0.0.1) - 25 Aug 2016
- 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
- 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