发布时间:2024-7-2
特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠,畅捷通T+cloud、好会计、好业财、好生意云产品6-8折优惠,另有话费赠送。
BE-2020-02-0097费用单已分摊,费用分摊查询工具里查询不到。
问题回复:
查看数据中问题单据如下: 有表头无分摊明细 SF-2020-04-0008 SF-2020-02-0053 有表头无费用明细 SF-2020-02-0054 SF-2020-04-0009 ,请备份数据后使用修复脚本处理后再查看。
GO -- 从SF-2020-02-0053补到SF-2020-02-0054 UPDATE SA_SaleExpenseAllocationExpenseDetail SET idSaleExpenseAllocationDTO = 966 WHERE id = 1411 -- 删除单据SF-2020-02-0053 DELETE FROM SA_SaleExpenseAllocation WHERE id = 965 -- 从SF-2020-04-0008补到SF-2020-04-0009 UPDATE SA_SaleExpenseAllocationExpenseDetail SET idSaleExpenseAllocationDTO = 967 WHERE id = 1410 -- 删除单据SF-2020-04-0009 DELETE FROM SA_SaleExpenseAllocation WHERE id = 964 GO
截屏,微信识别二维码
客服QQ:5151867
(点击QQ号复制,添加好友)