SQL Acc Unilever Import

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

[top]

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

[top]

Todo

[top]

Field Mapping - Header

Unilever Field	Field Position	Field Size	SQL Accounting Field
INVH_No	3	10	DocNo
INVH_Retailer	17	8	Code or Maintain Customer Remark
INVH_Date	26	19	DocDate

[top]

Field Mapping - Detail

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_TAXTotal	155	21	GST Amount

• Unit Price will not import & will auto Assign by SQL Accounting due to Unilever file don't had Pieces Price

[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

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)

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

[top]

FAQ

May refer to FAQ

See also

• Others Customisation