UHF - Header
Skip to main content
Microsoft
Dynamics 365 Community
  • Home
    • Home
      • Sales
      • Customer Service
      • Customer Voice
      • Field Service
      • Human Resources
      • Finance
      • Supply Chain Management
      • Commerce
      • Project Operations
      • Project Service Automation
      • Marketing
        • Customer Insights
        • Customer Voice
        • Customer Insights
        • Fraud Protection
        • Connected Store
        • Remote Assist
        • Guides
        • Product Visualize
      • Business Central
      • General
      • Microsoft Dynamics CRM
      • Microsoft Dynamics AX
      • Microsoft Dynamics NAV
      • Microsoft Dynamics GP
      • Microsoft Dynamics SL
      • Other Products
  • GP Forum
  • Ideas
  • Events
    • Learning Resources
    • Documentation
    • TechTalks
    • Better Together Integration
    • Unified Interface Community
    • Industry Accelerators Community
      • Academic Community
      • Academic Career Portal
      • Community Gallery
      • MBAS 2019 Gallery
      • MBAS 2020 Gallery
    • GP Community Blogs
    • Dynamics 365 Videos
    • Webinars
  • User Groups
    • Community News
    • Get Started
    • Introduce Yourself
      • Earn Badges
      • View Badges
      • Compete on Leaderboards
      • View Leaderboards
    • Become a Top Contributor
    • Request a New Blog
    • Community Feedback
    • Access personal data
      • Power BI Community
      • Power Automate Community
      • Power Apps Community
      • Power Virtual Agents Community
  • My Community
      • Microsoft 365
      • Azure
      • Office 365
      • Dynamics 365
      • Power Platform
      • Windows 10
      • Windows Server
      • Enterprise Mobility + Security
      • Power BI
      • Teams
      • Visual Studio
      • Microsoft Advertising
      • AI
      • Internet of Things
      • Azure Cognitive Services
      • Quantum
      • Microsoft HoloLens
      • Mixed Reality
      • Docs
      • Developer Center
      • Windows Dev Center
      • Windows IT Pro Center
      • FastTrack
      • Power Platform
      • Partner Network
      • Solution Providers
      • Partner Center
      • Cloud Hosting
      • Education
      • Financial services
      • Government
      • Health
      • Manufacturing & resources
      • Retail
      • Security
      • Licensing
      • AppSource
      • Azure Marketplace
      • Events
      • Research
    • View Sitemap
    Sign in
    1. Home
    2. Microsoft Dynamics GP
    3. DynamicAccounting.net
    4. SQL View for inventory Quantities on Hand
    SBX - Ask Questions

    Community Forums

    Ask a Question
    SBX - RBE Personalized Column Equal Content Card

    Personalize your experience!

    Personalized Community is here!

    Quickly customize your community to find the content you seek.

    • Personalize Community Now
    Role Image

    Top Tags

    View All
    Uncategorized MSDYNGP News troubleshooting System Management Reporter SQL SQL Script Reporting implementation Weekly Tips development payroll Sales Inventory GL ap Purchasing Support Debugging Tool security gpug fixed assets AR Integration Manager Events Dexterity SOP Excel business intelligence Word Reports FRx Convergence 2013 eConnect ISV Solutions project accounting training SSRS Convergence 2012 smartlists year end web client Editorial Funny Analytical Accounting support convergence 2011 Report Writer Integration PowerPivot Professional Service Tools videos Tax SmartList Builder SmartConnect Vote for Features Extender Service Packs VBA Field Service business portal POP Forecaster Banking Excel Reports chart of accounts Manufacturing Home Page multi-currency email Purchase Orders HR/Payroll budgeting Convergence 2010 Backup Business Analyzer Project Auditing EFT Licensing Sure Step 1099 CRM MSDYNAX Visual Studio Tools bank reconciliation Navigation Lists Web Services DEX.INI workflow SmartList Analysis Cubes msdynnav Terminal Services podcast HR D365 Tips Note Index ODBC Competition
    SBX - Heading

    Name

    FEATURED CONTENT

    Choose your path
    Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.

    Visit Microsoft Learn

    Name

    PRODUCT UPDATES

    2020 Release Wave 2
    Discover the latest updates and new features to Dynamics 365 planned through March 2021.

    Release overview guides and videos
    Release Plan | Preview 2020 Release Wave 2 Timeline
    Watch the 2020 Release Wave 2 virtual launch event

    Name

    PARTNER CONSULTING SERVICES

    Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings

    Name

    ISV

    Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal

    Name

    FASTTRACK

    The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence. 

    FastTrack Program  |  Finance TechTalks  |  Customer Engagement TechTalks  |  Upcoming TechTalks

    SBX - Finance Heading

    SQL View for inventory Quantities on Hand

    Options
    • Share
      • Twitter
      • LinkedIn
      • Facebook
      • Email
      • Print
    • RSS
    DynamicAccounting.net
    DynamicAccounting.net DynamicAccounting.net
    on 7 Dec 2009 4:30 AM
    Victoria Yudin has posted a new SQL view to show inventory items, current quantities, last sales and purchase date along with vendor. Make sure you check it out.

    Read Complete Post and Comments
    SBX - Two Col Forum

    Business Applications communities

    Select Community
    • Dynamics 365 Community
    • Power BI Community
    • Power Automate Community
    • Power Apps Community
    • Power Virtual Agents Community
    SBX - Migrated JS
    UHF - Footer
    What's new
    • Surface Duo
    • Surface Laptop Go
    • Surface Pro X
    • Surface Go 2
    • Surface Book 3
    • Microsoft 365
    • Windows 10 apps
    • HoloLens 2
    Microsoft Store
    • Account profile
    • Download Center
    • Microsoft Store support
    • Returns
    • Order tracking
    • Virtual workshops and training
    • Microsoft Store Promise
    • Financing
    Education
    • Microsoft in education
    • Office for students
    • Office 365 for schools
    • Deals for students & parents
    • Microsoft Azure in education
    Enterprise
    • Azure
    • AppSource
    • Automotive
    • Government
    • Healthcare
    • Manufacturing
    • Financial services
    • Retail
    Developer
    • Microsoft Visual Studio
    • Windows Dev Center
    • Developer Center
    • Microsoft developer program
    • Channel 9
    • Office Dev Center
    • Microsoft Garage
    Company
    • Careers
    • About Microsoft
    • Company news
    • Privacy at Microsoft
    • Investors
    • Diversity and inclusion
    • Accessibility
    • Security
    English (United States)
    • Contact Us
    • Privacy
    • Manage Cookies
    • Terms of Use
    • Trademarks
    • © Microsoft 2021