SQL Acc Unilever Import

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

• 07 Feb 2018
• http://www.estream.com.my/downloadfile/Fairy/UnileverImp-Structure-20180207.zip
• 25 Sep 2017
• http://www.estream.com.my/downloadfile/Fairy/UnileverImp-Structure-20170925.zip

[top]

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

[top]

Todo

[top]

Field Mapping - Header

• 25 Sep 2017

Unilever Field	Field Position	Field Size	SQL Accounting Field
INVH_Type	1	2	01 - Sales Invoice 02 - Sales Credit Note
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	01 - Sales Invoice 02 - Sales Credit Note
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

[top]

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	0 Tax Code = ZRL 6 Tax Code = SR
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	0 Tax Code = ZRL 6 Tax Code = SR
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

[top]

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 for Cases in SQL Accounting Default is CA
UOM_Pieces	UOM for Pieces in SQL Accounting Default is PCS
RetailAsCompCode	0 : Unilever Retail Code will check against SQL Accounting | Maintain Customer | Remark Field 1 : Unilever Retail Code same as SQL Accounting Customer Code (Recommended)
UnileverCodeAsItemCode	0 : Unilever Item Code will check against SQL Accounting | Maintain Item | Note Field 1 : Unilever Item Code same as SQL Accounting Item Code (Recommended)
TaxCodeZRL	Tax code for 0%
TaxCodeSR	Tax Code other then 0%

[top]

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

[top]

FAQ

May refer to FAQ

See also

• Others Customisation