In the starter solution the list of items purchased are in a different table: Invoice Data. You would need to import the data on items purchased into that table along with the correct matching value into the INVOICE ID MATCH FIELD.
I found that table but I cnanot seem to select as the target, any sugestions?
Select a layout based on Invoice Data, not invoices. If one does not exist in your file, create a new layout that is based on it.
the current target table is shown as "invoices" below, greyed out are "related tables" and one of them "invoice data" table is there but I am not able to selec it as the new target
Also wondering if you, or anyone know whether or not I would want to import invoice data from the old solution from a source called "INTERFACE_Pipeline_Products" this seems like the right plave
To repeat, you must import records into Invoice Data by first selecting an layout that is based on Invoice Data instead of Invoices. If you do not already have such a layout, do the following:
Enter layout mode.
Select New Layout from the Layouts menu.
Select Invoice Data in the Show Records From Drop down.
Select the Blank layout option.
Return to Browse mode and now try importing data into the Invoice Data table. You can use Table View with your blank layout to view the results of your import to make sure that it worked correctly.