SQL Acc Dryper Import: Difference between revisions

From eStream Software
(Created page with "==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 =...")
 
Line 24: Line 24:
==Field Mapping==
==Field Mapping==
===Sales Order or Sales Invoice===
===Sales Order or Sales Invoice===
 
{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
! 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'''
|}


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

Revision as of 03:03, 26 December 2018

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

Retrieved from "https://wiki.sql.com.my/index.php?title=SQL_Acc_Dryper_Import&oldid=9208"
Last modified
This page was last edited on 26 December 2018, at 03:03.