A Desctop Application written in the Java programming language. JavaFX software platform combined with mySQL relational database management system were used for this project.
- What is ERPbasic
- Screenshots from the Desktop Application
BasicERP is a desktop application designed for companies that want to manage their business sales processes. It has a dynamic database that stores all the information that the user enters. It basically supports CRUD operations.
Users can create index cards for customers, suppliers, and products by filling out the required fields in the system. They can also create customer orders/supplier orders, add customer receipts, review customer balances, view customer moves, monitor sales and earnings for specified periods of time, track product moves, and manage the storage area based on supplies and purchases. In addition, statistical data can be generated based on user requirements.
All the information can be edited at any time according to the user's needs. The database is dynamically updated and pop-up warning messages appear whenever a change is made to the database.
The application was made in English language.
We can view, create, edit, or delete a supplier card by selecting 'Create/Edit Supplier' and then using the appropriate buttons on the top, depending on our needs.
We can add a new supplier order by selecting 'Add Supplier Order'. Numbering is automatically generated. By choosing the Supplier Id from the provided list, the Name is automatically populated. Then, we can select Products, either from the list or by typing their names, one by one. We fill in the Quantities and add them to the table. The Product Description is automatically generated. The program also calculates the Total Items. Finally, we can submit the order to the database or cancel our changes.
By selecting 'View/Edit Supplier Order', we can select an order from the list of all orders from all suppliers and view, edit or delete the order by using the corresponding buttons. It is also possible to filter the orders by a particular supplier using the drop-down menu in the upper right corner.
This is the appearance when we select to edit a specific order from the list.
Similarly, we can create a new product by linking it with an existing supplier and filling out all the required fields, including the tax percentage. The final tax is automatically calculated. We can also edit, delete, or view an existing product.
By using 'Stock', we can check all the products and their current quantities. The stock is dynamic and updates according to supplies and purchases.
Finally, 'Product Moves' allows us to view the movements of a particular product, which we select from a list. It displays all supplies and purchases of the specific product, in chronological order. We also have the ability to open an order from the list in an editing format, either by double-clicking it or by selecting it and pressing the 'Open Order' button. We can use the 'Refresh' button to update the list if we have made any changes.
Similarly to the supplier, we can view, create, edit, or delete a customer card by selecting 'Create/Edit Customer' and then using the appropriate buttons on the top, depending on our needs. When adding a new customer, we have to follow specific rules. In case of a problem, a pop-up menu will inform us of how to fix it.
We can add a new customer order by selecting 'Add Shipping Order' from the Customer Menu. Numbering is automatically generated. By choosing the Customer Id from the provided list, the Name is automatically populated. Then, we can select products, either from the list or by typing their names, one by one. We fill in the Quantities and the Discount (this is optional), and add them to the table. The Product Description, Unit Cost, Tax, and Final Cost are automatically generated. The program also calculates the Total Items, Total Unit Cost, Total Tax, and the Final Cost. Finally, we can submit the order to the database or cancel any changes.
In case we miss something while creating or editing an order, warning messages will prompt us to fill out any missing parts. Additionally, if we exceed the request for an item, warning messages will pop up and ask us to adjust the quantity based on the number of items remaining in stock.
By selecting the 'View/Edit Shipping Order' feature, we can select an order from the list of all orders from all customers and view, edit, or delete the order by using the corresponding buttons. It is also possible to filter the orders by a particular customer using the drop-down menu in the upper right corner.
This is the appearance when we select to edit a specific order from the list:
By selecting the 'Sales' feature, a list of all sales within the selected duration of time appears. The total sales for the chosen time period is also calculated and displayed in the bottom-right field. We can open any order in an editing format, either by double-clicking it or by selecting it and pressing the 'Open Order' button.
We can also add receipts from our customers by using the 'Add Customer Receipts' feature. It allows us to enter multiple receipts for a particular date. We choose the Date, select the Customer Id, enter the Amount, choose the Type of Payment, and add Notes (optional) for each customer. Numbering and the Customer Name are automatically generated. The total amount of receipts is calculated and displayed in the bottom field.
With the 'Customer Receipt List,' we can view a list of registered receipts for a specific duration of time that we choose. We can also edit or delete a receipt by selecting the receipt and pressing the corresponding buttons (EDIT RECEIPT/DELETE RECEIPT).
This is the appearance when we select to edit a specific receipt from the list:
By selecting 'Earnings,' a list of all receipts appears, concerning the duration of time that we choose. The total amount for the selected time is also calculated and presented at the bottom-right field. We are capable of opening any receipt in an editing format either by double-clicking it or by selecting it and pressing the 'Open Receipt' button.
The 'Balances' feature allows us to review Total Costs, Total Receipts, and resulting Balances for all of our customers. We can order the customers by any column by simply clicking on the title of the column. The image below illustrates an order based on Balances (highest to lowest). By re-clicking, the order is reversed.
Additionally, the 'Customer Moves' feature shows us the moves of a particular Customer, that we choose from a list. It displays all Orders and Receipts from the specific customer in chronological order. We also have the ability to open an order/receipt from the list in an editing format, either by double-clicking it or by selecting it and pressing the "Open Order/Receipt" button. We can use the 'Refresh' button to refresh the list in case we made any changes. The customer's balance also appears in the bottom-right field.
A number of Statistics can be calculated and presented in bar charts and pie charts, as follows:
Number of products per supplier.
Sales per month, depicting all months from all the years so that we can compare sales for the same month for different years as well as sales for different months for the same year.
Best 5 selling products, for the duration of time that we choose according to our needs.
Best 5 customers, for the duration of time that we choose according to our needs.
