Introduction
Is External Shareware Program which to import Unilever CSV file to
- Sales Invoice
- Sales Credit Note
Limitation
Problem if Unilever use both Cases and Pieces for 1 row (will bypass Pieces)- Not valid for Build 7 & above
Unilever Specification
Import Program
- Version (1.2.1.9) - 13 Oct 2019
- Evaluation Limit : 100 Records per file
- SQLAccUnileverImp-setup.exe
- MD5 : AED487D03930BE65B48770AB1DA40636
History New/Updates/Changes
--Build 9--
- Add Copy Cell Value Function.
- Add Auto Add Rounding for DocAmt <> Total Detail Amount.
--Build 8--
- Fixed Find Company Code not Correct if almost same Retail Code.
- Fixed Setting loss after uninstall.
--Build 7--
- Upgrade to Version 1.2.
- Enable Support if Unilever using Both Cases and Pieces for 1 row by Convert to Smallest UOM for Cases.
--Build 6--
- Add ZRL & SR TaxCode Option
--Build 5--
- Fix Header DocNo not match with Detail DocNo
--Build 4--
- Verify DocNo not correct for Old Format import
- Amount should deduct Discount before append
--Build 3--
- Upgrade to Version 1.1.
- Add back Old Format Import with auto add 00 in-front of DocNo before Post to Account.
--Build 2--
- Fixed UnitPrice 0 when After Post to Account.
--Build 1--
- Update New Format.
--Build 0--
Todo
Field Mapping - Header
- 25 Sep 2017
| Unilever Field | Field Position | Field Size | SQL Accounting Field |
|---|---|---|---|
| INVH_Type | 1 | 2 |
|
| INVH_No | 3 | 10 | DocNo |
| INVH_Retailer | 17 | 8 | Code or Maintain Customer Remark |
| INVH_Date | 26 | 19 | DocDate |
| INVH_Total | 141 | 21 | Amount Before Discount |
| INVH_Discount | 162 | 21 | Discount Amount |
- 07 Feb 2018
| Unilever Field | Field Position | Field Size | SQL Accounting Field |
|---|---|---|---|
| INVH_Type | 1 | 2 |
|
| INVH_No | 3 | 12 | DocNo |
| INVH_Retailer | 19 | 8 | Code or Maintain Customer Remark |
| INVH_Date | 28 | 19 | DocDate |
| INVH_Total | 143 | 21 | Amount Before Discount |
| INVH_Discount | 164 | 21 | Discount Amount |
Field Mapping - Detail
- 25 Sep 2017
| Unilever Field | Field Position | Field Size | SQL Accounting Field |
|---|---|---|---|
| INVR_No | 3 | 10 | DocNo |
| INVR_Product | 13 | 8 | Item Code or
Maintain Item Code Note |
| INVR_Cases | 26 | 22 | Qty (UOM=CA) |
| INVR_Pieces | 48 | 22 | Qty (UOM=PCS) |
| INVR_Amount | 70 | 21 | Amount |
| INVR_Discount | 91 | 21 | Discount |
| INVR_TAXRate | 133 | 22 |
|
| INVR_TAXTotal | 155 | 21 | GST Amount |
- 07 Feb 2018
| Unilever Field | Field Position | Field Size | SQL Accounting Field |
|---|---|---|---|
| INVR_No | 3 | 12 | DocNo |
| INVR_Product | 15 | 8 | Item Code or
Maintain Item Code Note |
| INVR_Cases | 28 | 22 | Qty (UOM=CA) |
| INVR_Pieces | 50 | 22 | Qty (UOM=PCS) |
| INVR_Amount | 72 | 21 | Amount |
| INVR_Discount | 93 | 21 | Discount |
| INVR_TAXRate | 135 | 22 |
|
| INVR_TAXTotal | 157 | 21 | GST Amount |
- Unit Price will not import & will auto Assign by SQL Accounting due to Unilever file don't had Pieces Price & UOM Rate
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
03. Menu: Stock | Maintain Stock Item...
- Item Code to be create
- Rounding
In Unilever Import
This can be see under Tools | Options
| Options | Description |
|---|---|
| UOM_Cases |
|
| UOM_Pieces |
|
| RetailAsCompCode |
|
| UnileverCodeAsItemCode |
|
| TaxCodeZRL | Tax code for 0% |
| TaxCodeSR | Tax Code other then 0% |
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. Select the Unilever Invoice Text Header File
04. Select the Unilever Invoice Text Detail File
05. Click Verify button to check the data with SQL Accounting Data
06. Select Project & Location (if Required)
07. Click Post To A/c button if confirm all is ok to post to SQL Accounting
FAQ
May refer to FAQ
See also
- Others Customisation