concurrent line item help
I want to be able to display a sum of the product quantity on line items all of the line items with the same Inventory ID number that are other invoices that have overlapping start and end dates(my line items are rentals so invoices have a start and end date). I created table called Line Items_All and related Line Item::inventory ID=Line Item_All::inventory ID. In a portal of displaying line items:ALL on a layout displaying line items, This limits portal records to every time this item was on an invoice.
If i filter the portal with [ items will be visible when:
Line Items_All::ID ≠ Line Items::ID and
Line Item_ALL_invoice::Start Date ≤ invoice::End Date and