SQL Acc Mamee Import: Difference between revisions

From eStream Software
Line 61: Line 61:


==Field Mapping - Detail==
==Field Mapping - Detail==
===Product Related===
{| class="wikitable"  style="margin: 1em auto 1em auto;"
{| class="wikitable"  style="margin: 1em auto 1em auto;"
! scope="col" style="width: 400px;" | For Sales Invoice
! scope="col" style="width: 400px;" | For Sales Invoice

Revision as of 04:45, 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

Import Program

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

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

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