SQL Acc Dryper Import: Difference between revisions

From eStream Software
Line 17: Line 17:
* Version (1.0.0.0) - Coming Soon...
* Version (1.0.0.0) - Coming Soon...
* Evaluation Limit : 100 Records per file
* Evaluation Limit : 100 Records per file
* http://www.estream.com.my/downloadfile/Fairy/-setup.exe
* https://www.estream.com.my/downloadfile/Fairy/-setup.exe
* MD5 :  
* MD5 :  



Revision as of 12:08, 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

Import Program

History New/Updates/Changes

--Build 0--

Field Mapping

Sales Order or Sales Invoice

Dryper Field SQL Accounting Field
SalesInvoiceCode DocNo
CustomerCode Either 1 below
  • Code
  • RegisterNo
  • GSTNo
  • Remark
InvoiceDate DocDate
ExternalReferenceNo2 DocNoEx
ItemCode Either 1 below
  • Code
  • Remark1
  • Remark2
  • Shelf
  • Barcode
  • Customer Item Code
ItemName Item Description
Quantity Qty
UOM UOM
UnitPrice UnitPrice
DiscountRate
  • where LineType = 1
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