Invoice processing

[Rajarshi_Basu]

While trying to extract from a pdf Invoice having a list of unique items for eg:

Order Date Items Price Nos Total
01.01.2022 Apple $5 2 $10
02.02.2022 Guava $2 4 $8
Total $18

How to create the column expression for this type of invoices from where I will have a record of all the items I have purchased date wise and the total cost for a month .
My date expression of invoice is showing as 01-Jan-2022 but I want to enter my dates as 01.01.2022 in my app to train my app. How to do this?? I reside in India.

[Suvrutt_Gurjar]

Rajarshi_Basu:

How to create the column expression for this type of invoices from where I will have a record of all the items I have purchased date wise and the total cost for a month .

You may wish to take a look at the following sample app’s reports that have a similar report structure.

AppSheet

AppSheet : mobile apps from spreadsheets : Template: Other for the industry

This app can be used to manage customers, products, and orders. The app user can: - Create and edit a customer list. - Create and edit a product list. - Create orders associated with a customer. Orders can have three statuses: Open, Complete,...

Rajarshi_Basu:

My date expression of invoice is showing as 01-Jan-2022 but I want to enter my dates as 01.01.2022 in my app to train my app

Not sure what you mean by “train”. You could try TEXT() functions to change the date formats.

help.appsheet.com

TEXT()

Format as text

[Rajarshi_Basu]

How to do Invoice processing using OCR model from a Invoice in pdf format.

[Suvrutt_Gurjar]

Sorry. If you are referring OCR, someone else may have inputs for you. OCR is currently in Beta as per my understanding.