SQL Acc Dryper Import

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/

[top]

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--

[top]

Field Mapping

Sales Order or Sales Invoice

Dryper Field - SO	Dryper Field - IV	SQL Accounting Field
SalesOrderCode	SalesInvoiceCode	DocNo
CustomerCode	CustomerCode	Either 1 below Code RegisterNo GSTNo Remark
OrderDate	InvoiceDate	DocDate
ExternalReferenceNo2	ExternalReferenceNo2	DocNoEx
ItemCode	ItemCode	Either 1 below Code Remark1 Remark2 Shelf Barcode Customer Item Code
ItemName	ItemName	Item Description
Quantity	Quantity	Qty
UOM	UOM	UOM
UnitPrice	UnitPrice	UnitPrice
DiscountRate where LineType = 1	DiscountRate where LineType = 1	Disc
TotalTaxAmount	TotalTaxAmount	TaxAmt
NetAmount	NetAmount	Amount
RoundingAmount	RoundingAmount	Will Append as New itemcode RTN5Cents

Customer Credit Note - Export

Dryper Field	SQL Accounting Field
CompanyCode	Hard Coded as 1
DistributorCode	Field To Enter in Export Program
BranchCode	Field To Enter in Export Program
CustomerCode	Customer Code
DocumentNo	DocNo
DocumentDate	DocDate
TotalAmount	DocAmt
PaidAmount	DocAmt
Status	Hard Coded as 1
CreatedBy	Hard Coded as SYSTEM
CreatedTimestamp	DocDate

[top]

Setting

In SQL Accounting

01. May refer to Point 2 at Things To Consider Before Import/Post

[top]

Sales Order or Sales Invoice

Below is example for import Sales Invoice...

01. Click 1. Get File button

02. Select the Microsoft Excel File

File:Dryper-04.jpg

03. Select the File file wanted to import

04. Click Open

[top]

FAQ

May refer to FAQ

See also

• Others Customisation