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

• 15 Jan 2019
• https://www.estream.com.my/downloadfile/Fairy/Dryper_Spec-20190115.zip

[top]

Import Program

• Version (1.1.0.2) - 09 Apr 2019
• Evaluation Limit : 100 Records per file
• SQLAccDryperImp-setup
• MD5 : 3BB5F5E539A73C45550177D1C0F455F6

History New/Updates/Changes

--Build 2--

• Add Option SL-UseDryperItemDesc & PH-UseDryperItemDesc.
• Add Option SL-UseDocNoEx & PH-UseDocNoEx.
• Fixed Setting will loss on Uninstall.

--Build 1--

• Upgrade to Version 1.1.
• Add Option for use CustomerCode or ExternalReferenceNo2 for SQL Accounting Customer Code.
• Add Check Box at DocNo & remove Check Box in Data Grid
• Add Import PO & PI.
• Add Checking for BizNature & CompanyName2 field for Customer/Supplier Code
• Remove Import DocNoEx for ExternalReferenceNo2
• Add Checking for Description2 & Note field for Item Code.
• Fixed unable to register.

--Build 0--

[top]

Field Mapping

Sales Order or Sales Invoice

Dryper Field - SO	Dryper Field - IV	SQL Accounting Field
SalesOrderCode	SalesInvoiceCode	DocNo
Either 1 below CustomerCode ExternalReferenceNo2	Either 1 below CustomerCode ExternalReferenceNo2	Either 1 below Code RegisterNo GSTNo Remark CompanyName2
OrderDate	InvoiceDate	DocDate
ItemCode	ItemCode	Either 1 below Code Remark1 Remark2 Shelf Barcode
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

Purchase Order or Purchase Invoice

Dryper Field - PO	Dryper Field - PI	SQL Accounting Field
PurchaseOrderNo	InvoiceNo	DocNo
Either 1 below CreditorCode SupplierCode	Either 1 below CreditorCode SupplierCode	Either 1 below Code RegisterNo GSTNo Remark CompanyName2
ItemCode	ItemCode	Either 1 below Code Remark1 Remark2 Shelf Barcode
ItemName	ItemName	Item Description
POQuantity	Quantity	Qty
UOM	UOM	UOM
UnitCost	UnitPrice	UnitPrice
NetAmount	NetAmount	Amount
OrderDate	GRNDate	DocDate

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

In Dryper Program

This can be see under Tools | Options

Options	Description
UseCustomerCode	0 : Import will use Dryper ExternalReferenceNo2 Field as Customer Code 1 : Import will use Dryper CustomerCode Field as Customer Code
UseSupplierCode	0 : Import will use Dryper CreditorCode Field as Supplier Code 1 : Import will use Dryper SupplierCode Field as Supplier Code
SL-UseDryperItemDesc	0 : Import will use SQL Accounting Item Description For Sales Import 1 : Import will use Dryper Item Description For Sales Import
PH-UseDryperItemDesc	0 : Import will use SQL Accounting Item Description For Purchase Import 1 : Import will use Dryper Item Description For Purchase Import
SL-UseDocNoEx	0 : Import will Map Dryper DocNo to SQL Accounting DocNo For Sales Import 1 : Import will Map Dryper DocNo to SQL Accounting DocNoEx For Sales Import
PH-UseDocNoEx	0 : Import will Map Dryper DocNo to SQL Accounting DocNo For Purchase Import 1 : Import will Map Dryper DocNo to SQL Accounting DocNoEx For Purchase Import

[top]

Sales Order or Sales Invoice

Below is example for import Sales Invoice...
Menu: Sales | Invoice...

01. Click 1. Get File button

02. Select the File file wanted to import

03. Click Open

04. Select the Excel Sheet (if more then 1)

05. Set No of record to Load (only available for Registered user)

06. Click 2. Get Data button

07. Click 3. Verify button

08. Click 4. Post To A/c button

[top]

Customer Credit Note - Export

Menu: Customer | Customer Credit Note - Export...

01. Enter the Distributor Code (Provided by Dryper)

02. Enter the Branch Code (Provided by Dryper)

03. Select Range Date To export

04. Click Get Data... to get the Data from SQL Accounting

05. Click Export to xlsx to export out

[top]

FAQ

How it look like if Dryper had 3 level of discount?

Once Import it will look like below

May refer to FAQ

See also

• Others Customisation