SQL Acc Unilever Import: Difference between revisions

From eStream Software
Line 69: Line 69:
===In Unilever Import===
===In Unilever Import===
This can be see under '''Tools | Options'''
This can be see under '''Tools | Options'''
 
{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
! 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)
|}
<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>



Revision as of 10:19, 24 October 2017

Introduction

Is External Shareware Program which to import Unilever CSV file to

  • Sales Invoice
  • Sales Credit Note

Unilever Specification

Import Program

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

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)

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