Extract data from invoices and put together?

Hey guys, i’m trying to upload invoice data to a portal, which need regular data like PO#/invoice#/date/amount etc., but it also need to enter item details for each invoice. I’m wondering how you guys usually to put these info together so that I can go through each invoice, enter invoice#&date and then loop through each item within that invoice and enter quantity/price etc. Right now I extract these separately and put to 2 data tables but don’t know how to put together.

Based on your description, I assume that you have two Excel sheet tabs or two datatables. You have to link the two datatables using column “invoice no”. “Filter Data table” activity can be used filter line items which will be keyed into your web portal for a specific invoice no. Pleaes see the illustration picture below.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.