Jeff,

Each of the ten items have key elements I need to report on and the contract only has one receivable item. Let me try to paint a clearer picture:

A Contract is made for 10 items. These 10 items might be fulfilled from different locations; either from 10 locations or maybe 1, it depends on the stock of each location. The sale of these items add up to a lump amount that is entered into a one invoice (receivable item). The business needs to know the A/R running balance of that contract with detailed information as to from where the item or items were fulfilled from so the corresponding inter-companies JEs are created for each of those fulfillment locations.

I know, it is very convoluted but this is the way the existing contract application (and its DB) is designed.

Thoughts?