详细信息

您现在的位置：网站首页 >> 百科问答 >> 详细信息

T3采购入库单保存失败，格式损坏的恢复（单据格式）

特价活动:>>>> 畅云管家新购、续费7折优惠，畅捷通T+cloud、好会计、易代账、好业财、好生意云产品8折优惠。　

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'

上一篇:企业管理软件T3项目管理辅助核算设置

下一篇:用友畅捷通T+提示功能已超出最大用户数清理