I am trying to print a shipping list from lineitem file that has multiple line items for each invoice/order. I want only those items that are shipped to show up on shipping list. My portal shows all the items related to that order. Is it posible to use script to pick only the items from product code or item#s?

If your line items have data in them that indicates their shipment status (such as a shipping date for example), then you could either do a search for that set, or set up a relationship to view that set in a portal -- and trigger the printing script from there.

If you need to view line items that are more than just Shipped, (such as Shipped and Delivered) than simply add the additional search criteria to your search, OR (if using a relationship) create a complex key that shows the records you need.

Either way, the key to printing a list of Shipped line items is that the line items themselves (not the Sales Order/Invoice) are tagged as shipped (and therefore findable).

As a follow up to Sharka's post:

Normal Relationship is based upon InvoiceID (for example)

Shipping Relationship would be based upon InvoiceID & ShippingStatus. Setup a calculated field in the Invoice file as InvoiceID & "-Shipped"; Setup a calculated field in the LineItems file as InvoiceID & Status (or whatever your shipping flag is).

Then when you print your shipping label, you use this other relationship.