SQL Acc Michelin Export: Difference between revisions

From eStream Software
Line 60: Line 60:
04. Enter the '''Branch Code''' (optional) given by Michelin (may leave it empty if unavailable) <br />
04. Enter the '''Branch Code''' (optional) given by Michelin (may leave it empty if unavailable) <br />
05. Enter the '''Supplier Code''' for Michelin <br />
05. Enter the '''Supplier Code''' for Michelin <br />
06. Select the '''Start Date''' to export (''ONLY'' for 1st time use & make sure not more then 2 month from now)<br />
06. Select the '''Start Date''' to export (''ONLY'' for 1st time use & make sure not more then 1(min)/2(max) month(s) from now)<br />
07. Select Number of Month to generate (min 0 & max 1).<br />
07. Select Number of Month to generate (min 0 & max 1).<br />
08. Click '''Test Connection''' to make sure is successfully Connected.<br />
08. Click '''Test Connection''' to make sure is successfully Connected.<br />

Revision as of 09:52, 10 May 2019

Introduction

Is External Shareware Program which Export Daily Sales for Michelin System.
Document Type Export (Only 1 text file)

  • Sales Invoice
  • Sales Cash Sales
  • Sales Debit Note
  • Sales Credit Note

Limitation

  • 1 Computer only can export 1 Company Database only

Michelin Export Specification

Export Program

  • Version (1.2.0.6) - 28 Jan 2019
  • Evaluation Limit : 30 Times Export
  • SQLAccMichelinExport-setup
  • MD5 : D889CD120E8D654F8733710DF0A53B0B

History New/Updates/Changes

--Build 6--

  • Date Not reset on 6th days.

--Build 5--

  • Add No. of Month Option.

--Build 4--

  • Fixed only export 50 due after fix bug in build 3.

--Build 3--

  • Fixed Unable to Export if Description too long.

--Build 2--

  • Upgrade Compiler.
  • Upgrade to Version 1.2.
  • Add Branch Code Field.

--Build 1--

  • Fixed Tab Sequence problem.
  • Add filter by Supplier Code.
  • Date Reset On 4th Months.

--Build 0--

Todo

Settings

Firebird

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

SQLAccMichelin-07.jpg

Export Program

SQLAccMichelin-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 Branch Code (optional) given by Michelin (may leave it empty if unavailable)
05. Enter the Supplier Code for Michelin
06. Select the Start Date to export (ONLY for 1st time use & make sure not more then 1(min)/2(max) month(s) from now)
07. Select Number of Month to generate (min 0 & max 1).
08. Click Test Connection to make sure is successfully Connected.

Windows Schedule

01. Open Windows Control Panel | Administrative Tools | Task Scheduler

Scheduler.Task1.jpg

02. Click Action | Create Basic Task...

SQLAccMichelin-02.jpg

03. Enter Task Name (eg SQL Acc Michelin 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

SQLAccMichelin-03.jpg

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

SQLAccMichelin-04.jpg

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

SQLAccMichelin-05.jpg

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

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

SQL Accounting

SQLAccMichelin-08.jpg
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

See also