Internal Inventory Issues

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

soma 24,410 on at

Like (0)

Report

RE: Internal Inventory Issues

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!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Internal Inventory Issues

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

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: Internal Inventory Issues

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Internal Inventory Issues

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

Was this reply helpful? Yes No