AI-Enabled FinTech B2B Invoice Management Application

Business Overview

In the B2B (Business-to-Business) world, businesses engage with other businesses on credit terms. When a buyer places an order with a seller, the seller issues an invoice containing details of the goods purchased and the payment terms. This is known as "Accounts Receivable" in accounting terminology.

The objective of the Tech Track project is to develop an AI-Enabled FinTech B2B Invoice Management Application using Java and React-Js. This application aims to streamline invoice management for businesses by providing features such as credit validation, order verification, inventory check, and predicting order amounts.

Problem Statement

The objective of the Web Application Development internship project is to build a Full-stack Invoice Management Application using React Js, JDBC, and Java Servlets. The application should include the following mandatory and optional features:

Mandatory Features

• UI Creation : Develop a user interface for the application.
• Grid Creation : Create a grid to display invoice data.
• Grid Data Loading : Load invoice data from a database into the grid.
• CRUD Operation : Enable add, edit, and delete operations on the grid.
• Pagination : Implement pagination functionality for the grid.
• Shortcut search button on Grid for Customer Order Id : Allow users to search invoices by customer order ID.
• Predict Button activation with Grid Data : Enable prediction of order amounts based on selected invoice data.
• View - Analytics : Provide analytics view with bar graph and pie chart.

Optional Features

• Advanced Search : Implement advanced search functionality.
• UI Enhancements : Add additional user interface enhancements for extra credit.

Application Overview

The application consists of the following major components:

Data Loading in DB

• Import the provided Invoices database into MySQL.
• Use the provided SQL file for the order amount prediction dataset.
• UI Representation of the data.
• Build a responsive user interface to display the loaded invoice data.
• Implement search and pagination features.
• Enable editing of selected fields, adding new rows, and deleting rows from the grid.
• AI Support in the application.
• Integrate AI capabilities to predict the order amount for one or more invoices.

Milestones

Milestone 1 - Using Collections Framework for Read Write Operations

• Create a Java project named h2h_milestone_1.
• Create the following packages:
  • com.highradius.connection
  • com.highradius.implementation
  • com.highradius.model
  • com.highradius.servlets
• Implement the Invoice class in the com.highradius.model package with a parameterized constructor and getter/setter methods.
• Create the DatabaseConnection class in the com.highradius.connection package with methods for getting and adding invoices.
• Implement the InvoiceDao interface and the InvoiceDaoImpl class in the com.highradius.implementation package.
• Create the AddServlet and DataLoadingServlet classes in the com.highradius.servlets package to handle API calls for adding and retrieving invoice data.

Milestone 2 - Connecting Database using JDBC

• Import the provided SQL database into MySQL.
• Create a Java project to fetch data from the database using JDBC.
• Use the provided JDBC jar for MySQL connection.

Milestone 3 - API call using Servlets

• Create different servlets for different functionalities such as read, add, edit, and delete.
• Implement API calls for loading data into the grid and adding data.

Milestone 4 - Create Table using HTML and CSS

• Create an HTML table with static data.
• Apply CSS styles to the table for a visually appealing appearance.

Milestone 5 - Create data grid using React JS Components

• Use React JS class or functional components to create a table with static data.

Milestone 6 - Creation of Grid using Material UI

• Implement a data grid using Material UI components.

Conclusion

The AI-Enabled FinTech B2B Invoice Management Application aims to simplify and streamline the process of managing invoices in a B2B environment. By providing features such as grid display, CRUD operations, pagination, search functionality, and AI-based prediction, the application empowers businesses to effectively manage their invoices and make informed decisions.

By following the milestones and utilizing the provided technologies (Java, React JS, JDBC, Java Servlets), you can build a robust and user-friendly invoice management system. Feel free to customize and enhance the application further based on your specific requirements and preferences.