SQL Acc Dryper Import: Difference between revisions

From eStream Software
Line 31: Line 31:
! Dryper Field !! SQL Accounting Field
! Dryper Field !! SQL Accounting Field
|-
|-
| SalesInvoiceNo || DocNo
| SalesInvoiceCode || DocNo
|-
|-
| CustomerCode || Either 1 below
| CustomerCode || Either 1 below

Revision as of 01:43, 22 January 2019

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