U852供应链年结时提示销售系统年结失败

qijie144xuan

请各位帮忙解决

jojo_bj

神都帮不了你，看不到后台那张表出错了，自己去事件探查器监测去

qijie144xuan

以下是数据库跟踪出来的语句，不知道哪里错了
alter table salebillvouch disable trigger all
go
alter table salebillvouchs disable trigger all
go
alter table dispatchlist disable trigger all
go
alter table dispatchlists disable trigger all
go
alter table sa_settlevouch disable trigger all
go
alter table sa_settlevouchs disable trigger all
go
SELECT dBegin, dEnd FROM UA_Period WHERE cAcc_id = '004' AND iYear = 2011 AND iid = 1 AND  (bIsDelete=0 or bisdelete is null)
go
SELECT dBegin, dEnd FROM UA_Period WHERE cAcc_id = '004' AND iYear = 2011 AND iid = 12 AND  (bIsDelete=0 or bisdelete is null)
go
SELECT dBegin, dEnd FROM UA_Period WHERE cAcc_id = '004' AND iYear = 2011 AND iid = 1 AND  (bIsDelete=0 or bisdelete is null)
go
delete  from DispatchLists
go
delete  from DispatchList
go
delete  from SA_SettleVouchs
go
delete  from SA_SettleVouch
go
delete  from SaleBillVouchs
go
delete  from SaleBillVouch
go
delete  from SO_SODetails
go
delete  from SO_SOMain
go
delete  from SalePayVouchs
go
delete  from SalePayVouch
go
delete  from ExpenseVouchs
go
delete  from ExpenseVouch
go
delete  from SA_WrapLease
go
SET NO_BROWSETABLE OFF

37724861

牛X的楼主，就算你跟踪的语句是错误的原因，那也只能在出问题的帐套上测试啊 囧

cuilong321

顶一下，很好的问题

nmufida

同意2楼的。你进的002帐套。怎么显示系统库中日期表里004有问题呢。

emily.du

你可以检查看有否审核，生成发票之类的问题

fyz1223

跟踪出来的语句怎么没看到insert语句。。。。

用友软件（15209

没有得到实质性的解决

用友软件（15209

兄弟这个问题你是怎么处理的

G36393GG

你可以检查看有否审核，

nazi8888

这类的错误只能看SQL数据库的跟踪，看一下是哪里的问题，要慢慢看，最后或许能发现结转出错的地方！