Other Technical Tips
QLS related_Optimum
Error Invalid column name ‘UnmatchedAmount’ during database upgrade. *update from old version before 2018 to latest 2019 version Wh...
Tue, 17 Nov, 2020 at 11:33 AM
Connect to Database use Microsoft SQL Server Management Studio, Please refer How to Connect to Database use Microsoft SQL Server Management Studio and How ...
Fri, 25 Jun, 2021 at 3:40 PM
Solution: 1. Login database and ignore database upgrade. 2. Go to Tools > Database Utility > Database Util. 3. Connect to database and execut...
Tue, 10 Nov, 2020 at 4:10 PM
When want to login QNE Optimum, prompt error "Login failed for user 'SA' because the account is currently locked out. The system administrator ...
Tue, 10 Nov, 2020 at 4:13 PM
Solution: Root Cause: Quotation mark (‘) were used as opening and closing in Software’s query Happened when Company Name exist quotation marks like (AL...
Wed, 11 Nov, 2020 at 9:07 AM
Solution: Go to Stocks > Stock Items > Search Select Edit and click ‘Scan UOM’ On the result, take note / mark down of those Stock Code that mis...
Wed, 11 Nov, 2020 at 9:11 AM
SCENARIO: Example: OR1603/080 matched with INV1603/011 1. Go to Debtor > Receive Payment > search out OR1603/080 and verify that full matched ...
Wed, 11 Nov, 2020 at 9:20 AM
Solution 1 : Run below script: https://drive.google.com/open?id=0BzrrsMUq-H6gMUFjRWFYaXB3S0E **Query will run for long time If after run Solutio...
Wed, 11 Nov, 2020 at 9:31 AM
The error message: Solution: Refer below picture, go to the SQL data folder(eg.C:\Program Files\Microsoft SQL Server\MSSQL10_50.QNEBSS\MSSQL\DATA) pr...
Wed, 11 Nov, 2020 at 9:34 AM
Attach Database in SQL Server manually with SQL Management studio 1. Download and install SQL Server Management Studio from below link Please ref...
Fri, 25 Jun, 2021 at 5:03 PM