Browse by Tags

All Tags » Microsoft Dynamics GP Inventory   (RSS)
11 November 2008
Item Transactions Analysis
Interested in analyzing your items transaction? Check view below: SELECT dbo.SOP10100.DOCDATE, dbo.SOP10200.LOCNCODE as TRXLOCTN, CASE WHEN dbo.SOP10200.SOPTYPE = 4 THEN 'Return Unposted' When dbo.SOP10200.SOPTYPE = 3 Then 'Sales Unposted' end AS TrxType, Read More...
0 Comments  
11 November 2008
List of inventory items that have not sold between two dates
View below list the inventory items that have not sold between two dates: SELECT IV00101.* FROM dbo.IV00101 INNER JOIN dbo.IV00102 ON dbo.IV00101.ITEMNMBR = dbo.IV00102.ITEMNMBR WHERE (dbo.IV00101.ITEMNMBR NOT IN (SELECT dbo.SOP30300.ITEMNMBR FROM dbo.SOP30300 Read More...
0 Comments