SQL Acc Mamee Import: Difference between revisions

Revision as of 04:43, 13 April 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--

Todo

Census Number = SQL Accounting Customer Code
Allow Save Mamee Salesman Code to match SQL Acc Agent code
Enable Import Non Related Product file

Field Mapping - Header

For Sales Invoice

For Sales Credit Note

Mamee Field	Field Position	SQL Accounting Field
Salesman Code	1	Agent
Customer Code or Census Number	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

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

Coming Soon....

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