固定资产卡片做过拆分,不小心把拆1、拆2的数量录入为0保存了,现在需要对拆1、拆2做清理,但清理界面原数量为0?

栏目：k3wise知识作者：金蝶来源：金蝶云社区发布：2024-09-22浏览：9

[解决方案]

(安全警示:为了您的账套数据安全,请在下面操作或数据更新前做好数据的备份)

执行以下语句查询数量的为0的卡片

SELECT FNumAlter,* FROM t_FABalance where FBalID in(SELECT FBalID FROM t_FABalCard where FAssetNumber LIKE('%拆%') AND FNum=0)--期初数量、数量变化值

SELECT FNum,* FROM t_FABalCard where FAssetNumber LIKE('%拆%') AND FNum=0

SELECT FNum,* FROM t_FACard where FAssetNumber LIKE('%拆%') AND FNum=0

执行以下语句更新卡片的数量

UPDATE t_FABalance SET FNumAlter=1 where FBalID in(SELECT FBalID FROM t_FABalCard where FAssetNumber LIKE('%拆%') AND FNum=0)

UPDATE t_FABalCard SET FNum=1 where FAssetNumber LIKE('%拆%') AND FNum=0

UPDATE t_FACard SET FNum=1 where FAssetNumber LIKE('%拆%') AND FNum=0

本文2024-09-22 13:45:20发表“k3wise知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-k3wise-70646.html

阅读排行