SQL Acc Mamee Import: Difference between revisions

From eStream Software
Line 145: Line 145:
| Salesman Code || style="text-align: center;" | 9 || Agent
| Salesman Code || style="text-align: center;" | 9 || Agent
|-
|-
| Remark || style="text-align: center;" | 7 || Description
| Header Remark || style="text-align: center;" | 12 || Header Description
|-
| Remark || style="text-align: center;" | 7 || Item Description
|-
|-
| Reason Code  <br />(Description) || style="text-align: center;" | 11 || Description2
| Reason Code  <br />(Description) || style="text-align: center;" | 11 || Description2

Revision as of 07:15, 31 May 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

Import Program

History New/Updates/Changes

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

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

  • Coming Soon...
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
01. Click the + button
02. Enter the Mamee Salesman Code
03. Select the SQL Accounting Agent Code
04. Click Tick to Save

Steps

Below steps is example to import Sales Invoice

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

FAQ

May refer to FAQ

See also