Internal Inventory Issues

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (4)

Answers (0)

Community Member Microsoft Employee 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
Frank Hamelly | MVP... 4,029 Super User 2024 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.
Community Member Microsoft Employee 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
soma 24,406 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!!!