SQL Acc Mamee Import: Difference between revisions

From eStream Software
(Created page with "==Introduction== Is External Program which to import Mamee Text or CSV file to * Sales Invoice ==F & N Specification== * 25 Aug 2015 * http://www.estream.com.my/downloadfile...")
 
Line 13: Line 13:
===History New/Updates/Changes===
===History New/Updates/Changes===
--Build 0--
--Build 0--
==Field Mapping - Header==
{| class="wikitable"
|-
! Mamee Field !! SQL Accounting Field
|-
| Salesman Code || Agent
|-
| Customer Code || Code
|-
| Invoice Number || DocNo
|-
| Invoice Date || DocDate
|}
==Field Mapping - Detail==
{| class="wikitable"
|-
! Mamee Field !! SQL Accounting Field
|-
| Product Code || ItemCode
|-
| Product Index || Seq
|-
| UOM Code || UOM
|-
| Product Quantity || Qty
|-
| UOM List Price || UnitPrice
|-
| Gross Amount || Amount
|-
| Promo Discount || Disc
|-
| Tax Amount || TaxAmt
|}


==Steps==
==Steps==

Revision as of 04:14, 1 December 2015

Introduction

Is External Program which to import Mamee Text or CSV file to

  • Sales Invoice

F & N Specification

Import Program

History New/Updates/Changes

--Build 0--

Field Mapping - Header

Mamee Field SQL Accounting Field
Salesman Code Agent
Customer Code Code
Invoice Number DocNo
Invoice Date DocDate

Field Mapping - Detail

Mamee Field SQL Accounting Field
Product Code ItemCode
Product Index Seq
UOM Code UOM
Product Quantity Qty
UOM List Price UnitPrice
Gross Amount Amount
Promo Discount Disc
Tax Amount TaxAmt

Steps

Below steps is example to import Sales Invoice
1. Click Invoice...

  • More Coming Soon...

FAQ

May refer to FAQ

See also