T3采购入库单保存失败，格式损坏的恢复
来源：
扬州七龙网络科技有限公司 日期：2022-10-07 1089
属于：技术资料库
T3采购入库单保存失败，格式损坏的恢复
除了业务单据恢复工具之外，可以用如下语句修复
DELETE FROM InvoiceItema WHERE CardNum = '24' INSERT INTO InvoiceItema SELECT * FROM UFDATA_998_2012..InvoiceItema WHERE CardNum = '24'
DELETE FROM InvoiceItema WHERE CardNum = '24' INSERT INTO InvoiceItema SELECT * FROM UFDATA_998_2012..InvoiceItema WHERE CardNum = '24'
DELETE FROM InvoiceItema WHERE CardNum = '24' INSERT INTO InvoiceItema SELECT * FROM UFDATA_998_2012..InvoiceItema WHERE CardNum = '24'
DELETE FROM InvoiceItema WHERE CardNum = '24' INSERT INTO InvoiceItema SELECT * FROM UFDATA_998_2012..InvoiceItema WHERE CardNum = '24'
DELETE FROM InvoiceItema WHERE CardNum = '24' INSERT INTO InvoiceItema SELECT * FROM UFDATA_998_2012..InvoiceItema WHERE CardNum = '24'
DELETE FROM InvoiceItema WHERE CardNum = '24' INSERT INTO InvoiceItema SELECT * FROM UFDATA_998_2012..InvoiceItema WHERE CardNum = '24'DELETE FROM InvoiceItema WHERE CardNum = '24'
INSERT INTO InvoiceItema SELECT * FROM UFDATA_998_2012..InvoiceItema WHERE CardNum = '24'
24是采购入库单的编号，998_2012是演示账套，从好的账套拷贝过去覆盖
DELETE FROM InvoiceItema WHERE CardNum = '24' INSERT INTO InvoiceItema SELECT * FROM UFDATA_998_2012..InvoiceItema WHERE CardNum = '24'
上一技术资料：WIN10远程桌面连接问题
下一技术资料：U8 通过后台数据库反启用各模块
