Nestle: Difference between revisions

From eStream Software
 
(5 intermediate revisions by the same user not shown)
Line 19: Line 19:


==Import Program==
==Import Program==
* Version (1.0.0.0) - XX Sep 2015
* Version (1.0.0.0) - 02 Sep 2015
* http://www.estream.com.my/downloadfile/Fairy/
* http://www.estream.com.my/downloadfile/Fairy/SQLAccNestleImp-setup.exe
 
Recommended use this application [[SQL Acc XLS n MDB Import]]


===History New/Updates/Changes===
===History New/Updates/Changes===
Line 26: Line 28:


==Steps==
==Steps==
::[[File:Nestle-01.jpg|650px]]
::[[File:Nestle-01.jpg|700px]]
# Click '''Get file''' button to get the Excel file.
# Click '''Get file''' button to get the Excel file.
# Select the Excel Tab (if had more then 1 worksheet in 1 excel file)
# Select the Excel Tab (if had more then 1 worksheet in 1 excel file)
Line 32: Line 34:
# Click '''Verify''' button to check the data with SQL Accounting Data
# Click '''Verify''' button to check the data with SQL Accounting Data
# Click '''Post To A/c''' button if confirm all is ok to post to SQL Accounting
# Click '''Post To A/c''' button if confirm all is ok to post to SQL Accounting
==FAQ==
May refer to [[SQL_Accounting_Linking#FAQ|FAQ]]
==See also==
* Others [[Customisation]]

Latest revision as of 08:06, 26 October 2015

Introduction

Is External Program which to import Nestle Excel file to

  • Sales Invoice

Nestle Specification

Tools Required

  • Microsoft Excel

Things to Consider

May refer to Things_to_Consider

Limitation

  • Data will partly import if some of data is not match.
 Eg if IN15371432 had 3 rows but 1 of it had invalid itemcode & if user not careful & direct post system 
    will only post 2 records only

Import Program

Recommended use this application SQL Acc XLS n MDB Import

History New/Updates/Changes

--Build 0--

Steps

Nestle-01.jpg
  1. Click Get file button to get the Excel file.
  2. Select the Excel Tab (if had more then 1 worksheet in 1 excel file)
  3. Click Get Data button to load the data from the selected worksheet
  4. Click Verify button to check the data with SQL Accounting Data
  5. Click Post To A/c button if confirm all is ok to post to SQL Accounting

FAQ

May refer to FAQ

See also