SQL Acc Mamee Import: Difference between revisions

Revision as of 04:37, 23 March 2016

Introduction

Is External Shareware 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)

Mamee 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

01. Click Invoice...

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

03. Select the Mamee Invoice Text/CSV Header File

04. Click Open

05. Select the Mamee Invoice Text/CSV Detail File

06. Click Open

07. Click Verify button to check the data with SQL Accounting Data

08. 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