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
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