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 Field Seq SQL Accounting Field Salesman Code 1 Agent Customer Code 2 Code Invoice Number 4 DocNo Invoice Date 6 DocDate	Mamee Field Field Seq SQL Accounting Field Transaction Number 0 DocNo Transaction Date 1 DocDate Customer Code 2 Code Salesman Code 7 Agent Invoice Number 15 DocNoEx

Field Mapping - Detail

For Sales Invoice	For Sales Credit Note
Mamee Field Field Seq SQL Accounting Field Product Code 2 ItemCode Product Index 3 Seq UOM Code 5 UOM Product Quantity 6 Qty UOM List Price 9 UnitPrice Gross Amount 10 Amount Promo Discount 12 Disc Tax Amount 13 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 Promotion Discount Disc Tax Amount TaxAmt Reason Description Description2

Steps

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

• More Coming Soon...

FAQ

May refer to FAQ

See also

• Others Customisation