I need a stock control system with following features:
- Administrator should be able to create new user accounts, revoke old ones etc.
- Password protected user accounts. User should be able to change their password.
- Asian Jewellers stock control. Purchases and sales
- Stock can be new jewellery, used jewellery or melted gold
- Each stock type has different type of information to be held
- Cash and bank money management
- Any sales income should be reflected in cash in hand or bank
- Any purchases of stock also should relflect in cash in hand or bank
- Customer returns and refunds
- Report total sales at the end of the day
- Report how much cash should there be at the end of the business day
- Report how much money should be in the bank at the end of the business day
- Any sales should automatically update the stock
- Total new, used stock remaining report
- Entry of expenses into system so that cash in hand and bank is updated automatically
- And all common and basic EPOS functions.
The system will be used as back-end administration system.
System to be in MS Access.