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 TransactionNumber DocNo TransactionDate DocDate CustomerCode Code SalesmanCode Agent InvoiceNumber Example

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

• Others Customisation