SQL Acc F&N Import: Difference between revisions

From eStream Software
Line 73: Line 73:
|}
|}
:::----------------------------------------------------------------------------------------------------------------------------------------------------
:::----------------------------------------------------------------------------------------------------------------------------------------------------
==FAQ==
May refer to [[SQL_Accounting_Linking#FAQ|FAQ]]


==See also==
==See also==
* Others [[Customisation]]
* Others [[Customisation]]

Revision as of 03:52, 23 October 2015

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

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

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

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