Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Internal Inventory Issues

(0) ShareShare
ReportReport
Posted on by 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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    soma 24,406 on at
    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!!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans