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-ExampleFile.zip

Import Program

Version (1.0.0.0) - 04 Dec 2015
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 Position	SQL Accounting Field
Salesman Code	1	Agent
Customer Code	2	Code
Invoice Number	4	DocNo
Invoice Date	6	DocDate

Mamee Field	Field Position	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 Position	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	Field Position	SQL Accounting Field
Product Code	8	ItemCode
Product Index	6	Seq
UOM Code	14	UOM
Product Quantity	16	Qty
UOM List Price	18	UnitPrice
Gross Amount	19	Amount
Promotion Discount	21	Disc
Tax Amount	23	TaxAmt
Reason Description	26	Description2

Steps

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

2. Click Get File button & system will prompt 2 dialog like below

3. Select the Mamee Invoice Text/CSV Header File
4. Click Open

5. Select the Mamee Invoice Text/CSV Detail File
6. Click Open
7. Click Verify button to check the data with SQL Accounting Data
8. Click Post To A/c button if confirm all is ok to post to SQL Accounting

----------------------------------------------------------------------------------------------------------------------------------------------------

Record(s) will only Post if the Check Box is Tick & Status is Ok