SQL Acc F&N Import

Introduction

Is External Program which to import F&N Text file to

• Sales Invoice
• Sales Credit Note

Limitation

• TaxCode with DS will not import.

F & N Specification

• 17 Jun 2015
• http://www.estream.com.my/downloadfile/Fairy/FN-Acct_Integration_Reference.zip

Import Program

• Version (2.1.0.9) - 26 Jun 2015
• http://www.estream.com.my/downloadfile/Fairy/SQLAccFNImp-setup.exe

History New/Updates/Changes

--Build 9--

• Fix unable to import docamt is 0 even is no DS Code.
• Fix Status no dropdown list.
• Fix Detail not Verify.

--Build 8--

• Fix Get File Error when record is without tax code.

--Build 7--

• Fix CN Get File Error.

Todo

• OutletID=Maintain Customer Code

Setting

This can be see under Tools | Options

Options	Description
UOMList	List of UOM available in F&N
DocNoAsDocNo	0 : F&N DocNo will post to SQLAcc DocNoEx Field 1 : F&N DocNo will post to SQLAcc DocNo Field
FNCodeAsItemCode	0 : F&N ItemCode will check against SQL Accounting | Maintain Item | Note Field 1 : F&N Itemcode same as SQL Accounting Itemcode (Recommended)
FNUOMAsUOM	0 : F&N ItemCode will check against UOMList 1 : F&N Itemcode UOM same as SQLAcc Itemcode UOM (Recommended)

• F&N Outlet ID should be enter in SQL Accounting | Maintain Customer | Remark Field

Steps

Below steps is example to import Sales Invoice
1. Click Sales | Invoice...
2. Click Get File button & system will prompt 2 dialog like below

3. Select the F&N Invoice Text Header File

4. Select the F&N Invoice Text Detail File

5. Click Verify button to check the data with SQL Accounting Data
6. Click Post To A/c button if confirm all is ok to post to SQL Accounting

----------------------------------------------------------------------------------------------------------------------------------------------------

Remember to check the data with Has Deemed Supplies column which is Tick as system will by pass posting

----------------------------------------------------------------------------------------------------------------------------------------------------

FAQ

May refer to FAQ

See also

• Others Customisation