| Line 21: | Line 21: | ||
==Field Mapping - Header== | ==Field Mapping - Header== | ||
{| class="wikitable" | {| class="wikitable" | ||
| | ! scope="col" style="width: 300px;" | For Sales Invoice | ||
! scope="col" style="width: 330px;" | For Sales Credit Note | |||
|- style="vertical-align: top;" | |- style="vertical-align: top;" | ||
| | | | ||
{| class="wikitable" | :{| class="wikitable" | ||
|- | |- | ||
! Mamee Field !! SQL Accounting Field | ! Mamee Field !! SQL Accounting Field | ||
| Line 38: | Line 38: | ||
|} | |} | ||
|| | || | ||
{| class="wikitable" | :{| class="wikitable" | ||
|- style="vertical-align: top;" | |- style="vertical-align: top;" | ||
! Mamee Field !! SQL Accounting Field | ! Mamee Field !! SQL Accounting Field | ||
Revision as of 01:58, 4 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 | For Sales Credit Note | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
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