I am designing a FlexiCapture template to extract Invoice number(header) and Line Item details.
I had to use Repeating Groups for the Line Item Details, as the Columns are very complicated.
When I extract the data, I need the Invoice Number to be Repeated for Each Line Item.
i.e
InvNum || Item 1 || Qty || Price
InvNum || Item 2 || Qty || Price
InvNum || Item 3 || Qty || Price
The invoice number in this case is from the header of the invoice.
So far I have created a nested Repeating Group for the Invoice Number and then the Invoice Line Items.
I am not sure how to combine them on the Blocks to be ONE Table
Comments
5 comments
I don't think this is possible without a forward fill function in your export db.
I haven't set up my RG's and Blocks like this though so I may be wrong, what is the table your posting to look like in the doc def?
Rhyno,
Is there a reason why you are not using FlexiCapture for Invoices where this is already pre-built out of the box?
Details about the product, which is add on to FlexiCapture 12, can be seen here:
https://www.abbyy.com/flexicapture-for-invoices/?_ga=2.57739048.382139350.1603738025-1216619259.1601504734
Dear Rhyno,
Please try to make a simple script rule in your DocumentDefinition. You can add an extra column InvoiceNo for your rep. group in document definition editor. And then select this field make a simple C# script:
1. in script properties please add both fields: InvoiceNo and InvNo.
2. try to use the next script:
Context.Field("InvoiceNo").Text = Context.Field("InvNo").Text
Hi Andrey
Thank you so much for the information! it worked really well. It was exactly what I needed.
Very nice to hear! Good luck with your investigation of FC and please feel free to contact!
Please sign in to leave a comment.