| Line 26: | Line 26: | ||
==Field Mapping== | ==Field Mapping== | ||
=== | ===Sales Invoice=== | ||
{| class="wikitable" style="margin: 1em auto 1em auto;" | {| class="wikitable" style="margin: 1em auto 1em auto;" | ||
|- | |- | ||
! Dryper Field !! SQL Accounting Field | ! Dryper Field !! SQL Accounting Field | ||
|- | |- | ||
| | | SalesInvoiceNo || DocNo | ||
|- | |- | ||
| CustomerCode || Either 1 below | | CustomerCode || Either 1 below | ||
Revision as of 01:42, 22 January 2019
Introduction
Is External Shareware Program which to import & Export Dryper excel file to
- Import
- Sales Order or Sales Invoice
- Purchase Order or Purchase Invoice
- Export
- Sales Credit Note
Dryper Specification
- 19 Nov 2018
- https://www.estream.com.my/downloadfile/Fairy/
Import Program
- Version (1.0.0.0) - Coming Soon...
- Evaluation Limit : 100 Records per file
- https://www.estream.com.my/downloadfile/Fairy/-setup.exe
- MD5 :
History New/Updates/Changes
--Build 0--
Field Mapping
Sales Invoice
| Dryper Field | SQL Accounting Field |
|---|---|
| SalesInvoiceNo | DocNo |
| CustomerCode | Either 1 below
|
| InvoiceDate | DocDate |
| ExternalReferenceNo2 | DocNoEx |
| ItemCode | Either 1 below
|
| ItemName | Item Description |
| Quantity | Qty |
| UOM | UOM |
| UnitPrice | UnitPrice |
DiscountRate
|
Disc |
| TotalTaxAmount | TaxAmt |
| NetAmount | Amount |
| RoundingAmount | Will Append as New itemcode RTN5Cents |
Setting
In SQL Accounting
01. May refer to Point 2 at Things To Consider Before Import/Post
FAQ
May refer to FAQ
See also
- Others Customisation