SQL Acc Mamee Import: Difference between revisions

From eStream Software
Line 96: Line 96:
! Mamee Field !! Field Position !! SQL Accounting Field
! Mamee Field !! Field Position !! SQL Accounting Field
|-
|-
| Salesman Code || style="text-align: center;" | 1 || Agent
| Salesman Code || style="text-align: center;" | 3 || Agent
|-
|-
| Customer Code or <br />Census Number || style="text-align: center;" | 2 or <br />18 || Code
| Customer Code or <br />Census Number || style="text-align: center;" | 1 or <br />31 || Code
|-
|-
| Invoice Number || style="text-align: center;" | 4 || DocNo
| Invoice Number || style="text-align: center;" | 5 || DocNo
|-
|-
| Invoice Date || style="text-align: center;" | 6 || DocDate
| Invoice Date || style="text-align: center;" | 9 || DocDate
|}
|}
  ||  
  ||  
Line 109: Line 109:
! Mamee Field !! Field Position !! SQL Accounting Field
! Mamee Field !! Field Position !! SQL Accounting Field
|-
|-
| Transaction Number || style="text-align: center;" | 0 || DocNo
| Transaction Number || style="text-align: center;" | 5 || DocNo
|-
|-
| Transaction Date || style="text-align: center;" | 1 || DocDate
| Transaction Date || style="text-align: center;" | 6 || DocDate
|-
|-
| Customer Code or <br />Census Number || style="text-align: center;" | 2 or <br />18|| Code
| Customer Code or <br />Census Number || style="text-align: center;" | 0 or <br />18|| Code
|-
|-
| Salesman Code || style="text-align: center;" | 7 || Agent
| Salesman Code || style="text-align: center;" | 2 || Agent
|-
|-
| Invoice Number || style="text-align: center;" | 15 || DocNoEx
| Invoice Number || style="text-align: center;" | 15 || DocNoEx

Revision as of 03:40, 6 December 2017

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

Format 2

Import Program

History New/Updates/Changes

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

Todo

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 5 DocNo
Transaction Date 6 DocDate
Customer Code or
Census Number
0 or
18
Code
Salesman Code 2 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
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

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)

Menu : Tools | Maintain Agent...

Mamee-04.jpg
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...

Mamee-05.jpg
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...
Mamee-01.jpg
02. Click Get File button & system will prompt 2 dialog like below
Mamee-02.jpg
03. Select the Mamee Invoice Text/CSV Header File
04. Click Open
Mamee-03.jpg
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
----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Tips-01.jpg
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...
Mamee-06.jpg
02. Click Get File button & system will prompt dialog like below
Mamee-07.jpg
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