Job Ordering System using VB.Net and MS Access
This system is created using Visual Studio and MS access for database support. This project has many features, and this feature will discuss how to use the system.
How to use Job Ordering System
•When you first run the job order program, the Main Menu of the job ordering system will show before the user logs in.
•The next form is the login form that displays when the user clicks the log in the Menu on the menu area, here to log in a way where can type the username and password of the user to access the standard lists that are not visible when the user is not logged in.
•After successfully logging in, the basic and important Menu is displayed. And at the time that this basic Menu is displayed, it is now then ready to accept a command from the user. And the action can be performed based on the task that is given by the user.
•This following form shown below is the Customer form this window will display when the user click Customer under the Menu. This window where the user can search a specific customer by typing the customer name in the search textbox area provided or the user can easily click load all Button to load all the registered CustomerCustomer. This customer form also is enabled the user to create, update the user information.
•Next, the job ordering process starts because it registered the newly acquired Item for Repair. But first, to use this, we need to fill the customer information located on the right side of the form, and the customer information will be taken from the customer form by clicking the C-List Button. After we fill up the customer information, it is ready to be filled manually. The Qty, serial no., Description, Problem Action Taken, Remarks, and on the Technician In charge will come from the technician list, and the technician list will be available when T-list Button is clicked. And after writing all data needed the system has the capacity to add more items or list of items by clicking the Add this Item Button and finally when all the item endorsed the user can put a Job Estimation by parts, Labor, Pick-up and Delivery and the Total Amount are auto-generated and ready to end job order registering of item(s) by clicking Save and Preview button.
•then Job order generated when the user clicks the Save and preview Button in the Job Ordering form; this functionality enabled the user to preview the customer information and the item endorsed by the CustomerCustomer and print as a copy for customer copy and company copy. And this Report is also ready to be saved as a PDF file, Word document, and Excel format.
•The payment form this form will show if Receive payment Menu is clicked, and the main purpose of this form enables users to accept payment. From the CustomerCustomer, the process will be. First, the user will search the name of the CustomerCustomer, and if their many results, the user can select the exact data of the CustomerCustomer who wants to pay the job order. And after receiving the money from the CustomerCustomer the user will then input the receive payments to the receive payment textbox, and the program will then automatically compute if there’s a change or none after then the user can now click the Save Only Button if the CustomerCustomer don’t want the receipt. The payment of the CustomerCustomer will then be displayed at the right corner of the window in the Payment list.
•Then, it previews the output of receipt to be issued to the CustomerCustomer after receiving the amount, and when the user clicks the Save and Print Receipt, and the receipt contains the customer information and the description of paid items and the summary of amounts.
•The next window is Report here in the Report form all the transaction is visible. The user can select the Type of Report he/she wants to issue either by Showing all Job estimation the list of all job estimation, Showing the Payment List the list of all payments receive by the cashier, Showing Settled Job Order where all the list of all settled job order are available, Showing the Unsettled Job Order is the list of all Job order that need to settle in cashiering and Showing all Endorsed item where all list of all item that deposit in the company and the user can click the Show Button the functionality of Button is to show the filter items in the Datagrid. Another Report Filter is the filter by Customer Name, where the user can type the name of the CustomerCustomer provided in the Customer textbox.
•The window is the Report generated during the Preview Button is clicked under Report Type, and all the list of Job Estimation are shown. Same with the other Radio button is it will generate an almost similar preview of reports.
•The User Accounts Management where the Administrator can create, Delete, Or Update user account first in creating a user account the admin should fill the Name, Username, Password and Confirming the password and select the type of user that the admin desire and then the admin can click the Save button to Create the save User to the database finally, and then the admin also can delete the specific user by clicking the specific user in the list of user in the Datagrid and then click user automatically displayed the user information, and the admin can now click the Delete Button. The admin can also update the information about specific user accounts by simply clicking the specific user display in the data grid. Once it is already clicking, it will fill the user information. At that time, the admin can change the desired information of specific user information and finally click the Update Button.Download Here