Technical Tips

QSS related_Delphi

Unable to login DB "You are not allow to connect to this database because all the connections is fully occupied at the moment."
1) Please make sure you are connecting to a registered QSS. 2) Please make sure the database was registered. 3) Please check how many users are currently ...
Fri, 18 Dec, 2020 at 11:13 AM
QSS not stable, already registered 2 times successfully but after few days it become unregistered.
The License Update Software may be corruptted or not compatible with the OS. Please perform the below steps: 1. Right Click Task Bar and select Task Manage...
Fri, 18 Dec, 2020 at 11:15 AM
Fail to locate database upgrade file
How to solve the error "Fail to locate database upgrade file" prompted during upgrade QNE Delphi database?  1. When you open and try to upgrad...
Fri, 18 Dec, 2020 at 2:40 PM
Why when double click QnE icon, sytem will automatically login to particular Database?
Double click QnE icon > click Close (System still remain QnE Page) > File > Open company >  untick the auto star-up database
Mon, 21 Dec, 2020 at 12:44 PM
Error Message at Bank Reconciliation "31-Jan-09" is not a valid date. can't Save.
Control panel>Regional and Language Settings- choose United States
Mon, 21 Dec, 2020 at 12:44 PM
Error Message when do upgrade " Cannot Copy AxmsCtrl: It is busy used by another person or program. Close any programs that might be using the file and try again".
1.Go to Services > Stop this 2 file > QnESMSClientSVC and QnESMSServerSVC. Then do upgrade. 2. After done upgrade you Start it again.
Mon, 21 Dec, 2020 at 12:39 PM
Script to check the transaction which is posted to GL but does not appear in Bill Entries
select *  from gltransaction where journaltypecode = 'BILL' and documentno not in (select billcode from bill)
Mon, 21 Dec, 2020 at 12:39 PM
Serial no already sold out or issue out allows to stock IN again
Our System is working like this: Even though there are setting in system option - stock 2 - Allow duplicate Serial no. is untick, 1. Purchase item AAA a...
Mon, 21 Dec, 2020 at 12:43 PM
Change agent A to Agent B for all transactions
Question: Change There is a agent A already resign, all his transactions want to transfer to agent B. I need a script which can update all transaction from...
Mon, 21 Dec, 2020 at 12:43 PM
When login QnE prompt : cannot attach to password database
Go to C:\Program Files\Firebird\Firebird_1_5\security.fdb, right click on Properties -> untick for Read Only
Mon, 21 Dec, 2020 at 12:50 PM