| Line 26: | Line 26: | ||
==Field Mapping== | ==Field Mapping== | ||
===Sales Invoice=== | ===Sales Order or 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 - SO !! Dryper Field - IV !! SQL Accounting Field | ||
|- | |- | ||
| SalesInvoiceCode || DocNo | | SalesOrderCode || SalesInvoiceCode || DocNo | ||
|- | |- | ||
| CustomerCode || Either 1 below | | CustomerCode || CustomerCode || Either 1 below | ||
* Code | * Code | ||
* RegisterNo | * RegisterNo | ||
| Line 39: | Line 39: | ||
* Remark | * Remark | ||
|- | |- | ||
| InvoiceDate || DocDate | | OrderDate || InvoiceDate || DocDate | ||
|- | |- | ||
| ExternalReferenceNo2 || DocNoEx | | ExternalReferenceNo2 || ExternalReferenceNo2 || DocNoEx | ||
|- | |- | ||
| ItemCode || Either 1 below | | ItemCode || ItemCode || Either 1 below | ||
* Code | * Code | ||
* Remark1 | * Remark1 | ||
| Line 51: | Line 51: | ||
* Customer Item Code | * Customer Item Code | ||
|- | |- | ||
| ItemName || Item Description | | ItemName || ItemName || Item Description | ||
|- | |- | ||
| Quantity || Qty | | Quantity || Quantity || Qty | ||
|- | |- | ||
| UOM || UOM | | UOM || UOM || UOM | ||
|- | |- | ||
| UnitPrice || UnitPrice | | UnitPrice || UnitPrice || UnitPrice | ||
|- | |- | ||
| DiscountRate | | DiscountRate | ||
* where LineType = 1 | |||
|| DiscountRate | |||
* where LineType = 1 | * where LineType = 1 | ||
|| Disc | || Disc | ||
|- | |- | ||
| TotalTaxAmount || TaxAmt | | TotalTaxAmount || TotalTaxAmount || TaxAmt | ||
|- | |- | ||
| NetAmount || Amount | | NetAmount || NetAmount || Amount | ||
|- | |- | ||
| RoundingAmount || Will Append as New itemcode '''RTN5Cents''' | | RoundingAmount || RoundingAmount || Will Append as New itemcode '''RTN5Cents''' | ||
|} | |} | ||
Revision as of 01:50, 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 Order or Sales Invoice
| Dryper Field - SO | Dryper Field - IV | SQL Accounting Field |
|---|---|---|
| SalesOrderCode | SalesInvoiceCode | DocNo |
| CustomerCode | CustomerCode | Either 1 below
|
| OrderDate | InvoiceDate | DocDate |
| ExternalReferenceNo2 | ExternalReferenceNo2 | DocNoEx |
| ItemCode | ItemCode | Either 1 below
|
| ItemName | ItemName | Item Description |
| Quantity | Quantity | Qty |
| UOM | UOM | UOM |
| UnitPrice | UnitPrice | UnitPrice |
DiscountRate
|
DiscountRate
|
Disc |
| TotalTaxAmount | TotalTaxAmount | TaxAmt |
| NetAmount | NetAmount | Amount |
| RoundingAmount | 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