SQL Acc DKSH Export: Difference between revisions

From eStream Software
Line 29: Line 29:
<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>
===Export Program===
===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'''<br />
04. Enter the '''Organization prefix''' provide by DKSH
05. Click '''Test Connection''' to make sure is successfully Connected.<br />


<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>
===SQL Accounting===
===SQL Accounting===
====Maintain Customer====
====Maintain Customer====

Revision as of 02:17, 25 July 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

Export Program

History New/Updates/Changes

--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
04. Enter the Organization prefix provide by DKSH 05. Click Test Connection to make sure is successfully Connected.

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