• Skip to main content
  • Skip to header right navigation
  • Skip to site footer
  • X
  • Facebook
  • YouTube
  • LinkedIn
Support
Screen Connect
Pay Online
SWK logo.

SWK Technologies

Software Solutions & Services

  • Accounting & ERP Software
      • Acumatica Cloud ERP
        • Overview
        • Construction
        • Distribution
        • Field Service
        • Financial Management
        • Manufacturing
        • Professional Services
        • Project Accounting
        • Retail-Commerce
      • Sage Intacct
        • Overview
        • Construction and Real Estate (CRE)
        • Distribution Operations for Sage Intacct
        • Financial Services
        • Healthcare
        • Manufacturing Operations for Sage Intacct
        • Nonprofits
        • Professional Services
        • Sage Intacct Payroll powered by ADP
      • Sage 100
        • Overview
        • Business Intelligence
        • Core Accounting & Financials
        • Distribution
        • Manufacturing
        • Payroll
        • Sage 100 Contractor
      • More Accounting Products
        • QuickBooks
        • Sage 50
        • Sage 300
        • Sage 500
        • Sage BusinessWorks
      • ERP Add-ons
        • ADP Workforce Now
        • Altec
        • Avalara
        • AvidXchange
        • BigCommerce
        • CIMCloud
        • Cloud Hosting
        • DataSelf
        • Fortis
        • FreightPOP
        • Microsoft 365
        • Netstock
        • Ottimate
        • Sage Fixed Assets
        • Sage HRMS
        • Sage Intacct Payroll powered by ADP
        • Savant WMS
        • Scanco
        • ScanForce
        • Solver
        • SPS Commerce
        • Velixo
        • Workforce Go!
      • More ERP Add-ons
        • Bizinsight
        • Concur
        • Crystal Reports
        • Fraxion
        • Fusion RMS
        • FYISoft
        • JobOps
        • KnowledgeSync
        • Lockstep Collect
        • Nectari
        • Pacejet
        • Planning Maestro
        • Sage CRM
        • Sage Intelligence
        • Scissortail HCM
        • Service Pro
        • ShipStation
        • Shopify
        • Starship
        • Sugar CRM
        • Time & Billing Pro
        • Timekeeper
        • True Sky
      • Industries
        • Construction
        • Distribution
        • Financial Services
        • Healthcare
        • Manufacturing
        • Nonprofit
        • Professional Services
        • Retail
  • Managed Cloud Services
      • Managed Services
        • IT Support
        • Cloud Hosting
        • Infrastructure-as-a-Service
        • Managed Cloud Services
        • vCIO
        • Acumatica Infrastructure
      • IT Solutions
        • Backup & Continuity
        • Cybersecurity
        • Email Hosting
        • Microsoft 365 Services
        • Virtualization
  • Consulting & Implementation
    • Business Technology Consulting
    • eCommerce
    • Financing
    • Human Capital Management
    • Managed Cloud & IT Services
    • Partner Program
    • Software Development
    • Software Implementation
  • Resources
    • Help Desk
    • Blog Posts
    • Payments Portal
    • Webinars
    • YouTube Channels
    • Acumatica Resources
    • Sage Intacct Resources
    • Sage 100 Resources
    • IT Resource Pages
  • About
    • About SWK
    • Awards & Recognition
    • Life@SWK
    • Careers
    • Success Stories
    • SWK Gives
  • Contact
    • Contact Us
    • Support
    • Our Locations

How to Run Inventory Turnover and Dead Stock Queries in Acumatica [On-Demand Webinar]

July 10, 2023 by Kaylee Franzen

Home » Acumatica » How to Run Inventory Turnover and Dead Stock Queries in Acumatica [On-Demand Webinar]

Optimize Your Inventory and Keep Stock Moving with New Dead Stock and Inventory Turnover Queries – Available Out of the Box

Sometimes, inventory simply does not move as fast as it should. We all know that dead stock or slow-moving inventory drains your revenues by taking up warehouse space as it becomes less and less desirable for buyers. However, it used to be difficult for many business leaders to gain clear insight into their inventory turnover rates. Until now.

Access this webinar and discover how using new inventory features in Acumatica can help you gain effortless, in-depth insight into your inventory status, so you can manage proactively to improve your margins. Watch the webinar now.

Skip to the Sections that Matter to You!

In this Acumatica Community webinar featuring SWK, you will receive a clear walkthrough of how to use new inventory inquiries in Acumatica. You will also learn how savvy business leaders are leveraging this new inventory data to improve revenues.

Looking for specific information? Use this summary to skip forward to the parts that interest you. (Timestamp information is located to the right of each item. Please select that time when you are watching the video.)

Inventory Turnover Queries

Ready to manage inventory turnover with style? Acumatica empowers you to filter by specific items, classes, warehouses, dates, and more, so you get the information you need efficiently. In this section, our SWK expert explains in depth how you can find, access, filter, and understand the results of your Inventory Turnover queries.

  • Watch the Inventory Turnovers section end-to-end (2:27)
  • What is the Inventory Turnover query? (3:12)
  • Tip: How this query differs from a standard Generic Inquiry (3:20)
  • Why use this query? (3:57)
  • How to understand the screen and your options (4:18)
  • Tip: Other names for Inventory Turnover and other ways to use this data (4:49)
  • Applicable scenarios for use (5:11)
  • Full walkthrough of the query (5:31)
  • Tip: Important features to note (5:40)
  • How to use the Manage Turnover History tab (10:03)

