Allow access to remote mysql server
You have to put this as root: GRANT ALL PRIVILEGES ON *.* TO ‘USERNAME’@’IP’ IDENTIFIED BY ‘PASSWORD’ with ...
DetailsDelete Duplicate Invoice created due to improper Roll-Back in PTHM Sales Execution
Background: There are few occasions when a complete roll-back of sales execution process cannot happen due to network ...
DetailsHow to modify or reverse a Work Order in QAD
Method 1: Use Work Order Maintenance to open the Close Work Order by changing the status from C ...
DetailsHow to import very large MySQL database in XAMPP
Certainly, this method is very helpful when you have a very heavy SQL file to be imported to ...
DetailsHow to adjust Customer Balance in QAD
Reduce Customer Balance: Create a Credit Note using Customer Invoice Create menu. (Invoice Type: Credit Note; Daybook: CUCRNFIN; ...
DetailsSub-Account/Project Creation
Sub Account Creation Go to Sub-Account View and check the sub-account code already exists or not. Update the ...
DetailsUnlock Auction Sale for other Buyer entry after Purchase Approval
Background: There are situations when Tea Trade Department figures out some lots previously marked as ‘Unsold’ were actually ...
DetailsHow to Unlock/Lock Auction Sale No.
It is required for MDM to unlock a sale before catalogue entry for that sale can be made. ...
DetailsCountry Creation/Country of Origin creation/State creation
Country Creation Add new line in control file in Country_create tab for new country. Add country code carefully ...
Details