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.1.0.2) - 02 May 2016
• http://www.estream.com.my/downloadfile/Fairy/SQLAccMameeImp-setup.exe

History New/Updates/Changes

--Build 2--

• Error on Maintain Agent if Record More then 1

--Build 1--

• Upgrade to Version 1.1
• Add Maintain Agent Function.
• Enable Use Census Number field as SQL Acc Customer Code.

Todo

• Enable Import Non Related Product file

Field Mapping - Header

Product Related

For Sales Invoice	For Sales Credit Note
Mamee Field Field Position SQL Accounting Field Salesman Code 1 Agent Customer Code or Census Number 2 or 18 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 or Census Number 2 or 18 Code Salesman Code 7 Agent Invoice Number 15 DocNoEx

Field Mapping - Detail

Product Related

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

Setting

In SQL Accounting

Make sure this option is Tick under Tools | Options | Customer

• One Cent Different Rounding (Local Currency Fields) for all AR/SL Documents (Recommended)

In Mamee Import

This can be see under Tools | Options

Options	Description
MameeCustomerCodeAsCode	0 : Mamee Census Number check against SQLAcc Customer Code Field 1 : Mamee Customer Code same as SQLAcc Customer Code Field (Recommended)
MameeSalesmanCodeAsAgent	0 : Mamee Salesman Code will use Mamee Import Agent List 1 : Mamee Salesman Code same as SQLAcc Agent Code (Recommended)

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