SQL Acc Samsung Export: Difference between revisions

From eStream Software
(Created page with "==Introduction== Is External Shareware Program which Export Daily Sales for Sumsung System.<br /> Document Type Export * Sales Invoice * Sales Cash Sales * Sales Debit Note *...")
 
 
(22 intermediate revisions by the same user not shown)
Line 1: Line 1:
==Introduction==
==Introduction==
Is External Shareware Program which Export Daily Sales for Sumsung System.<br />
Is External Shareware Program which Export Daily Sales for Samsung System.<br />
Document Type Export
Document Type Export (Total 2 Text files)
* Sales Invoice
* Sales Invoice
* Sales Cash Sales
* Sales Cash Sales
Line 10: Line 10:
==Limitation==
==Limitation==
* 1 Computer only can export 1 Company Database only
* 1 Computer only can export 1 Company Database only
* <del>1 Item Code 1 Serial Number(Randomly select if more then 1) </del> * Build 2 & above can


==Sumsung Export Specification==
==Samsung Export Specification==
* 28 Oct 2016
* 28 Dec 2016
* http://www.estream.com.my/downloadfile/Fairy/Sumsung-20161028.zip
* [https://download.sql.com.my/customer/Fairy/Samsung-20161228.zip Samsung-20161228.zip]
 
==Modules Require==
* Serial Number


==Export Program==
==Export Program==
* Version (1.0.0.0) - 09 Jul 2017
* Version (1.0.0.3) - 26 Aug 2017
* Evaluation Limit : 30 Times Export
* Evaluation Limit : 30 Times Export
* http://www.estream.com.my/downloadfile/Fairy/SQLAccSumsungExport-setup.exe
* [https://download.sql.com.my/customer/Fairy/SQLAccSamsungExport-setup.exe SQLAccSamsungExport-setup.exe]
* MD5 : 45D089291465C9DC894E85CE800D09FF
* MD5 : 5D901D5505F597B69D85826C7FA5BB42


===History New/Updates/Changes===
===History New/Updates/Changes===
--Build 3--
* Fixed click 2nd time Test output prompt error.
* Fixed Schedule not running.
--Build 2--
* Support Export more then 1 Serial Number Output.
* Fixed spelling error.
--Build 1--
* MCS_SALES_xxx should take Agent Description.
* Filename for Stock should be MCS_INV_xxx.
* Stock Column incorrect position.


--Build 0--
--Build 0--
Line 35: Line 51:
<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>
===Export Program===
===Export Program===
[[File:SQLAccMichelin-01.jpg|center|800px]]
[[File:SQLAccSumsung-01.jpg|center|800px]]
01. Enter the '''Server Name''' or '''IP Address'''<br />
:01. Enter the '''Server Name''' or '''IP Address'''
02. Click the button & select the '''Database''' to be export out.<br />
:02. Click the button & select the '''Database''' to be export out.
03. Select the '''Output Path'''<br />
:03. Select the '''Output Path'''
04. Enter the '''Supplier Code''' for Michelin
:04. Enter the '''Samsung Co Code''' provided by Samsung
05. Select the '''Start Date''' to export (''ONLY'' for 1st time use & make sure not more then 3 month from now)<br />
:05. Click '''Test Connection''' to make sure is successfully Connected.
06. Click '''Test Connection''' to make sure is successfully Connected.<br />
:06. Click '''More Stock Group...''' to select the Stock Group to export
:07. Select the '''Date''' to export (''ONLY'' for 1st time use)
:08. Click '''Test Output...''' to testing export out.
 


<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>
===Windows Schedule===
===Windows Schedule===
01. Open Windows ''Control Panel | Administrative Tools | Task Scheduler''
:01. Open Windows ''Control Panel | Administrative Tools | Task Scheduler''
[[File:Scheduler.Task1.jpg|center|700px]]
[[File:Scheduler.Task1.jpg|center|700px]]
02. Click ''Action | Create Basic Task...''
:02. Click ''Action | Create Basic Task...''
[[File:SQLAccMichelin-02.jpg|center]]
[[File:SQLAccSumsung-02.jpg|center]]
03. Enter Task ''Name'' (eg SQL Acc Michelin Export) & Click Next
:03. Enter Task ''Name'' (eg SQL Acc Sumsung Export) & Click Next
[[File:Scheduler.Task3.jpg|center|700px]]
[[File:Scheduler.Task3.jpg|center|700px]]
04. Select Daily & Click Next
:04. Select Daily & Click Next
[[File:Scheduler.Task4.jpg|center|700px]]
[[File:Scheduler.Task4.jpg|center|700px]]
05. Set the ''Start Date & Time'' to Start<br />
05. Set the ''Start Date & Time'' to Start<br />
Line 57: Line 77:
[[File:Scheduler.Task5.jpg|center|700px]]
[[File:Scheduler.Task5.jpg|center|700px]]
07. Select ''Start a program'' & Click Next
07. Select ''Start a program'' & Click Next
[[File:SQLAccMichelin-03.jpg|center]]
[[File:SQLAccSumsung-03.jpg|center]]
08. Click Browse button & find the '''SQLAccMichelinExportSchedule.exe''' (Default at ''C:\eStream\Utilities\SQLAccMichelinExport'')<br />
08. Click Browse button & find the '''SQLAccSumsungExportSchedule.exe''' (Default at ''C:\eStream\Utilities\SQLAccSumsungExport'')<br />
09. Set the Start in(optional) path to the Exe folder (eg. ''C:\eStream\Utilities\SQLAccMichelinExport'') & Click Next
09. Set the Start in(optional) path to the Exe folder (eg. ''C:\eStream\Utilities\SQLAccSumsungExport'') & Click Next
[[File:SQLAccMichelin-04.jpg|center]]
[[File:SQLAccSumsung-04.jpg|center]]
10. Tick the option ''Open the Properties dialog for this task when I click Finish''<br />
10. Tick the option ''Open the Properties dialog for this task when I click Finish''<br />
11. Click Finish
11. Click Finish
[[File:SQLAccMichelin-05.jpg|center]]
[[File:SQLAccSumsung-05.jpg|center]]
12. Select the option ''Run whether user is logged on or not''<br />
12. Select the option ''Run whether user is logged on or not''<br />
13. Click ''Triggers'' tab at top<br />
13. Click ''Triggers'' tab at top<br />
[[File:SQLAccMichelin-06.jpg|center]]
[[File:SQLAccSumsung-06.jpg|center]]
14. Click Edit... button
14. Click Edit... button
[[File:Scheduler.Task12.jpg|center]]
[[File:Scheduler.Task12.jpg|center]]
Line 74: Line 94:
17. Enter the window User Name & Password<br />
17. Enter the window User Name & Password<br />
18. Click Ok
18. Click Ok
<div style="float: right;">  [[#top|[top]]]</div>
===SQL Accounting===
[[File:SQLAccMichelin-08.jpg|center|800px]]
:01. Click ''Stock | Maintain Stock Item...''
:02. Look for the Michelin Item Code
:03. Click '''Edit'''
:04. Click '''Supp. Item''' tab
:05. Click '''+''' button
:06. Select the '''Supplier Code''' for ''Michelin''
:07. Click '''Save'''
:08. Repeat '''Step 2''' till '''Step 7''' for other Michelin Item Code


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

Latest revision as of 05:51, 12 May 2022

Introduction

Is External Shareware Program which Export Daily Sales for Samsung System.
Document Type Export (Total 2 Text files)

  • Sales Invoice
  • Sales Cash Sales
  • Sales Debit Note
  • Sales Credit Note
  • Stock Physical Worksheet

Limitation

  • 1 Computer only can export 1 Company Database only
  • 1 Item Code 1 Serial Number(Randomly select if more then 1) * Build 2 & above can

Samsung Export Specification

Modules Require

  • Serial Number

Export Program

History New/Updates/Changes

--Build 3--

  • Fixed click 2nd time Test output prompt error.
  • Fixed Schedule not running.

--Build 2--

  • Support Export more then 1 Serial Number Output.
  • Fixed spelling error.

--Build 1--

  • MCS_SALES_xxx should take Agent Description.
  • Filename for Stock should be MCS_INV_xxx.
  • Stock Column incorrect position.

--Build 0--

Todo

Settings

Firebird

During Installation of Firebird make sure the option (see Below picture) is selected

SQLAccMichelin-07.jpg

Export Program

SQLAccSumsung-01.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 Samsung Co Code provided by Samsung
05. Click Test Connection to make sure is successfully Connected.
06. Click More Stock Group... to select the Stock Group to export
07. Select the Date to export (ONLY for 1st time use)
08. Click Test Output... to testing export out.


Windows Schedule

01. Open Windows Control Panel | Administrative Tools | Task Scheduler
Scheduler.Task1.jpg
02. Click Action | Create Basic Task...
SQLAccSumsung-02.jpg
03. Enter Task Name (eg SQL Acc Sumsung Export) & Click Next
Scheduler.Task3.jpg
04. Select Daily & Click Next
Scheduler.Task4.jpg

05. Set the Start Date & Time to Start
06. Set 1 for Recur every field & Click Next

Scheduler.Task5.jpg

07. Select Start a program & Click Next

SQLAccSumsung-03.jpg

08. Click Browse button & find the SQLAccSumsungExportSchedule.exe (Default at C:\eStream\Utilities\SQLAccSumsungExport)
09. Set the Start in(optional) path to the Exe folder (eg. C:\eStream\Utilities\SQLAccSumsungExport) & Click Next

SQLAccSumsung-04.jpg

10. Tick the option Open the Properties dialog for this task when I click Finish
11. Click Finish

SQLAccSumsung-05.jpg

12. Select the option Run whether user is logged on or not
13. Click Triggers tab at top

SQLAccSumsung-06.jpg

14. Click Edit... button

Scheduler.Task12.jpg

15. Change the time to run
16. Click OK 2 times

Scheduler.Task10.jpg

17. Enter the window User Name & Password
18. Click Ok

See also

Retrieved from "https://wiki.sql.com.my/index.php?title=SQL_Acc_Samsung_Export&oldid=11771"
Last modified
This page was last edited on 12 May 2022, at 05:51.