SQL Acc Mamee Import

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

Todo

• Census Number = SQL Accounting Customer Code
• Allow Save Mamee Salesman Code to match SQL Acc Agent code

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

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

FAQ

May refer to FAQ

See also

• Others Customisation