| Line 1: | Line 1: | ||
==Introduction== | ==Introduction== | ||
Is External Shareware Program which to import Dryper excel file to | Is External Shareware Program which to import & Export Dryper excel file to | ||
:'''Import''' | |||
* Sales Order or Sales Invoice | * Sales Order or Sales Invoice | ||
* Purchase Order or Purchase Invoice | |||
:'''Export''' | |||
* Sales Credit Note | * Sales Credit Note | ||
==Dryper Specification== | ==Dryper Specification== | ||
Revision as of 04:41, 26 December 2018
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
- http://www.estream.com.my/downloadfile/Fairy/-setup.exe
- MD5 :
History New/Updates/Changes
--Build 0--
Field Mapping
Sales Order or Sales Invoice
| Dryper Field | SQL Accounting Field |
|---|---|
| SalesInvoiceCode | 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