存货管理-成本计算

--全月加权成本计算
drop table #CKDGETCB8229840
SELECT KCCKD2_LSBH F_LSBH,KCCKD2_FLBH F_FLBH,KCCKD2_TSKC F_TSKC,KCCKD2_XGDX F_XGDX,KCCKD1_CKBH F_CKBH,KCCKD2_WLBH F_WLBH,KCCKD2_PCH F_PCH,KCCKD2_ZYX1 F_F1,KCCKD2_ZYX2 F_F2, KCCKD2_ZYX3 F_F3,KCCKD2_ZYX4 F_F4,KCCKD2_ZYX5 F_F5,KCCKD2_WLBZ F_WLBZ,KCCKD2_WLZT F_WLZT,convert(decimal(18,4),0) F_DJ,LSWLZD_CKFS F_CKFS,LSWLZD_CKHS F_CKHS into #CKDGETCB8229840 FROM KCCKD1,KCCKD2,LSWLZD  WHERE KCCKD1_LSBH=KCCKD2_LSBH AND KCCKD2_WLBH=LSWLZD_WLBH  AND LSWLZD_JJFF='2' AND KCCKD1_SFJCHZ='1' AND  (  (KCCKD1_SJDH='@YL2026033103246' AND KCCKD1_PJLX='Q') ) AND KCCKD1_CHYWRQ<='20260425' AND KCCKD1_CHYWRQ>='20260326'
--2026-05-10 11:13:00:2120
UPDATE #CKDGETCB8229840 SET F_DJ=KCCKDJ_SJDJ FROM KCCKDJ  
WHERE F_CKBH=KCCKDJ_CKBH AND F_WLBH=KCCKDJ_WLBH AND F_PCH=KCCKDJ_PCH 
AND F_F1=KCCKDJ_F1 AND F_F2=KCCKDJ_F2 AND F_F3=KCCKDJ_F3 AND F_F4=KCCKDJ_F4 
AND F_F5=KCCKDJ_F5 AND F_WLBZ=KCCKDJ_WLBZ AND F_WLZT=KCCKDJ_WLZT 

