SQL Acc DKSH Export: Difference between revisions

From eStream Software
(Created page with "==Introduction== Is External Shareware Program which Export Data for DKSH System.<br /> Document Type Export * ==Limitation== * 1 Computer only can export 1 Company Database...")
 
 
(22 intermediate revisions by the same user not shown)
Line 2: Line 2:
Is External Shareware Program which Export Data for DKSH System.<br />
Is External Shareware Program which Export Data for DKSH System.<br />
Document Type Export
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==
==Limitation==
* 1 Computer only can export 1 Company Database only
* 1 Computer only can export 1 Company Database only
==DKSH Specification==
* 03 Jun 2016
* http://www.estream.com.my/downloadfile/Fairy/DKSH_ManageSales_Integration_Spec.zip


==Export Program==
==Export Program==
* Version (1.1.0.1) - Coming soon...
* Version (1.1.0.4) - 06 Jun 2017
* http://www.estream.com.my/downloadfile/Fairy/Export-setup.exe
* Evaluation Limit : 30 Times Export
* MD5 :  
* http://www.estream.com.my/downloadfile/Fairy/SQLAccDKSHExport-setup.exe
* MD5 : 1DDE4D72A1808F0DA0CAA27094B7C821


===History New/Updates/Changes===
===History New/Updates/Changes===
--Build 4--
* Upgrade to Version 1.1.
* Upgrade to XE25.
* Fixed Export still locking even is registered.
--Build 3--
* Fixed Export Slow.
* Add Export Status.
--Build 2--
* Fixed Register Fail.
--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
[[File:SQLAccMichelin-07.jpg|center]]
<div style="float: right;">  [[#top|[top]]]</div>
===Export Program===
[[File:SQLAccDKSH-03.jpg|center|800px]]
:01. Enter the '''Server Name''' or '''IP Address'''<br />
:02. Click the button & select the '''Database''' to be export out.<br />
:03. Select the '''Output Path''' folder (where DKSH file to be exported to) <br />
:04. Enter the '''Organization prefix''' provide by DKSH<br />
:05. Click '''Test Connection''' to make sure is successfully Connected.<br />
<br />
Below steps is to export data<br />
:06. Select '''Date Range''' data to Export<br />
:07. Click '''Export Output...''' button to export the data <br />
<div style="float: right;">  [[#top|[top]]]</div>
===SQL Accounting===
====Maintain Customer====
''Menu: Customer | Maintain Customer...''
[[File:SQLAccDKSH-01.jpg|center]]
:01. Click ''Edit''
:02. Enter the '''DKSH Outlet Type''' at ''CompanyName2''
:03. Click ''Save''
<div style="float: right;">  [[#top|[top]]]</div>
====Stock Item====
''Menu: Stock | Maintain Stock Item...''
[[File:SQLAccDKSH-02.jpg|center]]
:01. Click ''Edit''
:02. Enter the '''DKSH Product Code''' at ''Description2''
:03. Click ''Save''
<div style="float: right;">  [[#top|[top]]]</div>
==See also==
* [[SQL_Accounting_Linking#FAQ|FAQ]]
* Others [[Customisation]]

Latest revision as of 03:04, 6 June 2017

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

History New/Updates/Changes

--Build 4--

  • Upgrade to Version 1.1.
  • Upgrade to XE25.
  • Fixed Export still locking even is registered.

--Build 3--

  • Fixed Export Slow.
  • Add Export Status.

--Build 2--

  • Fixed Register Fail.

--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

SQLAccMichelin-07.jpg

Export Program

SQLAccDKSH-03.jpg
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...

SQLAccDKSH-01.jpg
01. Click Edit
02. Enter the DKSH Outlet Type at CompanyName2
03. Click Save

Stock Item

Menu: Stock | Maintain Stock Item...

SQLAccDKSH-02.jpg
01. Click Edit
02. Enter the DKSH Product Code at Description2
03. Click Save

See also