SQL Acc Dryper Import: Difference between revisions

From eStream Software
 
(50 intermediate revisions by the same user not shown)
Line 9: Line 9:


==Dryper Specification==
==Dryper Specification==
* 19 Nov 2018
* 15 Jan 2019
* https://www.estream.com.my/downloadfile/Fairy/
* https://download.sql.com.my/customer/Fairy/Dryper_Spec-20190115.zip


<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>


==Import Program==
==Import Program==
* Version (1.0.0.0) - Coming Soon...
* Version (1.1.0.3) - 29 Jan 2021
* Evaluation Limit : 100 Records per file
* Evaluation Limit : 100 Records per file
* https://www.estream.com.my/downloadfile/Fairy/-setup.exe
* [https://download.sql.com.my/customer/Fairy/SQLAccDryperImp-setup.exe SQLAccDryperImp-setup]
* MD5 :  
* MD5 : 5D18B0207C9C12168D0394855EA378ED
 


===History New/Updates/Changes===
===History New/Updates/Changes===
--Build 3--
* Enable Support Version 782 & above (New ROC).
* Fixed DocNo Not able to select.
* Fixed Unable to Batch Highlight DocNo.
* Fixed Import Prompt Date Error.
* Add Shortcut Get User Guide.
--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--
--Build 0--


Line 29: Line 52:
{| 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
| Either 1 below
* CustomerCode
* ExternalReferenceNo2
|| Either 1 below
* CustomerCode
* ExternalReferenceNo2
|| Either 1 below
* Code
* Code
* RegisterNo
* RegisterNo
* GSTNo
* GSTNo
* Remark
* Remark
* CompanyName2
|-
|-
| InvoiceDate || DocDate
| OrderDate || InvoiceDate || DocDate
|-
| ExternalReferenceNo2 || DocNoEx
|-
|-
| ItemCode || Either 1 below
| ItemCode || ItemCode || Either 1 below
* Code
* Code
* Remark1
* Remark1
Line 49: Line 77:
* Shelf
* Shelf
* Barcode
* Barcode
* 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'''
|}
|}


===Purchase Order or Purchase Invoice===
{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
! 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===
{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
! 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
|}
<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>


==Setting==
==Setting==
===In SQL Accounting===
===In SQL Accounting===
01. May refer to Point 2 at [[SQL_Accounting_Linking#Things_To_Consider_Before_Import.2FPost|Things To Consider Before Import/Post]]<br />
:01. May refer to Point 2 at [[SQL_Accounting_Linking#Things_To_Consider_Before_Import.2FPost|Things To Consider Before Import/Post]]<br />
 
===In Dryper Program===
This can be see under '''Tools | Options'''
{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
! Options !! Description
|-
| UseCustomerCode ||
* 0 : Import will use Dryper <span style="color:#0000ff">ExternalReferenceNo2</span> Field as Customer Code
* 1 : Import will use Dryper <span style="color:#0000ff">CustomerCode</span> Field as Customer Code
|-
| UseSupplierCode ||
* 0 : Import will use Dryper <span style="color:#0000ff">CreditorCode</span> Field as Supplier Code
* 1 : Import will use Dryper <span style="color:#0000ff">SupplierCode</span> Field as Supplier Code
|-
| SL-UseDryperItemDesc ||
* 0 : Import will use SQL Accounting <span style="color:#0000ff">Item Description</span> For Sales Import
* 1 : Import will use Dryper <span style="color:#0000ff">Item Description</span> For Sales Import
|-
| PH-UseDryperItemDesc ||
* 0 : Import will use SQL Accounting <span style="color:#0000ff">Item Description</span> For Purchase Import
* 1 : Import will use Dryper <span style="color:#0000ff">Item Description</span> For Purchase Import
|-
| SL-UseDocNoEx ||
* 0 : Import will Map Dryper DocNo to SQL Accounting <span style="color:#0000ff">DocNo</span> For Sales Import
* 1 : Import will Map Dryper DocNo to SQL Accounting <span style="color:#0000ff">DocNoEx</span> For Sales Import
|-
| PH-UseDocNoEx ||
* 0 : Import will Map Dryper DocNo to SQL Accounting <span style="color:#0000ff">DocNo</span> For Purchase Import
* 1 : Import will Map Dryper DocNo to SQL Accounting <span style="color:#0000ff">DocNoEx</span> For Purchase Import
|}
<div style="float: right;">  [[#top|[top]]]</div>
 
==Sales Order or Sales Invoice==
Below is example for import Sales Invoice...<br />
''Menu: Sales | Invoice...''<br />
:01. Click '''1. Get File''' button
[[File:DryperImp-01.jpg|800px|center]]
:02. Select the File file wanted to import
:03. Click '''Open'''
[[File:DryperImp-02.jpg|800px|center]]
: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
 
<div style="float: right;">  [[#top|[top]]]</div>


==Customer Credit Note - Export==
''Menu: Customer | Customer Credit Note - Export...''
[[File:DryperImp-03.jpg|800px|center]]
: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


<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>
==FAQ==
==FAQ==
===How it look like if Dryper had 3 level of discount?===
: Once Import it will look like below
[[File:DryperImp-04.jpg|800px|center]]
May refer to [[SQL_Accounting_Linking#FAQ|FAQ]]
May refer to [[SQL_Accounting_Linking#FAQ|FAQ]]


==See also==
==See also==
* Others [[Customisation]]
* Others [[Customisation]]

Latest revision as of 06:46, 29 March 2022

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

Import Program

  • Version (1.1.0.3) - 29 Jan 2021
  • Evaluation Limit : 100 Records per file
  • SQLAccDryperImp-setup
  • MD5 : 5D18B0207C9C12168D0394855EA378ED


History New/Updates/Changes

--Build 3--

  • Enable Support Version 782 & above (New ROC).
  • Fixed DocNo Not able to select.
  • Fixed Unable to Batch Highlight DocNo.
  • Fixed Import Prompt Date Error.
  • Add Shortcut Get User Guide.

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

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

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

Sales Order or Sales Invoice

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

01. Click 1. Get File button
DryperImp-01.jpg
02. Select the File file wanted to import
03. Click Open
DryperImp-02.jpg
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

Customer Credit Note - Export

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

DryperImp-03.jpg
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

FAQ

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

Once Import it will look like below
DryperImp-04.jpg


May refer to FAQ

See also

Retrieved from "https://wiki.sql.com.my/index.php?title=SQL_Acc_Dryper_Import&oldid=11753"
Last modified
This page was last edited on 29 March 2022, at 06:46.