| Line 25: | Line 25: | ||
<div style="float: right;"> [[#top|[top]]]</div> | <div style="float: right;"> [[#top|[top]]]</div> | ||
==Field Mapping - Header== | ==Field Mapping - Header== | ||
{| class="wikitable" style="margin: 1em auto 1em auto;" | |||
|- | |||
! Unilever Field !! Field Position !! Field Size !! SQL Accounting Field | |||
|- | |||
| INVH_No || style="text-align: center;" | 3 || style="text-align: center;" | 10 || DocNo | |||
|- | |||
| INVH_Retailer || style="text-align: center;" | 17 || style="text-align: center;" | 8 || Code | |||
|- | |||
| INVH_Date || style="text-align: center;" | 26 || style="text-align: center;" | 19 || DocDate | |||
|} | |||
<div style="float: right;"> [[#top|[top]]]</div> | |||
==Field Mapping - Detail== | |||
{| class="wikitable" style="margin: 1em auto 1em auto;" | |||
|- | |||
! Unilever Field !! Field Position !! Field Size !! SQL Accounting Field | |||
|- | |||
| INVR_No || style="text-align: center;" | 3 || style="text-align: center;" | 10 || DocNo | |||
|- | |||
| INVR_Product || style="text-align: center;" | 13 || style="text-align: center;" | 8 || Item Code | |||
|- | |||
| INVR_Cases || style="text-align: center;" | 26 || style="text-align: center;" | 22 || Qty | |||
|- | |||
| INVR_Amount || style="text-align: center;" | 70 || style="text-align: center;" | 21 || Amount | |||
|- | |||
| INVR_CasePrice || style="text-align: center;" | 112 || style="text-align: center;" | 21 || UnitPrice | |||
|- | |||
| INVR_TAXTotal || style="text-align: center;" | 155 || style="text-align: center;" | 21 || GST Amount | |||
|} | |||
<div style="float: right;"> [[#top|[top]]]</div> | <div style="float: right;"> [[#top|[top]]]</div> | ||
Revision as of 09:49, 12 October 2017
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 |
| 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