SQL Acc Dryper Import

From eStream Software

Introduction

Is External Shareware Program which to import Dryper excel file to

  • Sales Order or Sales Invoice
  • Sales Credit Note
  • Purchase Order or Purchase Invoice

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