Other Technical Tips

QLS related_Optimum

I cannot find SQL Server Manager from start up
I cannot find SQLServerManager from start up  Solution:  You can check C:\Windows\SysWOW64 then look for SQLServerManager 
Mon, 30 Nov, 2020 at 5:45 PM
AFTER REPAIR SUSPECT DATABASE ERROR OCCURS Requested objects cannot be loaded, because they are absent in the data store. These objects can already be deleted or purged.
Scenario  After Repair suspect Database, while click transaction screen or report error occurs: This type of issue mostly database suspect, after r...
Thu, 17 Dec, 2020 at 5:32 PM
QNE Optimum Multiple Transfer item within same Document
Scenario  How to Multiple Transfer item within same Document Solution  Transfer same item but difference Qty in sales. 1. Go...
Thu, 5 Aug, 2021 at 12:01 PM
How to change qty decimal to 2 decimal
By default system will show zero decimal point for QTY and 2 decimal for U.PRICE.  Example : Sales Invoice How to change decimal point in Sales Tra...
Sun, 28 Feb, 2021 at 2:30 PM
Add Multiple SQL instances in SQL Management studio
Scenario  Example if users have installed more than 1 instance as below: But in SQL Management only show 1 instance, How can we Add Multiple SQL inst...
Mon, 28 Jun, 2021 at 11:02 AM
How to restore a database with SQL Management Studio
Scenario  Restore a Backup, which Backup from SQL Management Studio or Restore a Backup download from QNE Azure Cloud Server. Usually QNE Backup file ha...
Tue, 15 Jun, 2021 at 3:47 PM
Accounting Software Transfer License From QNE Optimum Registration
Scenario  Except from Deactivate License from QLS. Example: - If User Server PC need to change hardware. - If User wants to proceed ...
Thu, 5 Aug, 2021 at 11:33 AM
Optimum Upgrade Database prompted Subquery returned more than 1 value
  Scenario  Upgrade Database prompted “Subquery returned more than 1 value.  This is not permitted when the subquery follows =, !=, <, <= , >...
Wed, 30 Jun, 2021 at 6:23 PM
How to rebuild and reorganize indexes ?
Scenario  Searching and reading data is getting slower even after performed increased Disk Free Space and Disk Defragmentation but SSD is not an option t...
Wed, 30 Jun, 2021 at 6:30 PM
How to Record Problem in Video via Loom
&nbsp; 1. Search for loom from web browser or&nbsp;https://www.loom.com/&nbsp;to download application&nbsp;&nbsp; &nbsp; 2. If you...
Mon, 26 Jul, 2021 at 10:50 AM