We been suffering from Historical Stock Status report issues when it comes to customers with big inventory transactions, I am providing a script that recalculate the historical stock status for your items based on the IV10200 and IV10201 tables, it will allow you to estimate your inventories using a historical date: Historical Stock Sttus Summary DECLARE @ASOFDATE DATETIME SET @ASOFDATE = ’2016-12-31′ SELECT ITEMNMBR AS Item Number , TRXLOCTN AS Location , SUM ( Quantity ) AS Quantity , SUM ( Extended Cost ) AS Total Cost FROM ( SELECT ITEMNMBR , ( dbo . IV10200 .
As many of you might notice that Linked In is celebrating their 200,000,000 users and started sending thanks for people who help spreading their name! They have ranked their users per the the viewing of their profile, so you either be one of the top 1% most viewer profiles, 5% or 10%. I made the 5% List! Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 firstname.lastname@example.org http://www.di.jo
I got an interesting question from one of the GP users requesting a list of unused Journal Number, therefore I decided to scratch my head and write this query, below will help: SELECT DISTINCT NUMBER FROM MASTER..spt_values WHERE NUMBER BETWEEN (SELECT MIN(JRNENTRY) AS FROMNUMBER FROM (SELECT DISTINCT JRNENTRY FROM GL20000) AS JOURNALS) AND (SELECT MAX(JRNENTRY) AS TONUMBER FROM (SELECT DISTINCT JRNENTRY FROM GL20000) AS JOURNALS) AND number NOT IN (SELECT DISTINCT JRNENTRY FROM GL20000) Happy tracking…! Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 email@example.com http://www.di.jo