SQL Acc Cash Register Import

From eStream Software

Introduction

Is External Shareware Program which to import Cash Register Electronic Journal (EJ) file to

  • Sales Cash Sales
  • Customer Payment

Supported Model

Sharp
Format 1

  • XE-A147
  • XE-A137

Format 2

  • XE-A207
  • XE-A217
  • XE-A307
  • ER-A411/ER-A421

Import Program

History New/Updates/Changes

--Build 0--

Setting

Cash Register Machine
Below is the setting to be set in your Cash Register Machine

  • Updated 19 Mar 2016
  • All setting can be done at PGM mode → Setting → function text
  • For Currency can be done at PGM mode → Setting → Optional → Basic system
Description Function Text
Currency Symbol CURRENCY TEXT RM
GST Standard Rate Symbol TXBL1 SYMBOL S
GST Zero Rate Symbol TXBL2 SYMBOL Z
Taxable subtotal (SubTotalWithTax) TAX1 ST GST TAX AMT
Taxable subtotal (SubTotalWithTax) TAX2 ST ZERO TAX AMT
VAT(GSTAmt) VAT 1 GST 6%
VAT(GSTAmt) VAT 2 GST 0%
Rounding DIFFER ROUNDING
DocAmt Total ***TOTAL
Total Before Service Charge Subtotal SUBTOTAL
Service Charge SER.CHRG SER.CHRG
Total After Service Charge before GST NET 1 NET
Cash Payment CASH CASH

Template.Warning-01.jpg
  • All amount should be in Tax Inclusive as this is GST Rule for Simplified Tax Invoice
  • You are not allow to VOID the Invoice

SQL Accounting
May refer to Point 1 at Things To Consider Before Import/Post

Cash Register Import
Menu: Tools | Options...

SQLAccCashReg-01.jpg
Function Description
DisplayFormatQty Display Format For Quantity Field
DisplayFormatUnitPrice Display Format For Unit Price Field
DisplayFormatAccountValue Display Format For Amount Field
*MachineType Last used Machine Type
*CompanyCode Last used Customer Code
*SalesCodeSR Last used Sales Code for SR
*SalesCodeZR Last used Sales Code for ZR
*PaymentMethodCash Last used Payment Method Code
*PostAsOne Posting Type
DocNoFormat Document Number Format for PostAsOne = 1
NextDocNo Next Document Number for PostAsOne = 1

Template.Tips-01.jpg Notes
  • User may ignore the option with * as this can be set on Posting Screen
  • For Service Charge & Rounding system will use SalesCodeSR

Steps

  • Coming Soon...

FAQ

May refer to FAQ

See also