Nestle: Difference between revisions

From eStream Software
No edit summary
Line 27: Line 27:
==Steps==
==Steps==
::[[File:Nestle-01.jpg|650px]]
::[[File:Nestle-01.jpg|650px]]
# Click '''Get file''' button to get the Excel file.
# Select the Excel Tab (if had more then 1 worksheet in 1 excel file)
# Click '''Get Data''' button to load the data from the selected worksheet
# 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

Revision as of 03:44, 2 September 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

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