We are struggling with how to manage customer-owned inventory on several of the eStores we run for our customers. If anyone deals with customer-owned inventory or consignment selling, and is willing to share their practices and procedures, it would be most appreciated.
Specifically, how we would like the flow to go, using a hypothetical Item A, is that we purchase a quantity of Item A for the Customer's eStore and sell it to the top-level customer, recognizing the revenue. That part's fine, but then we don't actually ship out the stock of Item A to the top-level customer. Instead, we hold the stock and when either the customer's employees redeem their budgets on the customer's estore, or they pay by credit card on the estore, we ship the stock to the end user. If the estore sale was by credit card, we collect the revenue and remit it back to the top-level customer, less a percentage for us, much like in a consignment sale.
What we want to achieve is:
1) Recognize the revenue when the item is sold to the top-level customer
2) Keep track of the stock on hand after the item is sold to the top-level customer, until it is shipped to the estore customer.
3) Keep track of revenue collected for the item on the eStore that needs to be remitted to the top-level customer.
4) Not have the item show on our books as a net asset (since it's not) after it has been sold to the top-level customer until it actually leaves our facility.
Any guidance, pointers, best practices, how others do it, etc., is much appreciated, as we are really struggling with how to achieve this in NetSuite.