Line 56: | Line 56: | ||
==Field Mapping - Detail== | ==Field Mapping - Detail== | ||
{| class="wikitable" | {| class="wikitable" | ||
! scope="col" style="width: | ! scope="col" style="width: 370px;" | For Sales Invoice | ||
! scope="col" style="width: 330px;" | For Sales Credit Note | ! scope="col" style="width: 330px;" | For Sales Credit Note | ||
|- style="vertical-align: top;" | |- style="vertical-align: top;" | ||
Line 62: | Line 62: | ||
:{| class="wikitable" | :{| class="wikitable" | ||
|- | |- | ||
! Mamee Field !! SQL Accounting Field | ! Mamee Field !! Field Seq !! SQL Accounting Field | ||
|- | |- | ||
| Product Code || ItemCode | | Product Code || 2 || ItemCode | ||
|- | |- | ||
| Product Index || Seq | | Product Index || 3 || Seq | ||
|- | |- | ||
| UOM Code || UOM | | UOM Code || 5 || UOM | ||
|- | |- | ||
| Product Quantity || Qty | | Product Quantity || 6 || Qty | ||
|- | |- | ||
| UOM List Price || UnitPrice | | UOM List Price || 9 || UnitPrice | ||
|- | |- | ||
| Gross Amount || Amount | | Gross Amount || 10 || Amount | ||
|- | |- | ||
| Promo Discount || Disc | | Promo Discount || 12 || Disc | ||
|- | |- | ||
| Tax Amount || TaxAmt | | Tax Amount || 13 || TaxAmt | ||
|} | |} | ||
|| | || |
Revision as of 03:31, 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
For Sales Invoice | For Sales Credit Note | |||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
Steps
Below steps is example to import Sales Invoice
1. Click Invoice...
- More Coming Soon...
FAQ
May refer to FAQ
See also
- Others Customisation