I want to create a simple app/website where we simple put our products in and out and create a report based on product I think this picture can tell you what i need, specially i want to show opening balance from speicific date. I already created it once in VB6 and SQL server but now i need it to be online where multiple user are adding products, I want to know which programming language or tool or app is best to create such ledger, if there is any extension or pluging that can do that please advice. I already google and search a log, no joomla plugin or no wordpress plugin is allowing me to do that , so any help is appreciated
the tools and approaches you can consider: 1. Web-Based Solutions: Spreadsheet Applications (Google Sheets, Microsoft Excel Online): Pros: Familiar interface, collaborative editing, readily available online. Cons: Limited customization, data security concerns for sensitive information. Online Accounting Software (Xero, QuickBooks Online): Pros: Built-in features for inventory management, invoicing, reporting. Cons: May require paid subscriptions, functionalities might be more extensive than you need. Custom Web Development: Pros: Tailored to your specific requirements, high level of control and flexibility. Cons: Requires programming knowledge or hiring a developer, ongoing maintenance might be needed. 2. Open-Source Frameworks (if you have programming experience): Django (Python): High-level framework for building secure web applications. Ruby on Rails (Ruby): Convention-over-configuration approach for rapid development. Express.js (JavaScript): Flexible framework for building APIs and web servers.
Sounds like you need a web-based inventory ledger with multi-user access and reporting features. If you're looking for something simple yet powerful, consider using Laravel with MySQL for the backend and a React or Vue frontend. Alternatively, if you want a no-code/low-code solution, platforms like Airtable or AppSheet might work, though they may have limitations. Have you checked Odoo? It has inventory modules that might fit your needs.
There are lots of questions I'd have to ask but to start with why not just use a google sheet and share it with the relevant people and have separate tabs for the autogenerated reports. It even includes and audit trail. Your biggest issue is with managing access to the information and the quickest way to handle that is to use an existing CMS. Lets say you chose wordpress - forget the front page (but why not use if for something useful) - and write a simple admin plugin that manages the stock movements and generates the reports? You can get much much fancier but you need to look at the costs (time & money), the number of users, the frequency that those users get replaced, training etc.
You can make it in C# and mssql if you simply want to put it online on a website/app etc. I suppose you might be already familiar with those, although C# is very different from vb6. If you want to make it into a plugin, then you will need some PHP know how also, since all those other platforms you mentioned (joomla, wp, etc) are coded in PHP and so are their plugins. You don't need to code the whole thing in PHP, instead, you can let your server handle requests while the plugin simply connects to your server to get/put data, not sure how many people would be comfortable in storing their financial info on third party servers though, in which case, the whole plugin needs to be coded in PHP/mysql. A PHP/MYSQL setup can also be put online, might require you to learn PHP though.