8.5利润中心科目余额初始化结束报错
利润中心总账科目余额结束初始化报错
具体报错日志如下
execute sql error: 列名 'fmonthpnlfor' 无效。
sql:UPDATE T_PCA_PCAccountBalance_1F SET fbeginbalancefor = beginbalancefor * fdc, fendbalancefor = ((beginbalancefor * fdc) + fdebitfor) - fcreditfor, fyeardebitfor = fyeardebitfor + yeardebitfor, fyearcreditfor = fyearcreditfor + yearcreditfor, fyearpnlfor = t.fmonthpnlfor, fbeginbalancelocal = beginbalancelocal * fdc, fendbalancelocal = ((beginbalancelocal * fdc) + fdebitlocal) - fcreditlocal, fyeardebitlocal = fyeardebitlocal + yeardebitlocal, fyearcreditlocal = fyearcreditlocal + yearcreditlocal, fyearpnllocal = t.fmonthpnllocal, fbeginbalancerpt = beginbalancerpt * fdc, fendbalancerpt = ((beginbalancerpt * fdc) + fdebitrpt) - fcreditrpt, fyeardebitrpt = fyeardebitrpt + yeardebitrpt, fyearcreditrpt = fyearcreditrpt + yearcreditrpt, fyearpnlrpt = t.fmonthpnlrpt, fyeardebitqty = fyeardebitqty + yeardebitqty, fyearcreditqty = fyearcreditqty + yearcreditqty, fbeginqty = beginqty * fdc, fendqty = ((beginqty * fdc) + fdebitqty) - fcreditqty, fyearpnlqty = ISNULL(fmonthpnlqty, 0) FROM (SELECT ab.fprofitcenterid PROFITCENTERID, ab.forgunitid ORGUNITID, ab.faccountid ACCOUNTID, ab.fcurrencyid CURRENCYID, ab.fbeginbalancefor BEGINBALANCEFOR, ab.fbeginbalancelocal BEGINBALANCELOCAL, ab.fbeginbalancerpt BEGINBALANCERPT, ab.fbeginqty BEGINQTY, av.fdc, ab.fyeardebitfor YEARDEBITFOR, ab.fyearcreditfor YEARCREDITFOR, ab.fyeardebitlocal YEARDEBITLOCAL, ab.fyearcreditlocal YEARCREDITLOCAL, ab.fyeardebitrpt YEARDEBITRPT, ab.fyearcreditrpt YEARCREDITRPT, ab.fyearpnlfor YEARPNLFOR, ab.fyearpnllocal YEARPNLLOCAL, ab.fyearpnlrpt YEARPNLRPT, ab.fyeardebitqty YEARDEBITQTY, ab.fyearcreditqty YEARCREDITQTY FROM t_pca_initpcaccountbalance ab INNER JOIN t_bd_accountview av ON ab.faccountid = av.fid WHERE (((ab.fprofitcenterid = ? AND ab.forgunitid = ?) AND (ab.fcurrencyid <> '11111111-1111-1111-1111-111111111111DEB58FDC')) AND (ab.fcurrencyid <> '22222222-2222-2222-2222-222222222222DEB58FDC'))) t WHERE (((profitcenterid = fprofitcenterid AND orgunitid = forgunitid) AND accountid = faccountid) AND currencyid = fcurrencyid) AND ((fprofitcenterid = ? AND forgunitid = ?) AND fperiod = ?)
ksql:update T_PCA_PCAccountBalance_1F set (
fbeginbalancefor, fendbalancefor,
fyeardebitfor, fyearcreditfor, fyearpnlfor,
fbeginbalancelocal, fendbalancelocal,
fyeardebitlocal, fyearcreditlocal, fyearpnllocal,
fbeginbalancerpt, fendbalancerpt,
fyeardebitrpt, fyearcreditrpt, fyearpnlrpt,
fyeardebitqty, fyearcreditqty,
fbeginqty, fendqty, fyearpnlqty) = ( select
beginbalancefor * fdc, beginbalancefor * fdc + fdebitfor - fcreditfor,
fyeardebitfor + yeardebitfor, fyearcreditfor + yearcreditfor, fmonthpnlfor,
beginbalancelocal * fdc, beginbalancelocal * fdc + fdebitlocal - fcreditlocal,
fyeardebitlocal + yeardebitlocal, fyearcreditlocal + yearcreditlocal, fmonthpnllocal,
beginbalancerpt * fdc, beginbalancerpt * fdc + fdebitrpt - fcreditrpt,
fyeardebitrpt + yeardebitrpt, fyearcreditrpt + yearcreditrpt, fmonthpnlrpt,
fyeardebitqty + yeardebitqty, fyearcreditqty + yearcreditqty,
beginqty * fdc, beginqty * fdc + fdebitqty - fcreditqty, isNull(fmonthpnlqty,0)
from (
select ab.fprofitcenterid profitcenterid, ab.forgunitid orgunitid, ab.faccountid accountid, ab.fcurrencyid currencyid, ab.fbeginbalancefor beginbalancefor, ab.fbeginbalancelocal beginbalancelocal, ab.fbeginbalancerpt beginbalancerpt, ab.fbeginqty beginqty, av.fdc
,ab.fyeardebitfor yeardebitfor, ab.fyearcreditfor yearcreditfor,
ab.fyeardebitlocal yeardebitlocal, ab.fyearcreditlocal yearcreditlocal,
ab.fyeardebitrpt yeardebitrpt, ab.fyearcreditrpt yearcreditrpt
,ab.fyearpnlfor yearpnlfor, ab.fyearpnllocal yearpnllocal, ab.fyearpnlrpt yearpnlrpt
,ab.fyeardebitqty yeardebitqty, ab.fyearcreditqty yearcreditqty
from t_pca_initpcaccountbalance ab
inner join t_bd_accountview av on ab.faccountid=av.fid
where ab.fprofitcenterid = ?
and ab.forgunitid = ?
and ab.fcurrencyid <> '11111111-1111-1111-1111-111111111111DEB58FDC'
and ab.fcurrencyid <> '22222222-2222-2222-2222-222222222222DEB58FDC'
) t
where profitcenterid = fprofitcenterid
and orgunitid = forgunitid and accountid = faccountid
and currencyid = fcurrencyid
)
where fprofitcenterid = ? and forgunitid = ? and fperiod = ?
关联提单:R20181212-2446
解决方案:更新补丁PT131166
8.5利润中心科目余额初始化结束报错
本文2024-09-22 19:26:11发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-107185.html