[bmj_23]

Given that scenario, my advice would be to generate customer bills per sell side shipment and then when you get the pre-invoice from the customer (how do you receive that - email ? Integration ?) generate a consolidated customer bill from the individual customer bills that represent the sell shipments on the pre-invoice from the customer.

That should allow you to compare the total consolidated bill amount in the OTM application to the amount on the pre-invoice from the customer. If the $$$ amounts match, you can then approve the bill and generate your outbound integration / reports to compare sell side revenue v buy side costs.

Let me know if that would work.