| Line 43: | Line 43: | ||
|- | |- | ||
| FNCodeAsItemCode || | | FNCodeAsItemCode || | ||
* 0 : F&N ItemCode will check against | * 0 : F&N ItemCode will check against SQL Accounting | Maintain Item | Note Field | ||
* 1 : F&N Itemcode same as | * 1 : F&N Itemcode same as SQL Accounting Itemcode (Recommended) | ||
|- | |- | ||
| FNUOMAsUOM || | | FNUOMAsUOM || | ||
| Line 51: | Line 51: | ||
|} | |} | ||
* F&N '''Outlet ID''' should be enter in SQL Accounting | Maintain Customer | Remark | * F&N '''Outlet ID''' should be enter in SQL Accounting | Maintain Customer | Remark Field | ||
==Steps== | ==Steps== | ||
Revision as of 03:12, 7 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
- 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 |
|
| FNCodeAsItemCode |
|
| FNUOMAsUOM |
|
- 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
- ----------------------------------------------------------------------------------------------------------------------------------------------------
See also
- Others Customisation