SQL Acc F&N Import

Introduction

Is External Shareware 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
• MD5 : B33D2565876D2E61DA90D682DA50B1E2

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

Field Mapping - Header

FnN Field	Field Position	Field Size	SQL Accounting Field
Invoice_Date	1	10	DocDate
Outlet_ID	71	10	Maintain Customer Remark
Invoice_ID	11	10	DocNo
Gross Amount	41	10	DocAmt

Field Mapping - Detail

For Sales Invoice

For Sales Credit Note

FnN Field Field Position Field Size SQL Accounting Field Item_ID 14 10 Itemcode or Maintain Item Code Note Unit or SubUnits 74 or 84 10 Qty Unit_Price 94 10 UnitPrice Discount 104 10 Disc Tax_Code 139 5 Tax SubTotal_Tax_Amount 149 10 TaxAmt SubTotal_Net_Amount 189 10 Amount

FnN Field Field Position Field Size SQL Accounting Field Item_ID 14 10 Itemcode or Maintain Item Code Note Unit or SubUnits 74 or 84 10 Qty Unit_Price 94 10 UnitPrice Discount 104 10 Disc Tax_Code 139 5 Tax SubTotal_Tax_Amount 149 10 TaxAmt SubTotal_Net_Amount 259 10 Amount Setting In SQL Accounting Make sure this option is Tick under Tools | Options | Customer One Cent Different Rounding (Local Currency Fields) for all AR/SL Documents (Recommended) In F&N Import 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 (Recommended) 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