如何清除供应链应收应付数据

ww8848

上次一客户想对账套做些处理，具体干什么用你懂的，由于启用了财务供应链所以处理起来比较麻烦，当然方法有很多种？
delete from ia_summary
delete from IA_Subsidiary
delete from rdrecords
delete from rdrecord
delete from currentstock
delete from SO_SODetails
delete from so_somain
delete from DispatchLists
delete from DispatchList
delete from SaleBillVouchs
delete from SaleBillVouch
delete from PurBillVouchs
delete from PurBillVouch
delete from PO_Podetails
delete from PO_Pomain
delete from PU_AppVouchs
delete from PU_AppVouch
delete from PurSettleVouchs
delete from PurSettleVouch
delete from  Ap_Detail
delete from ap_closebills
delete from ap_closebill
delete from Ap_Vouchs
delete from Ap_Vouch
delete from Ap_XjDetail
delete from OM_MatSettleVouchs
delete from OM_MatSettleVouch
delete from OM_MOMaterials
delete from OM_MODetails
delete from OM_MOmain
select * from AssemVouchs
delete from  transvouchs
delete from  transvouch
delete from AssemVouchs
delete from AssemVouch
delete from JustInVouchs
delete from JustInVouch
delete from inventory
delete from inventory_sub
delete from IA_HeadSet
delete from inventoryclass
update gl_accvouch set coutsign=null,coutid=null,coutbillsign=null,coutsysname=null where coutsysname is not null

yfxx_cg

这种方法对于客户来说难度高了点，还不如备份数据后清空年度数据，然后引入凭证