SQL SLPH Import

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.7) - 05 Dec 2020
https://www.sql.com.my/downloadfile/Fairy/SQLAccSLPHV5-setup.exe
MD5 : 354B803A806AF235678C29A56DAA966E

History New/Updates/Changes

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