SQL Acc Cash Register Import: Difference between revisions

From eStream Software
Line 79: Line 79:
'''Cash Register Import'''<br />
'''Cash Register Import'''<br />
''Menu: Tools | Options...'' <br />
''Menu: Tools | Options...'' <br />
[[File:SQLAccCashReg-01.jpg]]
[[File:SQLAccCashReg-01.jpg|center]]


{| class="wikitable" style="margin: 1em auto 1em auto;"
{| class="wikitable" style="margin: 1em auto 1em auto;"

Revision as of 06:27, 22 April 2016

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

Steps

  • Coming Soon...

FAQ

May refer to FAQ

See also