SQL Acc F&N Import: Difference between revisions

From eStream Software
Line 116: Line 116:
! FnN Field !! Field Position !! Field Size !! SQL Accounting Field
! FnN Field !! Field Position !! Field Size !! SQL Accounting Field
|-
|-
| Item_ID || style="text-align: center;" | 19 || style="text-align: center;" | 10 || Itemcode or <br> Maintain Item Code Note
| Item_ID || style="text-align: center;" | 2 || style="text-align: center;" | 10 || Itemcode or <br> Maintain Item Code Note
|-
|-
| Unit or <br> SubUnits || style="text-align: center;" | 79 or <br>89 || style="text-align: center;" | 10 || Qty
| Unit or <br> SubUnits || style="text-align: center;" | 4 or <br>5 || style="text-align: center;" | 10 || Qty
|-
|-
| Unit_Price || style="text-align: center;" | 99 || style="text-align: center;" | 10 || UnitPrice
| Unit_Price || style="text-align: center;" | 6 || style="text-align: center;" | 10 || UnitPrice
|-
|-
| Discount || style="text-align: center;" | 109 || style="text-align: center;" | 10 || Disc
| Discount || style="text-align: center;" | 7 || style="text-align: center;" | 10 || Disc
|-
|-
| Tax_Code || style="text-align: center;" | 144 || style="text-align: center;" | 5 || Tax
| Tax_Code || style="text-align: center;" | 11 || style="text-align: center;" | 5 || Tax
|-
|-
| SubTotal_Tax_Amount || style="text-align: center;" | 149 || style="text-align: center;" | 10 || TaxAmt
| SubTotal_Tax_Amount || style="text-align: center;" | 13 || style="text-align: center;" | 10 || TaxAmt
|-
|-
| SubTotal_Net_Amount || style="text-align: center;" | 189 || style="text-align: center;" | 10 || Amount
| SubTotal_Net_Amount || style="text-align: center;" | 17 || style="text-align: center;" | 10 || Amount
|}
|}
||
||

Revision as of 03:24, 13 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

Import Program

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 Jun 2016 - CSV Format - Coming Soon...
FnN Field Field Position Field Size SQL Accounting Field
Invoice_Date 1/0 10 DocDate
Invoice_ID 11/1 15 DocNo
Gross Amount 46/4 10 DocAmt
Outlet_ID 186/8 10 Maintain Customer Remark

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
  • As at 15 Jun 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 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

FnN-01.jpg

3. Select the F&N Invoice Text Header File

FnN-02.jpg

4. Select the F&N Invoice Text Detail File

FnN-03.jpg

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

----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Warning-01.jpg

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

Retrieved from "https://wiki.sql.com.my/index.php?title=SQL_Acc_F%26N_Import&oldid=5589"
Last modified
This page was last edited on 13 August 2016, at 03:24.