SQL Acc Dryper Import: Difference between revisions

From eStream Software
No edit summary
Line 108: Line 108:


==Sales Order or Sales Invoice==
==Sales Order or Sales Invoice==
Below is example for import Sales Invoice...<br />
:01. Click '''1. Get File''' button<br />
:02. Select the Microsoft Excel File <br />
[[File:Dryper-04.jpg|700px|center]]
:03. Select the File file wanted to import<br />
:04. Click '''Open'''<br />
<div style="float: right;">  [[#top|[top]]]</div>


<div style="float: right;">  [[#top|[top]]]</div>
==FAQ==
==FAQ==
May refer to [[SQL_Accounting_Linking#FAQ|FAQ]]
May refer to [[SQL_Accounting_Linking#FAQ|FAQ]]

Revision as of 04:39, 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 Order or Sales Invoice

Dryper Field - SO Dryper Field - IV SQL Accounting Field
SalesOrderCode SalesInvoiceCode DocNo
CustomerCode CustomerCode Either 1 below
  • Code
  • RegisterNo
  • GSTNo
  • Remark
OrderDate InvoiceDate DocDate
ExternalReferenceNo2 ExternalReferenceNo2 DocNoEx
ItemCode ItemCode Either 1 below
  • Code
  • Remark1
  • Remark2
  • Shelf
  • Barcode
  • Customer Item Code
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

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

Sales Order or Sales Invoice

Below is example for import Sales Invoice...

01. Click 1. Get File button
02. Select the Microsoft Excel File
03. Select the File file wanted to import
04. Click Open

FAQ

May refer to FAQ

See also