SQL Acc Mamee Import: Difference between revisions

From eStream Software
Line 57: Line 57:
{| class="wikitable"
{| class="wikitable"
! scope="col" style="width: 370px;" | For Sales Invoice
! scope="col" style="width: 370px;" | For Sales Invoice
! scope="col" style="width: 330px;" | For Sales Credit Note
! scope="col" style="width: 400px;" | For Sales Credit Note
|- style="vertical-align: top;"
|- style="vertical-align: top;"
|  
|  
Line 83: Line 83:
:{| class="wikitable"
:{| class="wikitable"
|-
|-
! Mamee Field !! SQL Accounting Field
! Mamee Field !! Field Seq !! SQL Accounting Field
|-
|-
| Product Code || ItemCode
| Product Code || 8 || ItemCode
|-
|-
| Product Index || Seq
| Product Index || 6 || Seq
|-
|-
| UOM Code || UOM
| UOM Code || 14 || UOM
|-
|-
| Product Quantity || Qty
| Product Quantity || 16 || Qty
|-
|-
| UOM List Price || UnitPrice
| UOM List Price || 18 || UnitPrice
|-
|-
| Gross Amount || Amount
| Gross Amount || 19 || Amount
|-
|-
| Promotion Discount || Disc
| Promotion Discount || 21 || Disc
|-
|-
| Tax Amount || TaxAmt
| Tax Amount || 23 || TaxAmt
|-  
|-  
| Reason Description || Description2
| Reason Description || 26 || Description2
|}
|}
|}
|}

Revision as of 03:36, 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

History New/Updates/Changes

--Build 0--

Field Mapping - Header

For Sales Invoice For Sales Credit Note
Mamee Field Field Seq SQL Accounting Field
Salesman Code 1 Agent
Customer Code 2 Code
Invoice Number 4 DocNo
Invoice Date 6 DocDate
Mamee Field Field Seq SQL Accounting Field
Transaction Number 0 DocNo
Transaction Date 1 DocDate
Customer Code 2 Code
Salesman Code 7 Agent
Invoice Number 15 DocNoEx

Field Mapping - Detail

For Sales Invoice For Sales Credit Note
Mamee Field Field Seq SQL Accounting Field
Product Code 2 ItemCode
Product Index 3 Seq
UOM Code 5 UOM
Product Quantity 6 Qty
UOM List Price 9 UnitPrice
Gross Amount 10 Amount
Promo Discount 12 Disc
Tax Amount 13 TaxAmt
Mamee Field Field Seq SQL Accounting Field
Product Code 8 ItemCode
Product Index 6 Seq
UOM Code 14 UOM
Product Quantity 16 Qty
UOM List Price 18 UnitPrice
Gross Amount 19 Amount
Promotion Discount 21 Disc
Tax Amount 23 TaxAmt
Reason Description 26 Description2

Steps

Below steps is example to import Sales Invoice
1. Click Invoice...

  • More Coming Soon...

FAQ

May refer to FAQ

See also

Retrieved from "https://wiki.sql.com.my/index.php?title=SQL_Acc_Mamee_Import&oldid=2474"
Last modified
This page was last edited on 4 December 2015, at 03:36.