Skip to main content

SQL Acc Michelin Export

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

Limitataion​

  • 1 Computer only can export 1 Company Database only

Michelin Export Specification​

Export Program​

  • Version (1.2.0.8) - 13 May 2020
  • Evaluation Limit : 30 Times Export
  • SQLAccMichelinExport-setup
  • MD5 : 64541BCDE1FE677BD001E820B5ADA865

Settings​

Firebird​

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

1

Export Program Setting​

2

  1. Enter the Server Name or IP Address
  2. Click the button & select the Database to be export out.
  3. Select the Output Path
  4. Enter the Branch Code (optional) given by Michelin (may leave it empty if unavailable)
  5. Enter the Supplier Code for Michelin
  6. Select the Start Date to export (ONLY for 1st time use & make sure not more then 1(min)/2(max) month(s) from now)
  7. Select Number of Month to generate (min 0 & max 1).
  8. Click Test Connection to make sure is successfully Connected.

Windows Schedule​

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

    3

  2. Click Action | Create Basic Task...

    4

  3. Enter Task Name (eg SQL Acc Michelin Export) & Click Next.

    5

  4. Select Daily & Click Next.

    6

  5. Set the Start Date & Time to Start.

  6. Set 1 for Recur every field & Click Next.

    7

  7. Select Start a program & Click Next.

    8

  8. Click Browse button & find the SQLAccMichelinExportSchedule.exe (Default at C:\eStream\Utilities\SQLAccMichelinExport).

  9. Set the Start in(optional) path to the Exe folder (eg. C:\eStream\Utilities\SQLAccMichelinExport) & Click Next.

    9

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

  11. Click Finish.

    10

  12. Select the option Run whether user is logged on or not.

  13. Click Triggers tab at top.

    11

  14. Click Edit... button.

    12

  15. Change the time to run.

  16. Click OK 2 times.

    13

  17. Enter the window User Name & Password.

  18. Click Ok.

SQL Accounting​

14

  1. Click Stock | Maintain Stock Item...
  2. Look for the Michelin Item Code.
  3. Click Edit.
  4. Click Supp. Item tab.
  5. Click + button.
  6. Select the Supplier Code for Michelin.
  7. Enter the Michelin Item Code.
  8. Click Save.
  9. Repeat Step 2 till Step 8 for other Michelin Item Code.

Program History New/Updates/Changes​

--Build 8--

  • Fixed Prompt Access Violation on Export.

--Build 7--

  • Enable support Version 875.782 & above for REGISTERNO field Only.

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