Dead Stock Queries

Acumatica enables you to view the stock that is not moving out of your warehouses, and change your view by days in stock or starting on a certain date. In this section, SWK explains how you can confidently and quickly filter your stock data, so you can make smart, timely inventory decisions.

  • Watch the Dead Stock section end-to-end (15:50)
  • Why track this data? (16:32)
  • What are the causes behind stock that is dead? (17:25)
  • Full walkthrough of the query (18:53)
  • Tip: How this query differs from a Generic Inquiry (20:09)
  • Ways to handle your stock once it is officially dead (22:36)
  • How to use these inquiries to leverage your inventory data (26:12)

Q&A

Question and answer sessions occurred after each section of this Acumatica Community webinar, and some participants asked questions during the final section. We have collected all the Q&A here in one place to make it easy for you to find the information you need.

  • Which version is the Inventory Turnover query in and how can you enable this function? (12:49)
  • Can Turnover data be brought into other Generic Inquiries? (13:18)
  • Can you create sub-lists for multiple inventory items across item classes? (13:50)
  • Do these take manufacturing or transfer consumption into account? (14:25)
  • What are the configuration column options for Inventory Transfer? (15:02)
  • Is this only for Finished Goods? (15:22)
  • Can you use data from Inventory Turnover to inform replenishment settings? (25:01)
  • Can you make a comparative period analysis for Dead Stock? (24:22)
  • Can you make a comparative period analysis for Inventory Turnover? (25:40)
  • Is average unit in days? (25:53)
  • Do these take expiration dates into account? (27:33)
  • Can you add Lot Numbers to these queries? (27:55)
  • Can Dead Stock note items for BoM, or is it just invoice sales? (28:14)
  • Can you run Turnover by sub-accounts? (28:47)
  • Can an item be set to “dead”? (28:56)
  • Can you import items as “dead”? (29:32)
  • Is Turnover available out of the box? (29:58)
  • Are these available in older Acumatica builds? (30:18)

Extend Your Learning

This quick Acumatica Community overview on how you can use new Acumatica tools to get more done, faster, with your inventory and dead stock data was only one of the many free webinars made possible by SWK Technologies. We are here to help you do more with your technology.

If you liked this video and you want to watch in-depth webinars that will empower you to make confident decisions about your business, please check out our upcoming events and webinars.

In the meantime, please bookmark this webinar link so you can return to the information whenever you need it.

Watch the webinar “Inventory Optimization with Acumatica Inquiries”

Talk to the Experts at SWK to Learn More

Anytime you have questions about your business technology options, all you have to do is reach out to our team of seasoned experts here at SWK Technologies. Contact SWK today.

Category: Acumatica, Blog, Distribution, ERP, Webinars

Sidebar

Recent Posts

  • What is the Relationship Between Cybersecurity and Cyber Insurance? 
  • Guide for Sage Intacct Credit Card Management
  • Minimize Tariff Impacts on Your Technology Costs in the Cloud
  • How Sage Intacct Add-Ons Unify Your Construction Accounting Software
  • SWK CIO Named Global InfoSec Awards Winner during RSA Conference 2025
  • How a Leading Foam Manufacturer Streamlined Innovation with SWK Technologies
  • Workforce Go HR & Payroll Integration Available for Sage 100

Categories

Ready to take the next step?

Contact SWK today to get in touch with one of our experts. We’ll go over your business challenges and unique needs, and see where you can unlock new value from your technology and make your operations run easier.

Get in touch!

Our Latest Posts

Cyber Insurance

What is the Relationship Between Cybersecurity and Cyber Insurance? 

Read moreWhat is the Relationship Between Cybersecurity and Cyber Insurance? 
A blue and purple gradient Visa credit card resting on a laptop keyboard, representing the digital management of corporate credit cards discussed in this guide to Sage Intacct's credit card functionality.

Guide for Sage Intacct Credit Card Management

Read moreGuide for Sage Intacct Credit Card Management
Wooden letter tiles spelling "TARIFFS" in the foreground with "CHINA" and "USA" visible in the background, illustrating trade tensions affecting technology hardware costs.

Minimize Tariff Impacts on Your Technology Costs in the Cloud

Read moreMinimize Tariff Impacts on Your Technology Costs in the Cloud

Awards and Accreditations

Top work places in NJ 2020.
Acumatica the Cloud ERP gold certified partner.
The Gold Microsoft partner logo on a black background.
Sage business partner diamond logo.
Dell Technologies Gold Partner
Sage tech partner logo.

Stay in the know!

Subscribe for exclusive ERP, process automation, IT and cybersecurity news.

Twitter
  • Facebook
  • YouTube
  • LinkedIn

Home
About
Contact

Support
Screen Connect
Pay Online
Downloads

SWK logo.

Headquarters:
120 Eagle Rock Ave, Suite 330
East Hanover, NJ 07936

Contact:
info@swktech.com
(877) 979-5462

Copyright © 2025 · SWK Technologies, Inc. · All Rights Reserved · Terms of Use · Privacy Policy

This site uses cookies to collect information about your browsing activities in order to provide you with more relevant content and promotional materials, and help us understand your interests and enhance the site. By continuing to browse this site you agree to the use of cookies. Visit our privacy policy to learn more.I understand