(→Steps) |
|||
| Line 57: | Line 57: | ||
1. Click '''Sales | Invoice...'''<br /> | 1. Click '''Sales | Invoice...'''<br /> | ||
2. Click '''Get File''' button & system will prompt 2 dialog like below<br /> | 2. Click '''Get File''' button & system will prompt 2 dialog like below<br /> | ||
[[File:FnN-01.jpg|center]] | |||
3. Select the F&N Invoice Text Header File | 3. Select the F&N Invoice Text Header File | ||
[[File:FnN-02.jpg|center]] | |||
4. Select the F&N Invoice Text Detail File | 4. Select the F&N Invoice Text Detail File | ||
[[File:FnN-03.jpg | 700px|center]] | |||
5. Click '''Verify''' button to check the data with SQL Accounting Data<br /> | 5. Click '''Verify''' button to check the data with SQL Accounting Data<br /> | ||
6. Click '''Post To A/c''' button if confirm all is ok to post to SQL Accounting<br /> | 6. Click '''Post To A/c''' button if confirm all is ok to post to SQL Accounting<br /> | ||
Revision as of 05:43, 31 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
- ----------------------------------------------------------------------------------------------------------------------------------------------------
FAQ
May refer to FAQ
See also
- Others Customisation