SQL SLPH Import: Difference between revisions

From eStream Software
Line 32: Line 32:
''Menu : Purchase | Purchase Invoice...''<br />
''Menu : Purchase | Purchase Invoice...''<br />
Below steps is example to import Purchase Invoice<br />
Below steps is example to import Purchase Invoice<br />
[[File:SLPH-02.jpg|center]]
:01. Click '''Get File''' button
[[File:SLPH-03.jpg|center]]
:02. Select the Zip file (exported from [http://www.estream.com.my/downloadfile/Fairy/SQLAccExportV5-setup.exe SQL Export V5])
:03. Click '''Open'''
:04. Select Supplier Code to update
:05. Click '''Change''' Button
:06. Click '''Verify''' button
:07. Click '''Post to A/c''' Button


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

Revision as of 03:01, 7 August 2018

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

  • Fix unable to register Database

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
SLPH-03.jpg
02. Select the Zip file (exported from SQL Export V5)
03. Click Open
04. Select Supplier Code to update
05. Click Change Button
06. Click Verify button
07. Click Post to A/c Button

See also