BackEnd Philipine
1) Store Added field
2) Store Terminal Added fields
3) Discount added type
4) Product master add 2 settings
4.1) DISC:Senior citizen 	(m_status position 10)
4.2) DISC:Person disability	(m_status position 11)

Database
1)MAS_STORE
ALTER TABLE MAS_STORE ADD M_TIN D_REMARK40 DEFAULT '00000000000000000000'
---
UPDATE MAS_STORE SET M_TIN='00000000000000000000'

2)MAS_WORKSTATION
ALTER TABLE MAS_WORKSTATION ADD M_MIN D_DESC DEFAULT '00000000000000000000'
---
UPDATE MAS_WORKSTATION SET M_MIN = '00000000000000000000'
---
ALTER TABLE MAS_WORKSTATION ADD M_SERIAL D_DESC DEFAULT '00000000000000000000'
---
UPDATE MAS_WORKSTATION SET M_SERIAL = '00000000000000000000'
---
ALTER TABLE MAS_WORKSTATION ADD M_PTUISSUED d_date
---
ALTER TABLE MAS_WORKSTATION ADD M_PTUVALID d_date
---
ALTER TABLE MAS_WORKSTATION ADD M_FOOTMSG d_memo
---
ALTER TABLE MAS_WORKSTATION ADD M_PTUNO D_DESC DEFAULT '00000000000000000000'

10.44.11.0
----------
1) Product master add 5 settings
1.1) Exempt All    = 1		(m_status position 8)
1.2) Exempt SC     = 2		(m_status position 8)
1.3) Exempt PWD    = 3		(m_status position 8) 
1.4) Exempt SC+PWD = 4		(m_status position 8)
1.5) DISC:Senior citizen	(m_status position 9)
1.6) DISC:Person disability	(m_status position 10) 
1.7) DISC%:Senior citizen 	(m_status position 11-15) - last 2 digits is decimal
1.8) DISC%:Person disability	(m_status position 16-20) - last 2 digits is decimal 

2) Separate the End of Shift (POSEOS) from the Close Shift Report as individual control.

10.44.12.0
-----------
1. Stock Take Batch preparation - avoid the message prompt, just skip
2. Stock Return Batch Excel In - include checking on valid Store and include Supp Invoice

10.44.13.0
----------
Database
--------
ALTER TABLE MAS_STOCK_SUPP ADD M_DISCOUNT D_MONEY DEFAULT 0
ALTER TABLE MAS_STOCK_SUPP ADD M_DISCOUNT_DATEFROM D_DATE
ALTER TABLE MAS_STOCK_SUPP ADD M_DISCOUNT_DATETO D_DATE

ALTER TABLE MAS_STORE ADD M_SALES_UPDATE D_STATUS DEFAULT 'F'
ALTER TABLE MAS_STORE ADD M_DOCUMENT_UPDATE D_STATUS DEFAULT ''

1) Purchase Order module
1.1) Able to maintain PO discount% by SKU per supplier.
1.2) Re-calculate the PO discount% when change discount amount

2) Product Master
2.1) ADD TRANSIT IN (per store) QTY INTO Product Master -> Pages -> STK TURN OVER ENQUIRY

3) Sales Update 
3.1) check for M_SALES_UPDATE and M_DOCUMENT_UPDATE in MAS_STORE before proceed.
3.2) update the M_SALES_UPDATE field in MAS_STORE to lock the status to prevent other document update.

4) Document Update
4.1) check for M_SALES_UPDATE and M_DOCUMENT_UPDATE in MAS_STORE before proceed.
4.2) update the M_DOCUMENT_UPDATE field in MAS_STORE to lock the status to prevent other document and sales update.
4.3) Affected module := (TURN-OFF)
4.3.1) Sales Order 
4.3.2) Delivery Order / Batch Update
4.3.3) Purchase Order 
4.3.4) Stock Receiving / Batch Update
4.3.5) Stock Return / Batch Update
4.3.6) Stock Adjustment 
4.3.7) Stock Transfer
4.3.8) Stock Take PreListing/Prepation / Batch
4.3.9) Stock Take Entry / Batch Update / Batch Update By Store

10.44.14.0
----------
1) Sales Update
1.1) Improve performance speed
1.2) Auto re-run when system have been locked, applicable for scheduler only

10.44.15.0
----------
[Database]
ALTER TABLE STK_DATE_UPDATE ADD S_SALES_UPDATE D_STATUS DEFAULT 'F'

