How get fetch data from Tablefields by using custom invoice models in form Recognizer

Suhail Nizami 0 Reputation points
2023-05-24T10:26:42.9033333+00:00

Hi all!

I have build a custom model in form recognizer to fetch data from invoice documents. It is successfully fetching data from normal fields but not fetching data from Tablefields. I have tried multiple ways but could not fetch data from tablefields.
output is :
'Company Name': 'All e Technologies (P) Ltd.'.

'Company Address': 'State : Uttar Pradesh State Code : 09'.

'Invoice number': 'SINVPUP2122/293'.

'Invoice Date': '06/10/2021'.

'Customer Reference': 'AZURE_SEPT'2021'.

'Customer Table': ''.

'Items': ''.

'Payment Details': ''.

and here Customer Table, Items, Payment Details are defined as tablefields and inside it there are data in rows & columns format.
Also fetched data like this:
Lines found on page 1
  All e Technologies (P) Ltd.
  A-1, Sector -58, Noida, , 201301, INDIA
  Phone : +91 120 3 000 300 Fax No. : +91 120 2588 660
  finance@alletec.com
  GSTIN :09AACCA7848R1ZT
  State : Uttar Pradesh State Code : 09
  PAN : AACCA7848R LUT No : AD0903210195962
  MSME Reg. No. : DL04E0009150
  Tax Invoice
  Bill To Customer
  Name
  NIIT UNIVERSITY
  Address
  NH-8, Delhi-Jaipur Highway
  Neemarana, Alwar
  Alwar 301705 Rajasthan
  Rajasthan
  08
  State
  State Code
  GST No.
  08AAATN7347M1Z1
  Contact
  Hemender Singh Shekhawat
  Invoice No.
  SINVUP2122/530
  Date
  05/01/2022
  Cust.Ref.
  NU/21-22/WO-00037
  Dated
  29/05/2021
  S.No.
  Description
  HSN/SAC
  Quantity
  Unit of Measure
  Rate
  INR
  Total Price
  INR
  1
  NAV AMC October 2021 to December 2021
  998313
  8
  Man Day
  9,000.00
  72,000.00
  Payment Details
  Sub Total
  72,000.00
  CGST
  0 %
  0.00
  Payment Term:30 Days from Inv date
  SGST
  0 %
  0.00
  Payment Method: Wire
  IGST
  18 %
  12,960.00
  Amount In Words
  TOTAL
  84,960.00
  ****
  EIGHTY FOUR THOUSAND NINE HUNDRED SIXTY RUPEES AND ZERO PAISA ONLY
  All e Technologies (P) Ltd.
  Axis Bank Limited-CA-911020022894271
  D-70A, East of Kailash, New Delhi 110 065
  Account No. : 911020022894271
  For All e Technologies (P) Ltd.
  IFSC Code : UTIB0000593
  Authorized Signatory
  Certified that the particulars given above are true and correct.
  Note : Should you have any queries or dispute on the invoice, please send the details within 7 days of receipt of Invoice otherwise we consider it as accepted.
  Registered Office : UU-14, Vishakha Enclave, Pitam Pura, DELHI, 110 034, INDIA, CIN : U72200DL2000PTC106331
  alletechnologies
Selection marks found on page 1
Table 1
  Cell[0][0] has content 'Invoice No.' with kind 'content'
  Cell[0][1] has content 'SINVUP2122/530' with kind 'content'
  Cell[1][0] has content 'Date' with kind 'content'
  Cell[1][1] has content '05/01/2022' with kind 'content'
  Cell[2][0] has content 'Cust.Ref.' with kind 'content'
  Cell[2][1] has content 'NU/21-22/WO-00037' with kind 'content'
  Cell[3][0] has content 'Dated' with kind 'content'
  Cell[3][1] has content '29/05/2021' with kind 'content'
