Client base Manual
Attached is the unfinished document on how to use the client base system. ...
Copy orig to posd with option to change %
set @terminalno = 1;set @datefrom = '2018-01-01';set @dateto = '2019-01-31 23:59:59';set @branchid = 16;set @perc = 1;
delete from salesdetail_posd where headid in ( select ...
Checklist when changing terminalno
Create Backup
OR number should still be continuous.
Recompute the reading/get the last reading and change the terminal no.
Autosync branchid is changed.
Make sure all the pending data ...
Checklist for change server sitecode / Delete Branch
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 ...
Checklist when copying products from another branch
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 ...
Common deployment problems: Autosync
Branches are offline
scenario : All connections and settings are all correct and there are no error logs
Solution: database version number is not existing in either of the ...
Compare Server vs POS data
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´,
...
Cutoffs management
1. Each saleshead should have an equivalent number of transactioncutoffs table
set @terminalno = 1;
select count(*)
from saleshead
where terminalno = @terminalno;
select count(*)
from transactioncutoffs as T, ...
C-Sharp - Team Processes
Turnover/training sessions would be conducted by the teams every month. features that wll be discussed include:
any bugfixes that makes changes with regards to the user ...
Client Change Name Process
Client informs the HD that they have or will change their business name
[Help Desk] Create Mantis
[Help Desk] Update the client’s name in Logmein, Hamachi, Teamviewer ...
Company Dress Code Policy (Sept 8, 2014)
COMPANY DRESS CODE POLICY (SEPT 8, 2014)
TO/FOR : ALL EMPLOYEESFROM : HR DepartmentDATE : 08 September 2014
I. OBJECTIVE
It is the policy of the company to ...