SQL SLPH Import: Difference between revisions

From eStream Software
 
(14 intermediate revisions by the same user not shown)
Line 8: Line 8:


==Import Program==
==Import Program==
* Version (5.1.0.3) - 07 Aug 2018
* Version (5.2.1.8) - 17 Feb 2023
* http://www.estream.com.my/downloadfile/Fairy/SQLAccSLPHV5-setup.exe
* https://download.sql.com.my/customer/Fairy/SQLAccSLPHV5-setup.exe
* MD5 : FB13A8EE4153FEABAD2F70CFE1BCADDC
* MD5 : 54B8EE0427C28BE48E8BC6F0FE87334F


===History New/Updates/Changes===
===History New/Updates/Changes===
--Build 8--
* Fixed Get File Error due to SEQ field.
* Add Get User Guide... Option.
--Build 7--
* Upgrade to Version 5.2.1.
* Enable Quick Customise Layout for Grid.
* Empty Item Code should by pass from Verify.
* Allow User Override Header Description.
* Enable Support Unicode
--Build 6--
* Fixed Import Sales/Purchase CN & DN Error.
--Build 5--
* Upgrade to Version 5.2.
* Add Option Use My Maintain Supplier/Customer Information for Sales/Purchase Import.
* Enable support Running In Windows Limited User.
--Build 4--
* Fixed Shown TaxCode Even Original no TaxCode.
--Build 3--
--Build 3--
* Fix TaxRate Not Import
* Fix TaxRate Not Import
Line 23: Line 45:
--Build 1--
--Build 1--
* Fix unable to register Database
* Fix unable to register Database
==Todo==


==Settings==
==Settings==
Line 38: Line 62:
:04. Click '''Post/Save'''
:04. Click '''Post/Save'''


<div style="float: right;">  [[#top|[top]]]</div>
==Steps==
==Steps==
''Menu : Purchase | Purchase Invoice...''<br />
''Menu : Purchase | Purchase Invoice...''<br />
Line 43: Line 68:
[[File:SLPH-02.jpg|800px|center]]
[[File:SLPH-02.jpg|800px|center]]
:01. Click '''Get File''' button
:01. Click '''Get File''' button
[[File:SLPH-03.jpg|center]]
:02. Select Supplier Code to update
:02. Select the Zip file (exported from [http://www.estream.com.my/downloadfile/Fairy/SQLAccExportV5-setup.exe SQL Export V5])
:03. Click '''Change''' Button
:03. Click '''Open'''
:04. Click '''Verify''' button
:04. Select Supplier Code to update
:05. Click '''Post to A/c''' Button
:05. Click '''Change''' Button
 
:06. Click '''Verify''' button
{| class="wikitable" style="margin: 1em auto 1em auto;"
:07. Click '''Post to A/c''' Button
|-
! Option !! Description
|-
| Use Supplier Document No  ||
* Tick : Will follow DocNo in the XML
* UnTick : Auto Assign New Document Number In SQL Accounting
|-
| Use My Maintain Supplier Information ||
* Tick : Will follow Maintain Supplier Information
* UnTick : Will follow Document Supplier Information
|-
| Purchase Invoice(Below Use My Maintain Supplier Information Option) ||
* Empty it : Will follow Document Header Description
* With Value : Will follow the value entered in this field for Header Description
|}


==See also==
==See also==
* [[SQL_Accounting_Linking#FAQ|FAQ]]
* [[SQL_Accounting_Linking#FAQ|FAQ]]
* Others [[Customisation]]
* Others [[Customisation]]

Latest revision as of 10:54, 17 February 2023

Introduction

Is External Shareware Program which Convert Sales to Purchase Module or vice versa which exported from SQL Accounting
Normally is use to Export Data From SQL Accounting Database A from Document Type A (Eg Sales Invoice) & Import to SQL Accounting Database B as other Document Type (Eg Purchase Invoice)

Limitation

  • Only support 1 Company Code (i.e. 1 batch 1 Company Code)
  • Both Source & Target must had Same Itemcode

Import Program

History New/Updates/Changes

--Build 8--

  • Fixed Get File Error due to SEQ field.
  • Add Get User Guide... Option.

--Build 7--

  • Upgrade to Version 5.2.1.
  • Enable Quick Customise Layout for Grid.
  • Empty Item Code should by pass from Verify.
  • Allow User Override Header Description.
  • Enable Support Unicode

--Build 6--

  • Fixed Import Sales/Purchase CN & DN Error.

--Build 5--

  • Upgrade to Version 5.2.
  • Add Option Use My Maintain Supplier/Customer Information for Sales/Purchase Import.
  • Enable support Running In Windows Limited User.

--Build 4--

  • Fixed Shown TaxCode Even Original no TaxCode.

--Build 3--

  • Fix TaxRate Not Import
  • Fixed Import Customer/Supplier prompt bad variance type.

--Build 2--

  • Enable Support Version 5 SQL Accounting
  • Add Maintain Tax

--Build 1--

  • Fix unable to register Database

Todo

Settings

In SQL Accounting

01. May refer to Point 2 at Things To Consider Before Import/Post
02. Make sure this option is Tick under Tools | Options | Customer
  • Perform Tax/Local Amount Rounding

In SLPH Import

Menu : Tools | Maintain Tax

SLPH-01.jpg
01. Click New/Edit to Insert or update
02. Select Sales Tax Code
03. Select Purchase Tax Code
04. Click Post/Save

Steps

Menu : Purchase | Purchase Invoice...
Below steps is example to import Purchase Invoice

SLPH-02.jpg
01. Click Get File button
02. Select Supplier Code to update
03. Click Change Button
04. Click Verify button
05. Click Post to A/c Button
Option Description
Use Supplier Document No
  • Tick : Will follow DocNo in the XML
  • UnTick : Auto Assign New Document Number In SQL Accounting
Use My Maintain Supplier Information
  • Tick : Will follow Maintain Supplier Information
  • UnTick : Will follow Document Supplier Information
Purchase Invoice(Below Use My Maintain Supplier Information Option)
  • Empty it : Will follow Document Header Description
  • With Value : Will follow the value entered in this field for Header Description

See also