select  * from KCCKDJ where KCCKDJ_WLBH='B63618000XZP-2'
select  * from #CKDGETCB8229840
--2026-05-10 11:13:00:2550
SELECT F_VAL FROM LSCONF Where F_VKEY ='CH_LDJFS' 
--2026-05-10 11:13:00:2670
UPDATE KCCKD2 SET  KCCKD2_DJ=ROUND(#CKDGETCB8229840.F_DJ,4), KCCKD2_JE=ROUND(ROUND(KCCKD2_SL,3)*ROUND(#CKDGETCB8229840.F_DJ,4),2), KCCKD2_CBBZ = '1'  FROM KCCKD1,#CKDGETCB8229840 
WHERE KCCKD1_LSBH=KCCKD2_LSBH AND F_LSBH=KCCKD2_LSBH AND F_FLBH=KCCKD2_FLBH AND KCCKD2_CBBZ='0'  

select KCCKD2_DJ,F_DJ,*  FROM KCCKD1,KCCKD2,#CKDGETCB8229840 
WHERE KCCKD1_LSBH=KCCKD2_LSBH AND F_LSBH=KCCKD2_LSBH AND F_FLBH=KCCKD2_FLBH 
--2026-05-10 11:13:00:2890
UPDATE KCCKD1 SET KCCKD1_CBBZ = '1' WHERE EXISTS (SELECT 1 FROM #CKDGETCB8229840 WHERE KCCKD1.KCCKD1_LSBH = F_LSBH AND NOT EXISTS(SELECT 1 FROM KCCKD2 WHERE KCCKD2_LSBH = #CKDGETCB8229840.F_LSBH  AND KCCKD2_CBBZ = '0'))
--2026-05-10 11:13:00:3150
update LSCONF Set F_VAL ='202604' Where F_VKEY ='CH_YMJSRQ' 
--2026-05-10 11:13:00:3880
SELECT KCCKD1.KCCKD1_PJLX, KCCKD1.KCCKD1_LSBH, KCCKD1.KCCKD1_DJRQ, KCCKD1.KCCKD1_KCYWRQ, KCCKD1.KCCKD1_CHYWRQ, KCCKD1.KCCKD1_SJDH, KCCKD1.KCCKD1_LBBH, KCCKD1.KCCKD1_CKBH, KCCKD1.KCCKD1_BMBH, KCCKD1.KCCKD1_YTBH, KCCKD1.KCCKD1_XEDH, KCCKD1.KCCKD1_THDH, KCCKD1.KCCKD1_DWMC, KCCKD1.KCCKD1_DWBH, KCCKD1.KCCKD1_FZR, KCCKD1.KCCKD1_LYR, KCCKD1.KCCKD1_LRXM, KCCKD1.KCCKD1_BGY, KCCKD1.KCCKD1_KCJZ, KCCKD1.KCCKD1_CHJZ, KCCKD1.KCCKD1_HDBZ, KCCKD1.KCCKD1_KCJZSJ, KCCKD1.KCCKD1_CHJZSJ, LSWLZD.LSWLZD_WLMC, KCCKD1.KCCKD1_CPPC, KCCKD1.KCCKD1_BZ,    '0' as F_STAT, KCCKD1.KCCKD1_KCXM, KCCKD1.KCCKD1_YWBS, KCCKD1.KCCKD1_LYR, KCCKD1.KCCKD1_LYBH, KCCKD1.KCCKD1_SHXM, KCCKD1.KCCKD1_SHRQ, KCCKD1.KCCKD1_DYPERSON, KCCKD1.KCCKD1_DYDATE FROM KCCKD1 LEFT JOIN LSWLZD ON KCCKD1_CPBH=LSWLZD_WLBH WHERE KCCKD1_KCJZ='1' AND KCCKD1_CHJZ='0' AND KCCKD1_PJLX<>'R' AND KCCKD1_SFJCHZ='1' AND KCCKD1_CHYWRQ<='20260425' AND KCCKD1_CHYWRQ>='20260326' 
AND EXISTS (SELECT KCCKD2_LSBH FROM KCCKD2,LSWLZD WHERE KCCKD2_LSBH=KCCKD1_LSBH AND KCCKD2_WLBH=LSWLZD_WLBH 
AND KCCKD2_CBBZ='0' AND LSWLZD_JJFF='2' )
--2026-05-10 11:13:00:3970
SELECT KCYTZD.KCYTZD_YTBH, KCYTZD.KCYTZD_YTMC, KCYTZD.KCYTZD_JS, KCYTZD.KCYTZD_MX FROM KCYTZD
WHERE KCYTZD_MX=1 ORDER BY KCYTZD_YTBH 


---计算移库单入库成本
--2026-05-10 12:33:11:6610
drop table  #CKDJJS8215290

SELECT distinct KCCKDJ_CKBH DJ_CKBH,KCCKDJ_WLBH DJ_WLBH,KCCKDJ_PCH DJ_PCH,KCCKDJ_F1 DJ_F1,KCCKDJ_F2 DJ_F2,KCCKDJ_F3 DJ_F3,KCCKDJ_F4 DJ_F4,KCCKDJ_F5 DJ_F5,KCCKDJ_WLBZ DJ_WLBZ,KCCKDJ_WLZT DJ_WLZT,'Z' DJ_TSKC,' ' DJ_XGDX,KCCKDJ_SJDJ DJ_SJDJ INTO #CKDJJS8215290 FROM KCRKD2,KCCKDJ WHERE KCRKD2_LSBH = '8166794' AND KCRKD2_WLBH=KCCKDJ_WLBH AND KCRKD2_PCH=KCCKDJ_PCH AND KCRKD2_ZYX1=KCCKDJ_F1 AND KCRKD2_ZYX2=KCCKDJ_F2 AND KCRKD2_ZYX3=KCCKDJ_F3 AND KCRKD2_ZYX4=KCCKDJ_F4 AND KCRKD2_ZYX5=KCCKDJ_F5 AND KCRKD2_WLBZ=KCCKDJ_WLBZ AND KCRKD2_WLZT=KCCKDJ_WLZT AND KCRKD2_TSKC=KCCKDJ_TSKC AND KCRKD2_XGDX=KCCKDJ_XGDX 
--2026-05-10 12:33:11:7310
UPDATE KCRKD2 SET KCRKD2_DJ=KCCKD2_DJ,KCRKD2_JE=ROUND(KCCKD2_DJ*KCRKD2_SSSL,2) from KCRKD1,KCCKD1,KCCKD2,#CKDJJS8215290 WHERE  KCRKD1_LSBH=KCRKD2_LSBH AND KCRKD1_LSBH='8166794' AND KCRKD2_LSBH='8166794' AND KCRKD1_LYBH=KCCKD1_LYBH AND KCCKD1_LSBH=KCCKD2_LSBH AND KCRKD2_FLBH=KCCKD2_FLBH AND KCCKD1_YWBS IN ('KCYKD','JSCKD','JSDZC','DDDZC','XMDZC','JCDZY') AND KCCKD1_YWBS=KCRKD1_YWBS  
--2026-05-10 12:33:11:7870
UPDATE KCRKD1 SET KCRKD1_CBBZ='1'  WHERE  KCRKD1_LSBH = '8166794'