| Line 20: | Line 20: | ||
==Field Mapping - Header== | ==Field Mapping - Header== | ||
* For Sales Invoice | |||
::{| 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 | ||
|} | |} | ||
==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
- Version (1.0.0.0) - Coming Soon...
- http://www.estream.com.my/downloadfile/Fairy/SQLAccMameeImp-setup.exe
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
- Others Customisation