| Line 42: | Line 42: | ||
! Mamee Field !! SQL Accounting Field | ! Mamee Field !! SQL Accounting Field | ||
|- | |- | ||
| | | Transaction Number || DocNo | ||
|- | |- | ||
| | | Transaction Date || DocDate | ||
|- | |- | ||
| | | Customer Code || Code | ||
|- | |- | ||
| | | Salesman Code || Agent | ||
|- | |- | ||
| | | Invoice Number || Example | ||
|} | |} | ||
|} | |} | ||
Revision as of 02:18, 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