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
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All 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