Introduction
Is External Shareware Program which to import Unilever CSV file to
- Sales Invoice
- Sales Credit Note
Unilever Specification
- 25 Sep 2017
- http://www.estream.com.my/downloadfile/Fairy/...
Import Program
- Version (1.0.0.0) - 00 2017
- Evaluation Limit : 100 Records per file
- http://www.estream.com.my/downloadfile/Fairy/-setup.exe
- MD5 : Coming Soon...
History New/Updates/Changes
--Build 0--
Todo
Field Mapping - Header
| Unilever Field | Field Position | Field Size | SQL Accounting Field |
|---|---|---|---|
| INVH_No | 3 | 10 | DocNo |
| INVH_Retailer | 17 | 8 | Code |
| INVH_Date | 26 | 19 | DocDate |
Field Mapping - Detail
| Unilever Field | Field Position | Field Size | SQL Accounting Field |
|---|---|---|---|
| INVR_No | 3 | 10 | DocNo |
| INVR_Product | 13 | 8 | Item Code |
| INVR_Cases | 26 | 22 | Qty (UOM=CA) |
| INVR_Pieces | 26 | 22 | Qty (UOM=PCS) |
| INVR_Amount | 70 | 21 | Amount |
| INVR_CasePrice | 112 | 21 | UnitPrice |
| INVR_TAXTotal | 155 | 21 | GST Amount |
Setting
In SQL Accounting
01. May refer to Point 2 at Things To Consider Before Import/Post
02. Make sure this option is Tick under Tools | Options | Customer
- Perform Tax/Local Amount Rounding
In Unilever Import
This can be see under Tools | Options
Steps
Below steps is example to import Sales Invoice
01. Click Sales | Invoice...
02. Click Get File button & system will prompt 2 dialog like below
03.
FAQ
May refer to FAQ
See also
- Others Customisation