I have tried building relationship between products and invoices and line items, so that when you are in the detail view of a product you can see all the invoices that have that product in it. The subpanels always appear for quotes, purchases and invoices but the data never populates. Im not sure what i am doing wrong.
A product is not directly related to an invoice or quote or contract.
It is related via the line item(aos_products_quotes) table.
Thanks,
Will.
Ok so if I then want to achieve the above mentioned i would just create the relationship Products > many to many > Line items?
Or how would this be done?
Hello. Just a followup questions, to how would i setup the relationship so that i can see through the product module invoices related to specific products? Example i go to Product XYZ and within the subpanel there are invoices 1,5,7 in which this product was purchased?
Thanks