Other Technical Tips

QLS related_Optimum

How to tick Stock Batch Number for Stock item which already have Transactions
Scenario: Solution: Step 1 - Press Start > Search SSMS > Then Execute "Microsoft SQL Server Management Studio" Step 2 - ...
Thu, 25 May, 2023 at 4:28 PM
How to access Cloud Hosting DB via SSMS?
Scenario  How to access the Database when it was hosted in QNE Cloud Server d3.qne.cloud ? Server Name: d3.qne.cloud User ID: qnebss@qned3 Password: Q...
Fri, 16 Jun, 2023 at 6:05 PM
Invalid Column Name 'AllowPrintControl'
Scenario Login Database via QNE Optimum or QNE WeChat prompted Invalid Column Name 'AllowPrintControl' Solution 1. Launch SSMS and connec...
Wed, 21 Jun, 2023 at 10:29 AM
How to solve ‘Concurrent user limit has reached’ when login system
Upon login system, user may encounter like error below   Solution: At Server PC > search QLS   In the panel, click Stop (make sure all user...
Fri, 7 Jul, 2023 at 12:10 PM
Aging Report compare with Ledger report not tally due to wrong matching info
Scenario : Note : As we can see both Pay Bills, and Bills are selected different Supplier, but this both transaction have matched info in backend A...
Thu, 27 Jul, 2023 at 3:06 PM
Journal Entries Debit Credit Variance with General Ledger (Not Tally)
Scenario : As you can see both Journal Entries and its posting happen extra 1 cent, this is due to currency rate issue, mostly we can resolve by cr...
Thu, 27 Jul, 2023 at 11:56 AM
Statement of Account display Duplicate Invoice
Scenario : Solution : 1. Suggest to Update latest Version, if version not fixed 2. Due to incorrect ways import of Credit Limit, caused duplicate ...
Thu, 27 Jul, 2023 at 5:34 PM
Where to find SQL Server Configuration Manager
Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?  Here is w...
Fri, 28 Jul, 2023 at 9:56 AM
How to use “Favorites” in reports
Having a “Favorites” Menu is one way for the user to easily access the needed reports to be generated in the system without the need to head out in the Repo...
Fri, 28 Jul, 2023 at 10:28 AM
How to resolve Profit and Loss Report display less option
Scenario : Solution : Press File > Press Modules. System will prompt out the Modules List, Press "Apply Changes", then "Press...
Fri, 28 Jul, 2023 at 10:36 AM