How can I extract data from different vender invoices

Help Studio
1

Hello,

I have different vender invoices.

  1. I extract data like Invoice No., PO No., Invoice Date, Invoice Amount etc. and update into the application.

  2. In the application there are two line item and updating base on given PDFs:

image
image692×109 20.6 KB

**Table **

  • In 1st PDF they are consider Line Total and Freight value .
  • In 2nd PDF they are consider Subtotal and shipping charges value.
  • In 3rd PDF they are consider Total items and sales tax value.

image
1st PDF

image
2nd PDF

image

                                       **3rd PDF**

How can I extract data from different vender invoices?

Thanks
Minal Patl

2

@minal.patil

Hi
Have you already extract data from one invoice ?

You can use regex to extract the data from invoices, but keep in mind to use only for structured invoices in digital format and the maintainability increase as the number of layouts grows

If you can provide the 3 invoices with dummy data, I can give to you an example

Also you can check out UiPath Document Understanding

3

Yes I have already extract one invoice using regex.

I have attached dummy invoices.

Artist-invoice-template.pdf (420.7 KB)
Lawn Care Invoice Template - Jotform PDF Editor.pdf (110.5 KB)
wordpress-pdf-invoice-plugin-sample.pdf (23.3 KB)

same extraction:

  1. Extract data Invoice No., PO No., Invoice Date, Invoice Amount.

  2. In the application there are two line item and updating base on given PDFs:

  • In 1st PDF they are consider Line Total and Freight value .
  • In 2nd PDF they are consider Subtotal and shipping charges value.
  • In 3rd PDF they are consider Total items and sales tax value.

Can you help me how to extract different vender invoices. Because there number of vender invoices its not fix client send only 3 invoices.

Thanks
Minal P