[New Feature]
1) Purchase Adjust added Line Settlement/Undo Settlement
2) Document update Un-check M_DOCUMENT_UPDATE in MAS_STORE
3) Sales Update
3.1) Add new field in STK_DATE_UPDATE to control the rerun function
3.2) Add 'Locking' column in Store datagrid and addtional button to reset the flag.
3.3) Re-run function open for manual operation, not only restrict for scheduler.

[Fix]
1) Sales Update
1.1) Update the S_UPDATE and S_AvgCost in STK_MOVEMENT
1.2) resolve the S_LSDATE not updated for new item
2) Resolve the Product Master screen [BIR version], Exemption for PWD not saved issue.

10.44.16.0
----------
[Database - POSAPP]
CREATE TABLE MAS_GROUP_PURCHASER (
  M_GROUP D_CODE NOT NULL,
  M_CODE D_VARCHAR10 NOT NULL,
  PRIMARY KEY (M_GROUP,M_CODE)
)
---
ALTER TABLE MAS_STOCK_SUPP ADD M_CURRENCY_AMT D_FOREIGN DEFAULT 0

[Database - POSHIS]
CREATE TABLE STK_TRANSIT_LOG (
  S_ID VARCHAR(35) NOT NULL,
  S_STORE_FROM VARCHAR(4) DEFAULT '' NOT NULL,
  S_STORE_TO VARCHAR(4) DEFAULT '', 
  S_SUPPLIER VARCHAR(6) DEFAULT '',  
  S_DOCUMENT VARCHAR(1) DEFAULT '' NOT NULL,
  S_REFNO VARCHAR(10) DEFAULT '' NOT NULL,  
  S_DATE TIMESTAMP,
  S_INVOICENO VARCHAR(20),
  S_QTY D_DOUBLE DEFAULT 0,
  S_TOTAL D_DOUBLE DEFAULT 0,
  S_STATUS VARCHAR(1) DEFAULT '' NOT NULL,
  S_REMARK VARCHAR(40) DEFAULT '',
  S_ACTION VARCHAR(20),
  S_USER_POST VARCHAR(10) DEFAULT '',
  S_DATETIME TIMESTAMP DEFAULT 'now', 
  PRIMARY KEY (S_DATETIME, S_ID)  
)

[New Feature]
1) Group Master module
1.1) Allow to add purchaser under Group
1.2) Setting to enable or disable Group Purchaser (Preference > System Setup > Enable Group Purchaser)
2) Product Master module
2.1) Supplier Link tab - add new column 'Currency Code' and 'Currency Amt'
3) Stock Receiving
3.1) Add new column 'WH/BAL'
3.2) Keep track the log of Transit In and Reverse Transit activities into table STK_TRANSIT_LOG 
3.3) Access right control for Reverse Transit (User Group > BackEnd System > BackEnd System tab > Other Setup)
3.4) Report listing for Transit Log (Tools > Transit Log)

[Fix]
1. Stock Adjustment
1.1) Resolve the WH/BAL column not reflected issue
2) Purchase Order module
2.1) Foreign Currency
2.1.1) supplier is using foreign currency (Supplier Master) or item under supplier (Supplier link in Product Master)
       is using foreign currency
2.1.2) only allowed to change the value for Curr.Cost, Disc(-) and Curr.Total
2.1.3) convert to local currency and display in Ord.Cost, Disc(-) and Total column

10.44.17.3
----------
1£© DbUpgarde script checked

10.44.18.3
----------
1) Closing processing updated:-
	1.1) Month end closing by Store
	1.2) Year end closing by store

10.44.18.3(A)
-------------
1) 42,ALTER TABLE STK_MLEDGER S_RECEIVE_AMT ADD D_MONEY DEFAULT 0

10.44.19.3
----------
1) User Group Access added 
1.1) READPO | Purchase Order Read-Only
1.2) READRC | Receiving Read-Only
2) Purchase Order Read-Only
3) Receiving Read-Only
4) User Passowrd and Card ID added encryption
4.1) Login checked encryption
4.2) Change Pwd added encryption

10.44.20.3
----------
1) Stock Return - Fixed
   ALTER TABLE STK_MLEDGER S_RECEIVE_AMT ADD D_MONEY DEFAULT 0
2) Supplier Return Note - Fixed
   APSRFX | Supplier Return Note
3) Stock Return report tree added RecvTotal and RecvTotal_Difference

10.44.21.3
----------
1) Product master - Mix & Match type added expired