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
2020 Release Wave 2Discover 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 TimelineWatch the 2020 Release Wave 1 virtual launch event
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I realized the other day that I’ve only posted this code in a reply, never as its own post, so I’m adding this now.
Slow-moving and obsolete inventory is traditionally a measure of inventory destined for markdown and ultimately write-off if not addressed. The nature of what is slow-moving and obsolete varies dramatically. Fresh bread is slow-moving if it hasn’t sold in a couple of days, heavy equipment could be months. Each organization determines what is slow-moving or obsolete.
This code compares inventory items to sales to determine items with quantities on hand that have not sold with the timeframe set in the date area.
SELECT IV00101.* FROMdbo.IV00101 INNER JOINdbo.IV00102 ON dbo.IV00101.ITEMNMBR = dbo.IV00102.ITEMNMBRWHERE(dbo.IV00101.ITEMNMBR NOT IN(SELECTdbo.SOP30300.ITEMNMBRFROM dbo.SOP30300INNER JOIN dbo.SOP30200ON dbo.SOP30300.SOPNUMBE = dbo.SOP30200.SOPNUMBEAND dbo.SOP30300.SOPTYPE = dbo.SOP30200.SOPTYPEWHERE (dbo.SOP30200.DOCDATE BETWEENCONVERT(DATETIME, ‘2019-03-01 00:00:00’, 102) AND CONVERT(DATETIME, ‘2021-02-28 00:00:00’, 102))))AND (dbo.IV00102.QTYONHND > 0)
Note: I had this in my set of scripts with no notations, that usually means I wrote it, however, I see that I posted a link to a version of this written by Mohammed Doud. The link is now gone so I’m not sure if this is his version or mine and I don’t want to take the credit if it’s his. Either way, it’s useful.
The post Dynamics GP: Slow-Moving Inventory appeared first on DynamicAccounting.net.
Business Applications communities