SQL Acc F&N Import: Difference between revisions

Revision as of 06:28, 24 August 2016

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 - ESD soft-drink
http://www.estream.com.my/downloadfile/Fairy/FN-Acct_Integration_Reference-20150617.zip

15 Aug 2016 - ESD Online - Coming Soon...
http://www.estream.com.my/downloadfile/Fairy/FN-Acct_Integration_Reference-20160815.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

As at 17 Jun 2015 - Fixed Length Format

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

As at 15 Aug 2016 - CSV Format - Coming Soon...

FnN Field	Field Position	Field Size	SQL Accounting Field
Invoice_Date	0	10	DocDate
Invoice_ID	1	15	DocNo
Total_Gross_Amount	4	10	DocAmt
Debtor_Code2	9	10	Maintain Customer Code

Field Mapping - Detail

As at 17 Jun 2015 - Fixed Length Format

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
Reference Reference_date Reference_reason	179 189 199	10 10 50	Description2

As at 15 Aug 2016 - CSV Format - Coming Soon...

For Sales Invoice

For Sales Credit Note

FnN Field	Field Position	Field Size	SQL Accounting Field
Item_ID	2	10	Itemcode or Maintain Item Code Note
Unit or SubUnits	4 or 5	10	Qty
Unit_Price	6	10	UnitPrice
Discount	7	10	Disc
Tax_Code	11	5	Tax
SubTotal_Tax_Amount	13	10	TaxAmt
SubTotal_Net_Amount	17	10	Amount

FnN Field	Field Position	Field Size	SQL Accounting Field
Item_ID	2	10	Itemcode or Maintain Item Code Note
Unit or SubUnits	4 or 5	10	Qty
Unit_Price	6	10	UnitPrice
Discount	7	10	Disc
Tax_Code	11	5	Tax
SubTotal_Tax_Amount	13	10	TaxAmt
SubTotal_Net_Amount	19	10	Amount
Reference Reference_date Reference_reason	16 20 17	15 50 10	Description2

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