Sale on Consignment - Any Standard Solution ?

Dear All,

Some of our sales happen through consignees wherein we transfer goods to Consignee multiple times during a month. The ownership of the goods are with us only. At the end of the month, the consignee provides us the details of the actual sales made by it along with customer details. Post that, we generate invoices to actual customer.

Could you please help us to find a better standard solution for mapping these transactions in Oracle. One possible solution is Create a New subinventory for each consignee, transfer the goods to this subinventory as per the physical movement and the process logical shipments to actual customers on the basis of the details submitted by consignee.