Other Technical Tips

QLS related_Optimum

How to trace Transaction Missing One side posting caused by DB Corrupt/connection issue
SCENARIO: As per sample below, Transaction only have single posting. by right should be Debit Purchase, Credit Supplier account. Note: above issu...
Tue, 19 Jul, 2022 at 10:06 AM
Microsoft SQL Server Move Database Files Step By Step
Problem SQL Server Database Administrators often face the task of moving user database files to a new location. The reasons for these changes can be separa...
Mon, 8 Aug, 2022 at 1:46 PM
Preview a many pages report prompt System.OutOfMemoryException
Scenario  Preview Report with many pages prompt “System.OutOfMemoryException”   This is due to Image file in RTF format is a long code. When Report c...
Mon, 21 Nov, 2022 at 5:46 PM
How to verify the transaction has been printout how many times
Scenario  In QNE Optimum, there is an additional info called Print Count for user to check how many times the transaction been printout previously. Exam...
Thu, 24 Nov, 2022 at 1:33 PM
How to allow lower case letter in Chart Of Account
Scenario  Some user preferred to use lower case letter in Chart Of Account but QNE Optimum default setting was Upper case letter only.       Soluti...
Thu, 24 Nov, 2022 at 2:13 PM
Cannot connect to WMI provider
Scenario  Open SQL Server Configuration Manager in SQL Server prompt “Cannot connect to WMI provider. You do not have permission or the server is unreac...
Mon, 5 Dec, 2022 at 1:38 PM
SQL Server Instance installation prompt Specify a directory that is not compressed
Scenario  SQL Server Instance installation prompt “The specified directory, “C:\Program Files\Microsoft SQL Server\”, for the INSTALLSHAREDDIR parameter...
Thu, 8 Dec, 2022 at 1:41 PM
Invalid Column Name 'IsTaxInclusiveOnly' prompted when upgrade database in Optimum
Scenario  When upgrade database in QNE Optimum prompted “Invalid Column Name 'IsTaxInclusiveOnly'’.   This might happen when upgrading a very o...
Thu, 22 Dec, 2022 at 5:24 PM
To have Bank File Spec Export (Bank Muamalat IBIZ Bulk Payment)
Requirement Bank File Spec preparation from Bank Muamalat : Please refer this attachment. Solution with QNE Optimum: 1s...
Wed, 8 Feb, 2023 at 1:53 PM
How to access Academy Portal
Problem: Solution: Step 1 - Please visit our Academy Portal with this link : https://academy.qne.cloud/ Step 2 - Press Sign In. ...
Fri, 10 Feb, 2023 at 12:09 PM