Nestle

From eStream Software
Revision as of 03:44, 2 September 2015 by Twfaung (talk | contribs) (→‎Steps)

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