General Processes/Information: POS accreditation Answer: For temporary use only:
ACC: 02950000000333052047391PosProviderName= OmegaPOS Inc.PosProviderAddress=21st Floor, The Enterprise Center, 6750, Ayala Avenue, Makati, 1226 Metro ManilaPosProviderTIN=Supplier TIN: 000-003-290-370ACC_date=Date Acc.: 03/15/2011
For NTS (Nelsoft Technology ...
Common Problems: Common update problems: patcher [unknown database 'nelsoft_retail'] Answer: Error encountered:
The cause:
Solution:
Set the environment variable to the path where the mysql.exe can be found. It's usually under program files\mysql\mysql server 5.5\bin (remember to put ...
Core C-Sharp: Retail POS Change Log Answer: 4.4.17.0
Mantis #60451
Added "Approval Date" setting on Header Details tab on Settings.
Modified checker if the approval date has changed.
Mantis #60027
Added new setting "Show Zero Priced Items" ...
Core C-Sharp: AutoSync v4 Change Log Answer: v4.0.4.34
Mantis #114863
Fix sync stuck: idempotent sync table insert and force-remove wids from sender on failure
v4.0.4.33
Mantis #114446 (revision)
fix conditions for syncing
v4.0.4.32
Mantis #114446
add feature if failed to ...
Core C-Sharp: Autosync v5 (Manualsync) Change Log Answer: v5.0.2.1
Mantis #57079
Added an exclusion list to delete from sync table to prevent sending superadmin user data.
Added a filter in rare case an update happens after ...
Queries: Update POS to OWN db first before the server. Answer: Directly update POS to OwnDB without updating server yet
Add column in branch table- localnetworkip = pcname- port = 80
Add the Terminal table and the terminal ...
Queries: Compare Server vs POS data Answer:
set @branchid = 1;
set @terminalno = 1;
set @startdate = '2000-01-01';
set @enddate = '2020-12-30 23:59:59';
select @terminalno,
sales.´sales amount´,
collection.´collection sales amount´,collection.´collection detail amount´,
...
Queries: Select all POS settings for documentation Answer: set group_concat_max_len = 10000000;
set @branchid = (select ´value´ from config where particular = 'branchid' limit 1);
set @terminalno = (select ´value´ from config where particular = ...
