View source for SQL Acc Cash Register Import

==Introduction==
Is External Shareware Program which to import Cash Register Electronic Journal (EJ) file to 
* Sales Cash Sales
* Customer Payment

==Supported Model==
Sharp<br />
'''Format 1'''
* XE-A147
* XE-A137

'''Format 2'''
* XE-A207
* XE-A217
* XE-A307
* ER-A411/ER-A421

==Import Program==
* Version (1.0.0.0) - Comming Soon...
* http://www.estream.com.my/downloadfile/Fairy/-setup.exe

===History New/Updates/Changes===
--Build 0--

==Setting==
'''Cash Register Machine'''<br />
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

{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
! 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
|}

{| style="margin: 1em auto 1em auto;"
|-
| 
----------------------------------------------------------------------------------------------------------------------------------------------------
{|
|-
| [[File:Template.Warning-01.jpg|80px]]|| 
* 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'''<br />
May refer to Point 1 at [[SQL_Accounting_Linking#Things_To_Consider_Before_Import.2FPost|Things To Consider Before Import/Post]]

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

{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
! 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
|}

{| style="margin: 1em auto 1em auto;"
|-
| 
----------------------------------------------------------------------------------------------------------------------------------------------------
{|
|-
| [[File:Template.Tips-01.jpg|60px]]||  Notes
* User may ignore the option with * as this can be set on Posting Screen  
* For '''Service Charge''' & '''Rounding''' system will use ''SalesCodeSR'' 
|}
----------------------------------------------------------------------------------------------------------------------------------------------------
|}

==Steps==

[[File:SQLAccCashReg-02.jpg|center]]
* Coming Soon...

==FAQ==
May refer to [[SQL_Accounting_Linking#FAQ|FAQ]]

==See also==
* Others [[Customisation]]