技巧集锦031：期初库存核对SQL

最新推荐文章于 2024-06-19 10:59:12 发布

NO66781

最新推荐文章于 2024-06-19 10:59:12 发布

阅读量714

点赞数

分类专栏：时空智友

本文链接：https://blog.csdn.net/NO66781/article/details/103300999

版权

时空智友专栏收录该内容

61 篇文章 70 订阅

订阅专栏

-- 检查结存平衡
SELECT SUM(StorNum) AS [库存数量],SUM(PlaceNum) AS [库管数量],SUM(StorAmount) AS [库存金额],'企业级结存管理' FROM dbo.EGBALANCE		        --商品企业级结存管理
SELECT SUM(StorNum) AS [库存数量],SUM(PlaceNum) AS [库管数量],SUM(StorAmount) AS [库存金额],'机构核算中心结存管理' FROM dbo.OrgGoodsAcct	--商品机构核算中心
SELECT SUM(StorNum) AS [库存数量],SUM(PlaceNum) AS [库管数量],SUM(StorAmount) AS [库存金额],'机构级结存管理' FROM dbo.OGBalance		        --商品机构级结存管理
SELECT SUM(StorNum) AS [库存数量],SUM(PlaceNum) AS [库管数量],SUM(StorAmount) AS [库存金额],'库房结存管理' FROM dbo.StorBalance		        --商品库房结存管理
SELECT SUM(placenum),'库房批号结存' FROM VStorAngBal
SELECT         '无' AS [库存数量],SUM(PlaceNum) AS [库管数量],'存放位置结存管理' FROM dbo.LocatBalance		                                --商品存放位置的结存管理       
SELECT         '无' AS [库存数量],SUM(PlaceNum) AS [库管数量],'商品维度结存管理' FROM dbo.AngleBalance		                                --商品维度结存管理
SELECT         '无' AS [库存数量],SUM(PlaceNum) AS [库管数量],'商品包装结存管理' FROM dbo.PackBalance		                                --商品包装结存管理
SELECT SUM(ISNULL(placenum,0)) FROM KK_WMS_KC 
SELECT SUM(ISNULL(placenum,0)) FROM KK_ERP_KC