Table 2
  Cell[0][0] has content 'S.No. Description' with kind 'columnHeader'
  Cell[0][1] has content 'HSN/SAC' with kind 'columnHeader'
  Cell[0][2] has content 'Quantity' with kind 'columnHeader'
  Cell[0][3] has content 'Unit of Measure' with kind 'columnHeader'
  Cell[0][4] has content 'Rate INR' with kind 'columnHeader'
  Cell[0][5] has content 'Total Price INR' with kind 'columnHeader'
  Cell[1][0] has content '1 NAV AMC October 2021 to December 2021' with kind 'content'
  Cell[1][1] has content '998313' with kind 'content'
  Cell[1][2] has content '8' with kind 'content'
  Cell[1][3] has content 'Man Day' with kind 'content'
  Cell[1][4] has content '9,000.00' with kind 'content'
  Cell[1][5] has content '72,000.00' with kind 'content'
  Cell[2][0] has content 'Payment Details' with kind 'content'
  Cell[2][1] has content '' with kind 'content'
  Cell[2][2] has content '' with kind 'content'
  Cell[2][3] has content 'Sub Total' with kind 'content'
  Cell[2][4] has content '' with kind 'content'
  Cell[2][5] has content '72,000.00' with kind 'content'
  Cell[3][0] has content '' with kind 'content'
  Cell[3][1] has content '' with kind 'content'
  Cell[3][2] has content '' with kind 'content'
  Cell[3][3] has content 'CGST' with kind 'content'
  Cell[3][4] has content '0 %' with kind 'content'
  Cell[3][5] has content '0.00' with kind 'content'
  Cell[4][0] has content 'Payment Term:30 Days from Inv date' with kind 'content'
  Cell[4][1] has content '' with kind 'content'
  Cell[4][2] has content '' with kind 'content'
  Cell[4][3] has content 'SGST' with kind 'content'
  Cell[4][4] has content '0 %' with kind 'content'
  Cell[4][5] has content '0.00' with kind 'content'
  Cell[5][0] has content 'Payment Method: Wire' with kind 'content'
  Cell[5][1] has content '' with kind 'content'
  Cell[5][2] has content '' with kind 'content'
  Cell[5][3] has content 'IGST' with kind 'content'
  Cell[5][4] has content '18 %' with kind 'content'
  Cell[5][5] has content '12,960.00' with kind 'content'
  Cell[6][0] has content 'Amount In Words' with kind 'content'
  Cell[6][1] has content '' with kind 'content'
  Cell[6][2] has content '' with kind 'content'
  Cell[6][3] has content 'TOTAL' with kind 'content'
  Cell[6][4] has content '' with kind 'content'
  Cell[6][5] has content '84,960.00' with kind 'content'
  Cell[7][0] has content '**** EIGHTY FOUR THOUSAND NINE HUNDRED SIXTY RUPEES AND ZERO PAISA ONLY' with kind 'content'
  Cell[7][4] has content '' with kind 'content'
  Cell[7][5] has content '' with kind 'content'
  Cell[8][0] has content 'All e Technologies (P) Ltd. Axis Bank Limited-CA-911020022894271 D-70A, East of Kailash, New Delhi 110 065 Account No. : 911020022894271' with kind 'content'
  Cell[8][1] has content '' with kind 'content'
  Cell[8][2] has content '' with kind 'content'
  Cell[8][3] has content '' with kind 'content'
  Cell[8][4] has content 'For All e' with kind 'content'
  Cell[8][5] has content 'Technologies (P) Ltd.' with kind 'content'
  Cell[9][0] has content 'IFSC Code : UTIB0000593' with kind 'content'
  Cell[9][1] has content '' with kind 'content'
  Cell[9][2] has content '' with kind 'content'
  Cell[9][3] has content '' with kind 'content'
  Cell[9][4] has content 'Authorized Signatory' with kind 'content'
  Cell[10][0] has content 'Certified that the particulars given above are true and correct.' with kind 'content'
  Cell[10][2] has content '' with kind 'content'
  Cell[10][3] has content '' with kind 'content'
  Cell[10][4] has content '' with kind 'content'

Now please help me to fetch data from tablefields in proper way...

I shall be thankful to you...

Azure AI Document Intelligence
Azure AI Document Intelligence
An Azure service that turns documents into usable data. Previously known as Azure Form Recognizer.
1,388 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Suhail Nizami 0 Reputation points
    2023-06-06T09:28:44.5966667+00:00

    2023-05-17

    Dear Vasavi Lankipalle!

    Thank you for your message regarding the issue I am facing. I appreciate your willingness to assist.

    The issue I am experiencing is with Azure form recognizer API. The specific error message I am receiving is that I have built a custom model in form recognizer to fetch data from invoice documents. It is successfully fetching data from normal fields but not fetching data from Table fields.

    I have tried multiple ways but could not fetch data from table fields.. However, the issue still persists.

    I am attaching relevant documents that could help you to understand this issue.

    output is :
    'Company Name': 'All e Technologies (P) Ltd.'.

    'Company Address': 'State : Uttar Pradesh State Code : 09'.

    'Invoice number': 'SINVPUP2122/293'.

    'Invoice Date': '06/10/2021'.

    'Customer Reference': 'AZURE_SEPT'2021'.

    'Customer Table': ''.

    'Items': ''.

    'Payment Details': ''.

    0 comments No comments