Other Technical Tips

QLS related_Optimum

Error Invalid column name ‘UnmatchedAmount’ during database upgrade.
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
(Optimum) Filter Non-Tally Debtor Aging versus Debtor Ledger
Connect to Database use Microsoft SQL Server Management Studio, Please refer How to Connect to Database use Microsoft SQL Server Management Studio and How ...
Thu, 12 Nov, 2020 at 9:28 PM
(Optimum) Upgrade database prompted Bank Reconciliation error SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 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
[Optimum] Login failed for user 'SA' because the account is currently locked out. The system administrator can unlock it.
When want to login QNE Optimum, prompt error "Login failed for user 'SA' because the account is currently locked out. The system administrato...
Tue, 10 Nov, 2020 at 4:13 PM
(Optimum) Upgrade database prompted Incorrect syntax near 'S'. Unclosed quotation mark after the character string ''.’
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
(Optimum) Open Transaction prompted “Requested objects cannot be loaded, because they are absent in the data store. These objects can already be deleted/purged.”
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
(Optimum) Outstanding Invoice still show in knock off screen after matched
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
[Optimum] Upgrade database prompted The wait operation timed out
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
[Optimum] Unable to create or restore database "The file "C:\Program Files\xxxx.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed"
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
How to manual attach database into SQL Server with SQL Management studio
Manually attach database (.mdf) into SQL Server with Management Studio   1.    Download and install SQL Server Management Studio from below link   Pleas...
Wed, 11 Nov, 2020 at 9:43 AM