Скачать или смотреть Invoice Creation Automation | Microsoft Excel | VBA

We created this Microsoft Excel Utility for a Company engaged in Logistics Industry in India.

The Tools we Used in this Project
Microsoft Excel
Excel VBA

The problem faced by the Client:
Client was a Logistics Company having around 50 Trucks.
User used to do manual Invoicing to its Customers which lead to several errors in Invoices.
In case of error, the user had to reissue the correct invoice which delayed cash realization from the customer.
Further, in some cases, few consignments were not even invoiced which lead to revenue loss.

How we solved the problem:
We created an Excel utility using Excel VBA where the user could click on a button to Create Invoice Template.
Next user had to enter the consignment number and the utility will automatically fetch the details from the database and create the invoice.