用友 U8计算库存方法

zikn_92

于 2025-04-17 13:51:48 发布

阅读量418

点赞数 3

分类专栏：用友U8SQL语句，数据库语句 SQL SERVER 文章标签：数据库

本文链接：https://blog.csdn.net/m0_61834747/article/details/147304696

版权

SELECT COALESCE(csv.存货编码, osv.存货编码, isv.存货编码, '') AS 存货编码,
COALESCE(csv.仓库编码, osv.仓库编码, isv.仓库编码, '') AS 仓库编码,
COALESCE(csv.批号, osv.批号, isv.批号, '') AS 批号,
COALESCE(csv.序列号, osv.序列号, isv.序列号, '') AS 序列号,
SUM(COALESCE(csv.结存数量, 0) + COALESCE(osv.出库数量, 0) - COALESCE(isv.入库数量, 0)) AS 数量
FROM
(
SELECT COALESCE(存货编码, '') AS 存货编码,
COALESCE(仓库编码, '') AS 仓库编码,
COALESCE(批号, '') AS 批号,
COALESCE(序列号, '') AS 序列号,
COALESCE(结存数量, 0) AS 结存数量
FROM CurrentStockView
) csv
FULL OUTER JOIN
(
SELECT COALESCE(存货编码, '') AS 存货编码,
COALESCE(仓库编码, '') AS 仓库编码,
COALESCE(批号, '') AS 批号,
COALESCE(序列号, '') AS 序列号,
COALESCE(出库数量, 0) AS 出库数量