Support Services: Checklist for change server sitecode / Delete Branch Answer:
what will happen to the transactions and the data created using the old sitecode?
will the data created using the old sitecode be transferred to the main ...
Support Services: Deleting client sales Answer: Pre-update Questions:
Have you created a backup of the data?
Has the client reported the sales they made to the BIR?
this is to make sure that we ...
Support Services: Checklist when copying products from another branch Answer:
ask the client which data to include
if product is requested to be included double check the following
do you copy the branchprice
the product image should be ...
Documentation: POS Settings List Answer: V4.4.4.0
Retail POS Settings
Important Settings (data related):
POS Sync Mode
0 = ServerPos; 1 = PosOwnDb
If set to ServerPos, transactions are saved to sync table.
If set to PosOwnDb, ...
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: 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: Run MYSQL DB COMARE Answer: 1. go to the directory where mysql db compare is found using CMD and run this command:
mysqldbcompare --server1=root:121586@'10073-15-POS03' --server2=root:121586@'127.0.0.1' nelsoft:nelsoft --run-all-tests --changes-for=server1 --difftype=differ --skip-data-check --skip-row-count ...
