| Line 20: | Line 20: | ||
==Field Mapping - Header== | ==Field Mapping - Header== | ||
{| class="wikitable" | |||
|- | |||
! For Sales Invoice !! Header text | |||
|- | |||
| {| class="wikitable" | |||
|- | |||
! Mamee Field !! SQL Accounting Field | |||
|- | |||
| Salesman Code || Agent | |||
|- | |||
| Customer Code || Code | |||
|- | |||
| Invoice Number || DocNo | |||
|- | |||
| Invoice Date || DocDate | |||
|} | |||
|| | |||
{| class="wikitable" | |||
|- | |||
! Mamee Field !! SQL Accounting Field | |||
|- | |||
| TransactionNumber || DocNo | |||
|- | |||
| TransactionDate || DocDate | |||
|- | |||
| CustomerCode || Code | |||
|- | |||
| SalesmanCode || Agent | |||
|- | |||
| InvoiceNumber || Example | |||
|} | |||
|} | |||
* For Sales Invoice | * For Sales Invoice | ||
::{| class="wikitable" | ::{| class="wikitable" | ||
Revision as of 11:02, 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 | Header text |
|---|---|
| class="wikitable" | |
| Mamee Field | SQL Accounting Field |
| Salesman Code | Agent |
| Customer Code | Code |
| Invoice Number | DocNo |
| Invoice Date | DocDate |
||
| Mamee Field | SQL Accounting Field |
|---|---|
| TransactionNumber | DocNo |
| TransactionDate | DocDate |
| CustomerCode | Code |
| SalesmanCode | Agent |
| InvoiceNumber | Example |
|}
- For Sales Invoice
Mamee Field SQL Accounting Field Salesman Code Agent Customer Code Code Invoice Number DocNo Invoice Date DocDate
- 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