Search this site
Embedded Files
Skip to main content
Skip to navigation
HIME
Home
Download Files
SQL Financial Accounting
1. GL
1.01 What is the importants of the special type assigned for GL Account?
1.02 Sample of Manufacturing Chart of Accounts
1.03 Best practise to do Bank Reconciliation...
1.04 How to set the foreign currency for the bank account?
1.05 Contra account should created under Balance Sheet or P&L type?
1.06 How to Enter Stock Loss/Stock Write-off?
1.07 Long Term Liabilities should fall under the Net Assets/Other Liabilities in Balance Sheet? Find the answer here!!!
1.08 Why Trial Balance & Ledger Retained Earning not match even both Report Range Date is same? - RG-00342
1.09 Where to create the "Dividend Paid" account?
1.10 How the GL Ledger Detail Description Show in Report?
1.11 How to make some spacing/gap between 1st & 2nd Line Currency Description at Cheque Printing?
1.12 Understand of Bank Reconciliation Screen
1.13 How the Closing Stock Value in Trial Balance calculate?
1.14 Why there is a Account "PRIOR YEAR ADJUSTMENT" in GL Profit & Loss & Balance Sheet Statement?
2. Customer
2.01 Where I can get to print the reminder letter for overdue customer?
2.02 Could not run program: Variable1OnCalc. Could not convert variant of type (Null) into type (Currency)
2.03 Bad debts written-off, how to post this entry?
2.04 Can I remove the Control Account code for Debtor/Supplier code Format?
2.05 How is the Customer Statement is sort at detail?
2.06 Customer Credit Control Type
2.07 Why there is a gain loss amount even the Invoice & Payment rate is same?
3. Supplier
3.01 Supplier Invoice Listing with SC & PV info
3.02 How is the Supplier Statement is sort at detail?
3.03 Why the IBG bank code (MUFG) not found when process the GIRO payment listing?
4. Sales
4.01 How to cancel the partial qty balance in Sales Order?
4.02 How to insert the signature into the invoice layout for email purpose?
4.03 I cannot input the value into the % column in Profit Estimator
4.04 Transfer Doc Date Follow Filter Date (feature at Outstanding Sales Doc Listing)
4.05 VAT: What is the different between VAT incoming and Outgoing?
4.06 What is the Base Price at Sales/Purchase Price History?
4.07 Why there is Cost in Stock Card for CN even I not enter any cost?
4.08 Why Empty Itemcode Unable to Transfer to Sales Credit Note?
5. Purchase
5.01 How to cancel the partial qty balance in Purchase Order?
5.02 How is the Landing Cost reflect the Unit Cost in Stock Card?
5.03 Transfer Doc Date Follow Filter Date (feature at Outstanding Purchase Doc Listing)
6. Stock
6.01 Where to set the costing method?
6.02 Purpose of Print Stock Serial Number Conflict
6.03 Purpose of Print Stock Serial Number Outstanding
6.04 Preview stock document reports DO NOT show the actual cost!!!
6.05 How the unit cost is calc in stock card?
6.06 Unit of Measurement (UOM) Code List
6.07 Do I need to click on the update cost after save the Stock Adjustment document?
6.08 How the Weighted Average Costing Calculate?
6.09 Why Month End Stock Balance is empty even Stock Card Still show got Qty?
6.10 Why the Stock Aging N & Above($) had amount but N & Above (Q) is 0?
6.11 What is Update Cost button for at Maintain Item under BOM tab?
6.12 How is the Save On Low Qty is work?
7. Settings (SQL Acc)
7.01 How to lock the transaction period?
7.02 Choose an appropriate the terms type for the Terms in Maintain Terms...
7.05 To enable the ALERT to Negative Stock Quantity or below Re-order and Min Qty
7.06 Audit Trail (SQL log activity)
7.07 Auto Form Mode
7.09 Direct E-Mail from SQL Accounting
7.10 Document project is missing in Cash Book Entry, Customer & Supplier Payment!
7.11 Application Installation
7.12 How to recall the Backup reminder msg out again?
7.13 ***Text, XML & SDK Import Information...***
7.14 What is the Costing Posting Sequence if All Document type is Posted in Same Day?
7.15 Typical values for converting convert inches to mm
7.16 Why when I Click print icon system direct/auto print?
7.17 Maintain Document Number Reset by Monthly or Yearly
7.18 Maintain Document Number access rights to Users
7.19 What is the Formula for Customer/Supplier Sales/Purchase & Collection/Payment Report?
7.20 How is the Price Tag work?
7.21 Why GL Profit & Loss Account Not Same with Sales Profit & Loss by doc report?
7.22 ***List of Accounting can be import to SQL Accounting***
7.23 ***What conditions need to follow in order to do the Export & Import XML from Different SQL Accounting Database?***
7.24 Why the Tax code Automatic Clear after I change the Date at Sales/Purchase Data Entry?
7.25 How to set Default Printer by Report?
7.26 Can the System do Hedging Currency?
7.27 [UPGRADE VER] Things need to Consider on Upgrade from Version 3 to Version 4.2016.789.736.
7.28 GST - Why when I enter as 175.10 with 7% tax & save the Tax Amount Change?
7.29 Why I unable to open the jpg file in the attachment?
7.30 Is there any Cross Checking Reports in SQL Accounting?
8. Production
8.01 Simple Production Sales Order Flow
8.02 How to cancel the partial qty to transfer over Job Order/Purchase Order?
8.03 Job Order/Assembly - BOM Rate
8.04 What is the use of "Show Multilevel BOM in Flat Mode"?
8.05 Split to X process(s) in Job Order/Stock Item Assembly
8.06 Batch Update Unit Cost for Stock Item Assembly documents
8.07 Overview of Manufacturing Business WorkFlow
9. Good and Service Tax (GST) - Malaysia
9.01 Types of Supply
9.02 What type of taxable supply apply to the transport and forwarding company?
9.03 Who is eligible to GST?
9.04 Filling Tax Returns (Rules & Conditions)
9.05 GST on Deposit and Full Payment received before the Tax Invoice date
9.06 Bad Debt Relief
9.07 What can I claim as disbursements which are not subject to GST?
9.08 What means "Employee Benefits " to GST?
9.09 Blocked Input Tax
9.10 Do you have to charge GST on your rental income?
9.11 Gift rules
9.12 GST treatment to Employee Benefit
9.13 What is "Deemed Supply"?
9.14 MS-GST on Margin Scheme for 2nd Hand Goods & Services
9.15 What is Mixed Supply?
9.16 MS-Hire Purchase Transaction Using Margin Scheme
9.17 Foreign currency conversion use for tax invoice and records keeping
9.18 Explanation to GST Tax Code
9.19 Why the tax code for IS at Maintain Tax had rate?
9.20 GST Importation Goods Treatment (IM)
9.21 Why the Tax Amt Balancing logic not running even the option is Selected?
9.22 GST-03 Item Detail
9.23 Major Industries Code (MSIC )
9.24 Custom Forms
9.25 GL Account Code Detail for GST
9.26 Relief - Example (Tax code : RS)
9.27 Net Realised Gain in Forex reported in GST-03 item 12
9.28 GST Summary Sheet - MY - Detail
9.29 How to adjust the Input(6b) /Output tax (5b) only in GST-03?
9.30 What is the tax code should use for Fixed Deposit and Interest received ?
9.31 GST Returns - Yellow color meaning
9.32 Total Value of Capital Goods Acquired in GST-03 Item 16
9.33 Total Value of Bad Debt Relief/Recovered Inclusive Tax in GST-03 Item 17 & 18
9.34 Deminus rules infinity should be FAILED where total supply is zero for the month
9.35 Fields allow to change after GST Return process
9.36 Asset input tax allowable to claim after registration
9.37 GST Treatment from Income Tax Department
9.38 AP Bad debt relief calculation for IM tax code
9.39 What steps need to take before submission the GST-03?
9.40 Stock Write Off accounted for Output Tax
10. POS System
10.01 IRS
10.02 Xilnex
10.03 IRC
10.05 Vista
10.06 X-Retail
10.07 Gross Synergy
10.08 Unipos
10.09 One Retail Solution
10.10 Bersian
10.11 CNL
10.12 SIS
10.13 SCR Pos
10.14 Hyper Pos
10.15 CyberPos
10.16 Alpha Pos
10.17 VPos
10.18 Uniwell
10.19 XPos
10.20 ARMS POS
10.21 2U POS
10.22 MySQL ComLink
10.23 Qsolve
10.24 Storehub
10.25 EasyStore
11. Others System
11.01 Globalsion - MRP System
11.02 FirstLink - CRM System
11.03 DataSystem Services - Warehousing & Logistic
11.04 Flexi Team - Hire Purchase System
11.05 VSS - Vehicle Sales System
11.06 Bifrostech - ERP System
11.07 Tactibots - e Commerce
11.08 iHotel Front Desk Management System
11.09 IFCA - HotelPos
11.10 Frontwave - Optical RMS
11.11 Equad - Warehouse Management System (WMS)
11.12 webShaper - e Commerce
11.13 LittleLives - PreSchools System
11.14 PayRecon - e Commerce
11.15 KipleHome - Property Management System
11.16 Ixchel - School & Clinic System
12. Mobile Device System
12.01 Moris - Android
12.02 IQuick Sales - Apple
12.03 Boostorder - Android & Apple
12.04 EasySales - Android & Apple
12.05 3TP Sales Force Automation - Android
11.17 Gobi - BI
SQL Payroll
1. Human Resource
1.01 How to get the Increment Salary letter format to be printed?
1.02 How to get the Confirmation Letter to be printed?
1.03 Can I batch editing the employees data in Maintain Employee?
1.04 Any suggestion of using the Maintain Category?
1.05 Determination of Residence Status
2. Payroll
2.01 How to input the previous part of the remuneration from previous employement?
2.02 How to define the employee and employer EPF rate?
2.03 PCB Receipt...
2.04 ***Government Reports - RG-00301***
2.05 How wages is calc for frequency (1/2 monthly)? - RG-00324
2.06 How wages is calculate for employee join in the middle of the month? - RG-00363
2.07 ***Import Format - Example - RG-00364***
2.08 How to process Bonus? - RG-00326
2.09 ***Electronic Bank Ready list - RG-00302***
2.10 Can generate and print the Zakat Borang Skim Berkat?
2.11 Why the employee name still show at CP8D even PCB & CP38 is zero?
2.12 What circumstances the payroll will use socso type as SECOND Category?
2.13 Why Print PCB had a amount show as NaN? - RG-00331
2.14 Do Sole proprietor issue EA Form?
2.15 How to setup the wages and overtime for DAILY pay employee?
2.16 DIY Script-Overtime Pay Rate
2.17 Why the EPF & Socso calculation for employee & employer is only half for certain employee?
2.18 How wages is calc for resign on incomplete month?
2.19 Resident Status Type / Jenis Status Pemastautin
2.20 Why CP8D Column 2 is zero even I had selected Tax Code for allowance monthly?
2.21 Allowance Tax Exempted Code List
2.22 How the same Code for Wages/Allowance/Deduction pending work?
2.23 How is the Overtime Calculate?
2.24 What "Wages" meaning?
2.25 The 26 days denominator
2.26 Click Preview PCB (prompt error Trying to revoke a drop target that has not been registered)
2.27 Why Zakat is not shown in EA form?
2.28 Employer's EPF Contribution Rate For Employee Earning Up To RM5K
2.29 How to classified to PCB or PCB A?
2.30 What is System Pay Rate at Pending Overtime?
2.31 Why is Paid column in Payslip is Zero?
2.32 What is the Payslip Detail Sort by?
2.33 How the Cut-Off Day is working?
2.34 What Type of Earnings Are Subject To SOCSO Contribution?
2.35 What Type of Earnings Are Exclude from EPF Contribution?
3. Leave
3.01 Record the matter or reason to apply Annual Leave or Medical Leave.
3.02 How is Unpaid Leave is Calculate? - RG-00243
3.03 Leave Entitlement Calculation
3.04 Why my Leave Application Calender start with MTWTFSS instead of SMTWTFS?
3.05 How the Leave Limit is Calculate at Leave Application?
4. Settings (SQL Payroll)
4.03 What is Entry Date, Trans Date, Post Date & Process Date? - RG-00254
4.04 SQL View - Setting
4.05 What is "New Payroll Opening" for?
4.06 How to Reset Grid Layout to Default?
4.07 Product Activation
4.08 Application Installation
4.09 SQL View - User View vs Browse View
4.10 How to set Default Printer by Report?
5. Import Data
5.01 Import Employee Master Data from UBS Payroll
5.02 Import Employee Master Data from AUTOCount Payroll
6. Government Official Portal
6.03 Tax
7. Time Attendance
7.01 SynGlobal Attendance
7.02 Elid
7.03 FingerTec
7.04 Anviz
7.05 Click TMS
7.06 TimeTracX
7.07 CheckTime
Report Designer
1. Report Builder
1.01 Tips to reset the tool bars in Report Designer
1.02 How to load and extract out the reports in SQL Accounting?
1.03 Non-stop generating pages while preview/export (especially run in large data)
1.04 Why purchase order is generating 2 pages for ONE (1) item only?
1.05 Why when Export to PDF format the Company Logo look "ugly"?
1.06 When I print Cheque Layout the font become smaller?
1.07 How to Get Data Field Directly from DB?
1.08 How to Get Data Field From Avaiable Pipeline?
1.09 Special DisplayFormat
2. Fast Report
2.01 How to load and extract out the report format in SQL Payroll?
2.02 How to print 2 same payslip in 1 A4 paper?
2.03 Special DisplayFormat
2.04 How to use Line function?
2.05 How to use Page function?
2.06 How to Loop Data Pipeline?
2.07 How to prompt MessageDlg function?
2.08 Shift Relative To Simulator
2.09 Simple Video
Firebird
01. How to corrupt a database?
02. How to slow down the computer?
03. Firebird 2.5 is come with 3 types of Server
04. Firebird Control Center (0.4.2.215)
05. Firebird terminated abnormally (4294967295)
06. Firebird On-Disk-Structure (ODS) List
07. How to set the Schedule Backup using Windows Schedule?
08. Choosing the right RAID configuration for Firebird.
09. How can I check in which of these modes an installed database is running?
10. Firebird recommended setting (Must Read)
11. Supercharging FirebirdSQL
12. What is the limit on the Firebird database size?
13. Possibility problem happens in Standalone firebird mode
14. How to set Firebird database in ODBC?
15. 45 Ways To Speed Up Firebird Database
Printers
01. Panasonic KX-P3626 failed to match the paper size print-out
02. Understanding the setting print spooler options
03. Access Denied Error when try to add new printer driver, like EPSON LQ850
04. ***Multifunctional Copiers - Photocopy Machine***
05. Reasons the computer cannot send print to the printer.
06. *** What alternative driver/Software Emulation for ...?***
08. How to Add Custom Paper Size?
09a. Multifunctional Copiers-Konica Minolta PagePro 1350W
09b. Multifunctional Copiers-Ricoh Aficio MP C3000 PCL 6
10. Why workstation preview/print out is 1 pg but at server preview/print out is 2 pages & both use same printer driver, OS, report format, Doc No & Doc Type?
11. Error on Adding New printer - Error printer driver was not installed. Access is denied.
12. Why when I preview any report it take time to shown or print?
Anti-Virus Issue
01. Kaspersky Anti-Virus
1.1 How to create an application rule in Kaspersky Internet Security 2010?
1.2 Identify the error messages caused by Kaspersky
1.3 KIS2012-Safe Run for Applications
1.4 Local network does not function after I have installed Kaspersky Anti-Virus for protection of personal desktops and workstations version 6.0 under Windows XP Service Pack 2. Why?
02. Avira Anti-Virus
03. Panda Anti-Virus
3.1 Firewall setting in PANDA Internet Security 2011
04. AVG Anti-Virus
4.1 AVG Firewall asks for confirmation warning
05. ESET Smart Security
5.1 Firewall setting in ESET Smart Security 4
06. 360 Kill Poison (360 杀毒)
6.1 Temporary solution for SQLRDesktop.exe has detected "HEUR/Malware.QVM11.gen" (360 Update: 20/04/2011)
6.2 How to add "Trusted" in 360 Kills Anti Virus
07. Norton Antivirus
7.1 Failed to download and run SQLRDesktop.exe (Norton updates: 27/04/2011)
08. McAfee Anti Virus
8.1 "Error while trying to login to Firebird server....Failed to establish a connection using McAfee Anti-Virus!
09. KingSoft Anti Virus
9.1 First time setup the Firebird and SQL Financial Accounting in server using KingSoft Internet Security
9.2 "Error while trying to login to Firebird server....Failed to establish a connection. Access is denied" using KingSoft IS
10. Antivirus Comodo Internet Security Premium
Windows Issue
01. How to Delete files protected by Windows 7 Trusted Installers?
02. Where to create the exception port number in Windows Firewall?
03. Where to change the date format using (DD/MM/YYYY)?
04. Windows Vista - File & Printer Sharing
05. How to recall/recover the printers back in Control Panel ?
06. How to make the system able to record chinese words?
07. Command PING for the connection testing between the server and computer
08. Direct Email Setting - How to Disable Prompt Confirm Email Dialog?
09. Problems with opening CHM Help files
10. Cannot access the shared folder due to Blank Password not allowed!
11. How to change Com Port number?
12. What is Client Access License (CAL) works in Windows server products?
13. Windows General Keyboard Shortcuts
14. Class no registered, ClassID: {CD000001-8B95-11D1-82DB-00C04FB1625D}
15. XP (SP1, 2 or 3) appears to lose permission to access File Shares on Vista or Server 2008 x86 or x64
16. Error message: Not enough server storage is available to process this command
17. Error Message : Registry Editing has been disabled by your administrator
18. What is the different Big5 & GB for Chinese Character?
19. Performance Improvement for Domain Controller service
20. Windows 8: TOUCH - Swipe, Tap and Beyond
21. Windows 8: How to show My Computer, Network & Control Panel at Desktop?
22. Windows 8: How to restore the START button?
23. Shortcut to Control Panel Items.
24. Windows 8 : SmartScreen - SQL Remote Desktop
25. Can Access computers by IP addresses, but not by Computer Name
26. Microsoft Product Lifecycle Search
27. How to Add, remove or change a trusted location for Excel?
28. Prompt "External Exception C015000F" on run any application
Comment
General Support Guideline
HIME
4.03 I cannot input the value into the % column in Profit Estimator
Because the Total Cost is ZERO.
Google Sites
Report abuse
Google Sites
Report abuse
