qijie144xuan 发表于 2011-1-19 00:41:06

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

本帖最后由 qijie144xuan 于 2011-1-19 00:42 编辑


请各位帮忙解决

jojo_bj 发表于 2011-1-19 09:00:25

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

qijie144xuan 发表于 2011-1-19 09:12:37

以下是数据库跟踪出来的语句，不知道哪里错了
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
deletefrom DispatchLists
go
deletefrom DispatchList
go
deletefrom SA_SettleVouchs
go
deletefrom SA_SettleVouch
go
deletefrom SaleBillVouchs
go
deletefrom SaleBillVouch
go
deletefrom SO_SODetails
go
deletefrom SO_SOMain
go
deletefrom SalePayVouchs
go
deletefrom SalePayVouch
go
deletefrom ExpenseVouchs
go
deletefrom ExpenseVouch
go
deletefrom SA_WrapLease
go
SET NO_BROWSETABLE OFF

37724861 发表于 2011-1-19 17:28:20

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

cuilong321 发表于 2011-1-19 17:40:17

顶一下，很好的问题

nmufida 发表于 2011-1-20 12:19:31

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

emily.du 发表于 2011-1-20 15:00:37

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

fyz1223 发表于 2011-1-20 20:44:01

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

用友软件（15209 发表于 2017-1-17 23:31:36

没有得到实质性的解决

用友软件（15209 发表于 2017-1-17 23:54:47

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

G36393GG 发表于 2017-1-18 16:45:52


你可以检查看有否审核，

nazi8888 发表于 2017-10-21 15:18:45

这类的错误只能看SQL数据库的跟踪，看一下是哪里的问题，要慢慢看，最后或许能发现结转出错的地方！
页: [1]
查看完整版本: U852供应链年结时提示销售系统年结失败