I need mysql db modifing to include 5 batch numbers and expiry dates in Chromis POS

I used Chromis POS a dirivative of unicena with is a dirivitive od Open Bravo POS all of these are open Source programs.

I operate a small pharmacy and would like to be able to enter and delete batch (lot) numbers and expiry dates with upto 10 if posible but 5 will suffice.

I would live the ablility to print A4 and letter paper size (selectable) receipt which should include Reference, Barcode, Category, Short Description, qty, unit price total price batch number and expiry date.

Also like to print report on expiry dates based on 9month 6month 3month 45days and 30days and 7day expiry to include reference, barcode, short description, batch number, expiry date and qty in stock of batch.

Also archive and auto delete from current stock record if no batch left.

Also to permenently incorperate Supplier and promotion (currenty have to manually add these to get access).

And change of currency from uk to Philippines on permanent bases option to change currency based on locallity.

On the reorder report I would like in supplier order with name of supplier as section title.

And additional back office to be able to choose upto 10 different databases to allow for different banches or businesses

Remove all other databases apart from mysql and all other chromis functionality to be retained.

Change all locallity to philippines.

Java MySQL PHP Arkitekturë softuerësh

ID Projekti: #18398458

Rreth projektit