SQL Acc Mamee Import: Difference between revisions

From eStream Software
Line 20: Line 20:


==Field Mapping - Header==
==Field Mapping - Header==
{| class="wikitable"
* For Sales Invoice
|-
::{| class="wikitable"
! For Sales Invoice !! Header text
|-
| {| class="wikitable"
|-
|-
! Mamee Field !! SQL Accounting Field
! Mamee Field !! SQL Accounting Field
Line 37: Line 34:
|}
|}


 
* For Sales Credit Note
||
::{| class="wikitable"
{| class="wikitable"
|-
|-
! Mamee Field !! SQL Accounting Field
! Mamee Field !! SQL Accounting Field
Line 53: Line 49:
| InvoiceNumber || Example
| InvoiceNumber || Example
|}
|}
|}
* For Sales Invoice
::{| class="wikitable"
|-
! Mamee Field !! SQL Accounting Field
|-
| Salesman Code || Agent
|-
| Customer Code || Code
|-
| Invoice Number || DocNo
|-
| Invoice Date || DocDate
|}
* For Sales Credit Note


==Field Mapping - Detail==
==Field Mapping - Detail==

Revision as of 11:03, 3 December 2015

Introduction

Is External 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)

F & N Specification

Import Program

History New/Updates/Changes

--Build 0--

Field Mapping - Header

  • For Sales Invoice
Mamee Field SQL Accounting Field
Salesman Code Agent
Customer Code Code
Invoice Number DocNo
Invoice Date DocDate
  • For Sales Credit Note
Mamee Field SQL Accounting Field
TransactionNumber DocNo
TransactionDate DocDate
CustomerCode Code
SalesmanCode Agent
InvoiceNumber Example

Field Mapping - Detail

Mamee Field SQL Accounting Field
Product Code ItemCode
Product Index Seq
UOM Code UOM
Product Quantity Qty
UOM List Price UnitPrice
Gross Amount Amount
Promo Discount Disc
Tax Amount TaxAmt

Steps

Below steps is example to import Sales Invoice
1. Click Invoice...

  • More Coming Soon...

FAQ

May refer to FAQ

See also