Community

Match Invoice data with database

Hi,

I have table in database with "ITEMID" AND "ITEMNUMBER". I want to match only "ITEMNUMBER" column of database with Itemnumber data on invoice image. For eg. iItem number "5386" is in the database and it also appears on invoice image, it should reflect on the form. How to capture it on form?

Was this article helpful?

0 out of 0 found this helpful

Comments

13 comments

  • Avatar
    Vladimir Dimitrijević

    Hi Sara,

    Fastest solution would be to create dataset called "Items" and populate it from the database. Create a script rule on that field and match it against the database. You can also use database rule, if you want user to choose correct value from database lookup.

    Best regards,
    Vladimir

    0
  • Avatar
    Sara

    Hi vladimir,

    I have created Dataset called "Items" as you said and have done mapping with fields. On "ITEMNUMBER" field  (which is blank obviously) i created database rule to match form field with database field "ItemNumber" with fuzzy lookup and no other setting.

    But it is not working, as one of the image has ITEMNUMBER value "5386" on it and that value is  also in database. So ITEMNUMBER should populate that value in the box directly as it is in database. But not working so. What more i have to do and also what is the script rule.

    I would appreciate you can give me in detail the steps to follow.

    0
  • Avatar
    Vladimir Dimitrijević

    Hello Sara,

    I don't know did I get it wrong first time. Do you want to find ItemNumber on image based on number from database? If in DB is 5386, you want to search for number 5386 on document?

    Best regards,
    Vladimir

    0
  • Avatar
    Sara

    Hi,

    Yes. I have dataset of ITEMNuMBER and want to match value from the document image. If document has value 5386 it should match within the database and display in the text box. What are the ways to do this?

    0
  • Avatar
    Vladimir Dimitrijević

    Hi,

    You will have to do the opposite, to find the field on the document and then to compare it against the database.

    Best regards,
    Vladimir

    0
  • Avatar
    Sara

    Hi Vladimir,

    How to find the field value on document. There are 100s of documents with ITMNUMBER on it. Can you please tell me how to find data on document. Isn't it possible just by attaching database table?

    0
  • Avatar
    Vladimir Dimitrijević

    Hi,

    The best practice is to use FlexiLayout and search for that field on the document. If you haven't worked with FlexiLayout, you can use tutorials:
    http://help.abbyy.com/en-us/flexicapture/12/flexilayout_studio/tutorial_all

    Best regards,
    Vladimir

    0
  • Avatar
    Sara

    Hi Vladimir,

    I have quite idea of searching field on the document in flexilayout. I observed there is also a DB connection string in Text field in flexilayout. 

    can we search the number on the document by specifying database connection string? Also can we write sql query in "Query Text" field? What is the use of DB string is flexilayout?

    Thanks for you response.

    0
  • Avatar
    Ekaterina

    Hello,

    If you have a value and want to know does it occur in the database, please use the database check rule in the document definition. If you need to find some text from the database you customize the static text element by “search text from database” option in the FLS.

    •Enter the data base connection string in the Connection string fields or click to open the standard database connection dialog box.

    •Type your query in the Query text field. You can also click to open a separate data entry window where you can type in your query.

    For more details see: Appendix > Dialog boxes > Element Properties dialog box > Static Text 

    0
  • Avatar
    Sara

    Thanks Ekaterina.

    Suppose i have a purchase order number database and when POs are loaded in flexicapture station, i want to populate directly if database value matches with that on PO no Invoice. Means can i directly get PO no populated from database if it finds on PO Invoice without using flexilayout?

     

    0
  • Avatar
    Ekaterina

    Hello,

    Do you use the general project or FCI (FC for Invoices)?

    If you extract PO numbers by using "Purchase order matching" option in the FCI, the PO number field fills directly from Data Set. You do not need to use the additional layout.

    0
  • Avatar
    Sara

    I am using FCI 12. I just have PO no in database table and no other column. If one of the value matches with that on the invoice i want it to be populated directly in the field box. How to do this?

    0
  • Avatar
    Ekaterina

    Hello,

    Do you know where is the region of the PO Number on the document? 

    Or it may vary in different documents and you look just for any number that can be found in the PO Number DB table to fill the PO Number field with it?

    Could you please send us your FC/FLS projects, sample images and some PO Numbers that are in your DB and that you expect to fill the PO Number field with on the provided sample documents?

    0

Please sign in to leave a comment.