SQL SLPH Import

From eStream Software
Revision as of 02:34, 5 December 2020 by Twfaung (talk | contribs) (→‎Steps)

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