Skip to main content
Post a question

Notifications

Community site session details

Community site session details

Session Id : Ubxrgnok6okTfhgcoA54xU
Microsoft Dynamics RMS (Archived)

Inventory Shrinkage and QuickBooks

Like (0) ShareShare
ReportReport
Posted on 27 Jan 2015 12:56:04 by

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
    1,649 on 09 Feb 2020 at 19:08:39
    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
    5 on 07 Feb 2020 at 18:03:42
    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
    Goloknath Profile Picture
    on 20 May 2015 at 13:15:09
    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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,485 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,594 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading complete