In the AR_InvoiceHistoryDetail table there is a field: ExplodedKitItem  If the value is "C" then it was a component on a kit and you would use the quantity field to get what you need. Link Header and Detail and you should be able to get the data you need.

Exactly, but that only works if the kit was exploded (not pre-assembled). 

If the items were lot/serial you could probably link to Production history to pull the components used, but otherwise I don't believe there is a way to absolutely know what components were used to build a finished good that was sold on a specific invoice.

Thank you!

Thank you!

AR_InvoiceHistoryDetail also has a Revision field that you could link to BM_BillHeader with. The Revision stored in AR_InvoiceHistoryDetail will be what ever the current revision of the bill was when entered on the invoice. 

If you are using change control, then the ship date of the sales order could be used to determine which components would have been used to produce the bill. AR_InvoiceHistoryHeader as the ShipDate field and BM_BillDetail has the following fields related to change control.

1. EngineeringChangeAddNo
2. EngineeringChangeAddDate
3. EngineeringChangeDelNo
4. EngineeringChangeDelDate