SQL Acc Mamee Import

Introduction

Is External Shareware Program which to import Mamee Text or CSV file to

• Sales Invoice
• Sales Credit Note
• Sales Debit Note (Non Product Related Only)

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

Format 1

• 03 Dec 2015
• http://www.estream.com.my/downloadfile/Fairy/Mamee-ExampleFile.zip

Format 2

• 22 Nov 2017
• http://www.estream.com.my/downloadfile/Fairy/Mamee-ExampleFile2.zip

Import Program

• Version (2.4.0.5) - 08 Dec 2017
• Evaluation Limit : 100 Records per file
• http://www.estream.com.my/downloadfile/Fairy/SQLAccMameeImp-setup.exe
• MD5 : F64F660ACB5D6E42EAE752FF8D183FDC

History New/Updates/Changes

--Build 5--

• Upgrade to Version 2.4.
• Upgrade to New Compiler.
• Add Format 2 import.

--Build 4--

• Upgrade to Version 1.3.
• Add Maintain Non-Product GL Function.
• Enable Import Non-Product Sales CN & DN Import

--Build 3--

• Upgrade to Version 1.2.
• Error in matching Agent
• Amount not excluding Disc Amount after Import.
• Add Link to SQL Acc. File | Run.
• Rearrange Detail column
• Fix Detail not Sort by Seq
• Set Disc to 2 Decimal Point.

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

[top]

Field Mapping - Header

Product Related - Format 1

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

Product Related - Format 2

For Sales Invoice	For Sales Credit Note
Mamee Field Field Position SQL Accounting Field Salesman Code 3 Agent Customer Code or Census Number 1 or 31 Code Invoice Number 5 DocNo Invoice Date 9 DocDate	Mamee Field Field Position SQL Accounting Field Transaction Number 4 DocNo Transaction Date 6 DocDate Customer Code or Census Number 0 or 18 Code Salesman Code 2 Agent Invoice Number 15 DocNoEx

[top]

Field Mapping - Detail

Product Related - Format 1

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 Net Amount 14 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 Net Amount 22 Amount Promotion Discount 21 Disc Tax Amount 23 TaxAmt Reason Description 26 Description2

Product Related - Format 2

For Sales Invoice	For Sales Credit Note
Mamee Field Field Position SQL Accounting Field Product Code 4 ItemCode Product Index 6 Seq UOM Code 9 UOM Product Quantity 8 Qty UOM List Price 12 UnitPrice Net Amount 14 Amount Promo Discount 18 Disc Tax Amount 15 TaxAmt	Mamee Field Field Position SQL Accounting Field Product Code 4 ItemCode Product Index 6 Seq UOM Code 9 UOM Product Quantity 8 Qty UOM List Price 12 UnitPrice Net Amount 17 Amount Promotion Discount 15 Disc Tax Amount 18 TaxAmt Reason Description 22 Description2

[top]

Field Mapping - Header

Non-Product Related

For Sales Debit Note	For Sales Credit Note
Mamee Field Field Position SQL Accounting Field Transaction Number 0 DocNo Customer Code or Census Number 3 or 16 Code Transaction Date 2 DocDate Salesman Code 9 Agent Header Remark 12 Header Description Remark 7 Item Description Reason Code (Description) 11 Description2 Tax Invoice Number 6 DocNoEx Tax Invoice Date 13 DocRef1 Net Amount 5 UnitPrice Tax Amount 8 TaxAmt	Mamee Field Field Position SQL Accounting Field Salesman Code 1 Agent Customer Code or Census Number 3 or 16 Code Transaction Number 5 DocNo Transaction Date 6 DocDate Header Remark 8 Header Description Remark 11 Item Description Tax Invoice Number 9 DocNoEx Tax Invoice Date 10 DocRef1 Reason Code (Description) 7 Description2 Net Amount 12 UnitPrice Tax Amount 14 TaxAmt

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

Menu : 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)
FormatType	1 : Format 1 2 : Format 2

Menu : Tools | Maintain Agent...

Options	Description
Saleman Code	Mamee Salesman Code
Agent	SQL Accounting Agent Code

01. Click the + button

02. Enter the Mamee Salesman Code

03. Select the SQL Accounting Agent Code

04. Click Tick to Save

Menu : Tools | Maintain Non-Product GL...

Options	Description
Mamee Reason Code	Mamee Reason Code
Reason Desc.	Mamee Reason Description
GL Acc. Debit Note	SQL Accounting GL Account Code for Debit Note
GL Acc. Credit Note	SQL Accounting GL Account Code for Credit Note

01. Select the record

02. Click Edit (the up arrow)

03. Select the GL Code for Debit Note

04. Select the GL Code for Credit Note

05. Click Tick to Save

Steps

Product Related

Below steps is example to import Sales Invoice

01. Click Product | 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

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

Non-Product Related

Below steps is example to import Sales Credit Note

01. Click Non-Product | Credit Note...

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

03. Select the Mamee Non Product Credit Note Text/CSV File

04. Click Open

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

06. Click Post To A/c button if confirm all is ok to post to SQL Accounting

FAQ

May refer to FAQ

See also

• Others Customisation