A collection of useful SQL scripts which can be used in your favourite SQL Editor or added to uniCenta oPOS and include:
- Clear Transactions - Clear uniCenta oPOS data except Categories and Products
- Daily Sales - Exactly that!
- Day Of Month - Sales by day per month
- Hourly Sales - Exactly that!
- Month Of Year - Sales by Month
- Monthly Sales - Sales by Month
- Week Of Year - Week number of Year
- Weekly in Year - Weekly sales
- Yearly Sales - Compare historical sales
|uniCenta oPOS additional SQL scripts|| |