SQL Acc Unilever Import: Difference between revisions

From eStream Software
Line 61: Line 61:


==Field Mapping - Detail==
==Field Mapping - Detail==
* 25 Sep 2017
{| class="wikitable" style="margin: 1em auto 1em auto;"
{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
|-
Line 84: Line 85:
| INVR_TAXTotal || style="text-align: center;" | 155 || style="text-align: center;" | 21 || GST Amount
| INVR_TAXTotal || style="text-align: center;" | 155 || style="text-align: center;" | 21 || GST Amount
|}
|}
* 07 Feb 2018
{| 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;" | 12 || DocNo
|-
| INVR_Product || style="text-align: center;" | 15 || style="text-align: center;" | 8 || Item Code or
Maintain Item Code Note
|-
| INVR_Cases || style="text-align: center;" | 28 || style="text-align: center;" | 22 || Qty (UOM=CA)
|-
| INVR_Pieces || style="text-align: center;" | 50 || style="text-align: center;" | 22 || Qty (UOM=PCS)
|-
| INVR_Amount || style="text-align: center;" | 72 || style="text-align: center;" | 21 || Amount
|-
| INVR_Discount || style="text-align: center;" | 93 || style="text-align: center;" | 21 || Discount
|-
| INVR_TAXRate || style="text-align: center;" | 135 || style="text-align: center;" | 22 ||
* 0 Tax Code = ZRL
* 6 Tax Code = SR
|-
| INVR_TAXTotal || style="text-align: center;" | 157 || style="text-align: center;" | 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
* Unit Price will not import & will auto Assign by SQL Accounting due to Unilever file don't had Pieces Price & UOM Rate



Revision as of 04:46, 20 February 2018

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

  • 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


  • 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

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

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

Unilever-01.jpg

03. Select the Unilever Invoice Text Header File

Unilever-02.jpg

04. Select the Unilever Invoice Text Detail File

Unilever-03.jpg

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