| Line 72: | Line 72: | ||
|} | |} | ||
===Customer Credit Note - Export=== | |||
{| class="wikitable" style="margin: 1em auto 1em auto;" | |||
|- | |||
! Dryper Field - SO !! Dryper Field - IV !! SQL Accounting Field | |||
|- | |||
| SalesOrderCode || SalesInvoiceCode || DocNo | |||
|} | |||
<div style="float: right;"> [[#top|[top]]]</div> | <div style="float: right;"> [[#top|[top]]]</div> | ||
Revision as of 01:55, 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 |
Customer Credit Note - Export
| Dryper Field - SO | Dryper Field - IV | SQL Accounting Field |
|---|---|---|
| SalesOrderCode | SalesInvoiceCode | DocNo |
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