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	Header text
class="wikitable"
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

|}

• For Sales Invoice

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

• For Sales Credit Note

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