SQL Acc Mamee Import

Introduction

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

• Sales Invoice
• Sales Credit Note

Limitation

• Fixed Tax Code SR (i.e. all transaction is SR)
• Only support Mamee Product Related file (i.e. file with end HDR or DTL eg INVHDR or INVDTL)

F & N Specification

• 03 Dec 2015
• http://www.estream.com.my/downloadfile/Fairy/Mamee-Acct_Integration_Reference.zip

Import Program

• Version (1.0.0.0) - Coming Soon...
• http://www.estream.com.my/downloadfile/Fairy/SQLAccMameeImp-setup.exe

History New/Updates/Changes

--Build 0--

Field Mapping - Header

For Sales Invoice	For Sales Credit Note
Mamee Field SQL Accounting Field Salesman Code Agent Customer Code Code Invoice Number DocNo Invoice Date DocDate	Mamee Field SQL Accounting Field Transaction Number DocNo Transaction Date DocDate Customer Code Code Salesman Code Agent Invoice Number Example

Field Mapping - Detail

For Sales Invoice	For Sales Credit Note
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	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 Testing 123

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

• Others Customisation