SQL SLPH Import: Difference between revisions

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

Version (5.2.1.8) - 17 Feb 2023
https://download.sql.com.my/customer/Fairy/SQLAccSLPHV5-setup.exe
MD5 : 54B8EE0427C28BE48E8BC6F0FE87334F

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

01. Click New/Edit to Insert or update

02. Select Sales Tax Code

03. Select Purchase Tax Code

04. Click Post/Save

[top]

Steps

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

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

@@ Line 2: / Line 2: @@
 Is External Shareware Program which Convert Sales to Purchase Module or vice versa which exported from SQL Accounting<br />
 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==
-* Version (4.1.0.2) - Coming Soon...
+* Version (5.2.1.8) - 17 Feb 2023
-* http://www.estream.com.my/downloadfile/Fairy/-setup.exe
+* https://download.sql.com.my/customer/Fairy/SQLAccSLPHV5-setup.exe
+* MD5 : 54B8EE0427C28BE48E8BC6F0FE87334F
 ===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 [[SQL_Accounting_Linking#Things_To_Consider_Before_Import.2FPost|Things To Consider Before Import/Post]]<br />
+:02. Make sure this option is Tick under '''Tools | Options | Customer'''
+:* Perform Tax/Local Amount Rounding
+===In SLPH Import===
+''Menu : '''Tools | Maintain Tax'''''
+[[File:SLPH-01.jpg|center]]
+:01. Click New/Edit to Insert or update
+:02. Select '''Sales Tax''' Code
+:03. Select '''Purchase Tax''' Code
+:04. Click '''Post/Save'''
+<div style="float: right;">   [[#top|[top]]]</div>
 ==Steps==
-* Coming Soon...
+''Menu : Purchase | Purchase Invoice...''<br />
+Below steps is example to import Purchase Invoice<br />
+[[File:SLPH-02.jpg|800px|center]]
+: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
+{| class="wikitable" style="margin: 1em auto 1em auto;"
+|-
+! 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==
+* [[SQL_Accounting_Linking#FAQ|FAQ]]
 * Others [[Customisation]]