Our NetSuite was originally set up to track items that we buy a license for each item. NetSuite tracks how many we purchased, how many we have used, and when we need to re-order.
We have recently started to allow users to buy in bulk. But this creates issues in our license tracking.
1) The item fees are considered deferred revenue until they are used. ie a customer buys 10,000 in bulk, but only uses 1,000 a month. We can count 1,000 a month as revenue.
2) We don't want to take the licenses out of inventory until they are used.
3) We need an item to enter the bulk purchase.
Anyone have any best practices? We think we need to create 3 items, but aren't sure how to track them all and accurately show them on invoices. We need an item for the original bulk purchase, an item to show how many of been used each month, and an item to show how many are left.
The item showing how many have been used should take that number out of inventory and convert it to revenue.
Has anyone else dealt with bulk purchases of inventory items? Any tips or ideas?