Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

Inventory Shrinkage and QuickBooks

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

What is the best way to handle inventory shrinkage (stolen, damaged) in RMS?  We are using QuickBooks for our accounting and it looks like the only way to have it post to QB would be to sell the item at zero.

*This post is locked for comments

  • Kevin Antosh Profile Picture
    Kevin Antosh 1,645 on at
    RE: Inventory Shrinkage and QuickBooks

    Hi!  Have you tested using the "transfer out" function in RMS and/or setting up a supplier/vendor as "shrinkage" (and using a negative  quantity PO)?  I can't speak as to how that would transfer to QuickBooks but is something that other retailers using RMS are doing. RMS End of Life is July 2021 - State of Microsoft RMS: www.youtube.com/watch

  • Suggested answer
    LogisticsGuru Profile Picture
    LogisticsGuru 5 on at
    RE: Inventory Shrinkage and QuickBooks

    Take a look at our blog post about the various methods to reduce inventory shrinkage.

    blog.logisticsforhire.com/how-to-reduce-inventory-shrinkage

    If you need any further help, we will be more than happy to assist you!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Shrinkage and QuickBooks

    I assume these are items that were broken at the store.  Not returned by a customer broken.   If that is the case then, selling at zero is the only way to have it post through the RMS to Quickbooks integration.  

    You could make a manually entry into quickbooks for any damaged or broken goods,  and then just adjust the inventory in RMS.

    There are other methods if goods are received from the supplier broken or if a customer is returning the item.

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,431 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans