SQL Acc Mamee Import: Difference between revisions

From eStream Software
Line 129: Line 129:
*Coming Soon...
*Coming Soon...
{| class="wikitable"  style="margin: 1em auto 1em auto;"
{| class="wikitable"  style="margin: 1em auto 1em auto;"
! scope="col" style="width: 500px;" | For Sales Debit Note
! scope="col" style="width: 420px;" | For Sales Debit Note
! scope="col" style="width: 420px;" | For Sales Credit Note
! scope="col" style="width: 420px;" | For Sales Credit Note
|- style="vertical-align: top;"
|- style="vertical-align: top;"
Line 139: Line 139:
| Transaction Number ||style="text-align: center;" | 0 || DocNo
| Transaction Number ||style="text-align: center;" | 0 || DocNo
|-
|-
| Customer Code or Census Number || style="text-align: center;" | 3 or 16 || Code
| Customer Code or <br /> Census Number || style="text-align: center;" | 3 or 16 || Code
|-
|-
| Transaction Date || style="text-align: center;" | 2  || DocDate
| Transaction Date || style="text-align: center;" | 2  || DocDate
Line 147: Line 147:
| Remark || style="text-align: center;" | 7 || Description
| Remark || style="text-align: center;" | 7 || Description
|-
|-
| Reason Code (Description) || style="text-align: center;" | 11 || Description2
| Reason Code <br />(Description) || style="text-align: center;" | 11 || Description2
|-
|-
| Tax Invoice Number || style="text-align: center;" | 6 || DocNoEx
| Tax Invoice Number || style="text-align: center;" | 6 || DocNoEx

Revision as of 06:35, 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
Remark 7 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
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

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

Retrieved from "https://wiki.sql.com.my/index.php?title=SQL_Acc_Mamee_Import&oldid=5286"
Last modified
This page was last edited on 31 May 2016, at 06:35.