Nestle

Introduction

Is External Program which to import Nestle Excel file to

• Sales Invoice

Nestle Specification

• 17 Jun 2015
• http://www.estream.com.my/downloadfile/Fairy/Nestle-Excel_format.zip

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

• Version (1.0.0.0) - 02 Sep 2015
• http://www.estream.com.my/downloadfile/Fairy/SQLAccNestleImp-setup.exe

History New/Updates/Changes

--Build 0--

Steps

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

• Others Customisation