Hi All
Am sure there must be a simple solution within GP functionality but have been looking for ages and cannot find an easy solution. Many businesses consume inventory internally - cleaning materials issued to departments, spare parts to repair machinery, giveaways at a Trade Show.
I know that we can do a negative adjustment to inventory and charge a GL account directly but there is no accountability. We would like the end-user department to be able to requisition an inventory item, have stores generate a pick list, a transfer form and then have the user department 'receive' or approve the charge.
I would really appreciate any ideas on this, ISV Solutions included.
Thanks in advance.
Leicester
*This post is locked for comments
Really appreciate you taking the time to respond to my post. This is the best way that I can think of also but hoped there was functionality that I had missed or an ISV solutions somewhere out there.
I am thinking of taking this one step further with a customization and would appreciate your thoughts. In the SOP setup we can select whether SOP should take the 'Posting Accounts' from the Item or the Customer. This is a global setting but recall an ISV solution ages ago that allowed this option to be set for each Customer. This would then relieve the folks processing the transactions from having to know the accounting codes and then entering for each line item.
Think this would work?
Take care
Leicester
You could use a Sales Order/Invoice for this. 'Sell' the items for $0.00 to an internal customer. You can use the pick list, packing slip, and/or invoice as authorization/documentation. The Sales Order would provide your audit trail. Change the COGS account in the invoice to the expense account for the receiving department.
Hi Soma
Thanks for your response. If I understand your suggestion we should create a new inventory site for each cost centre and then transfer inventory to that site. But then will the Inventory Module still show the items in stock? How do you recommend that we get them out and to the expense/asset accounts?
And what if we have 40 or more account/department/location combinations? Do we setup an inventory Site for each or would one site suffice?
Appreciate your input.
Best regards
Leicester
If my understanding is correct, then you can accomplish this by creating a dump inventory site(Cleaning Up Inventory Warehouse) and the use the Inventory Transfer to move the inventory items to newly created Cleaning up warehouse/site.
Hope this helps!!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156