How to issue office supplies inventory in NetSuite
For some reason I can’t figure out how to issue inventory such as office supplies using inventory module.
Like, warehouse and issue it to accounting or admin, etc
Should be entry is debit Office supplies exp / credit Inventory
There is a transaction called Inventory Adjustment, but why use just one inventory account? I have different expense accounts for inventory items.
You don’t want to use accounts for this… what kind of transaction are you using to consume these office supplies? Are they set up as inventory or non-inventory items? You might try classes or departments to segment things. I guess you could use a sales order for the internal department to ‘purchase’ the supplies, and just have a customer record for each department.
Why not accounts? Supposedly it’s a very basic type of transaction. A department requesting office supplies from the warehouse or even admin, and so the inventory custodian should be able to withdraw the said inventory from the stock balance through a simple type of system transaction. Without really identifying the accounts to use, just the inventory item because inventory custodians does not know anything about which account to use. Supposedly it’s just, identifying which department, what item, and how many. Then click save or submit to automatically remove the the items from inventory from balance sheet and record the same as expense in income statement.
It’s so weird that NetSuite does not saw this thing happening. All you can see in inventory module is a bunch of inventory transfers, location to location, no way withdrawal like consume to expense the inventory.
An item only has a single account for each purpose, if you want to track the warehouse vs sales using item X, you would probably want a different solution. I don’t know of anything built into NS for the purpose you describe. You could probably get there somewhat using fake customers & fulfillments.
Thanks for the work around process. I might be able to implement such process.
However, I still think it’s a simple transaction that lacks in this ERP. It is very common and necessary for different department to request office supplies such as bond papers from inventory custodians and that there should be a corresponding transaction to withdraw the items. And the fact that supplies inventory could have different accounts based on its classification makes it impossible to be transacted in NetSuite which only ask for one adjustment account–which it should not be asking at all because items do have its own embedded and respective expense accounts.