使用记账宝转T3工具无数量核算解决方法

记账宝升级T3无数量核算更新语句

--select * from gl_accvouch where ccode like '1211%'

--select * from jzb_002_2015..g_pvouchs  where ccode  like '1211%'

--select * from gl_accsum where ccode like '1211%'

--select * from jzb_002_2015..g_accsum where ccode like '1211%'

--select * from jzb_002_2015..g_pvouchs  where ccode  like '1211%'

--select * from  jzb_002_2015..g_pvouch  

--说明：jzb_002_2015为记账宝ACCess 导入SQL中的数据库，此语句是更新T3账套对应记账宝数据库凭证表的数量

use ufdata_002_2015

go

--更改科目数量核算及单位,帐页格式

update a

set a.cbook_type=b.cbook_type,a.cmeasure=b.cmeasure

from code a,jzb_002_2015..g_code b

where a.ccode=b.ccode

--创建一张临时表把记账宝凭证主子表合并成一张

select * into pzmx from jzb_002_2015..g_pvouchs 

go

ALTER TABLE pzmx

ADD pzh varchar(20)

go

ALTER TABLE pzmx

ADD pzrq datetime 

go

select * from pzmx  where ccode like '1211%'

select * from gl_accvouch where ino_id='65' and dbill_date='2016-12-31'

go

update a

set a.pzh=b.ino_id,a.pzrq=b.dbill_date

from pzmx a,jzb_002_2015..g_pvouch b

where a.isid=b.isid

go

--更改凭证明细账借方数量

go

update a

set a.nd_s=b.namount

from gl_accvouch a,pzmx b

where a.ccode=b.ccode and a.ino_id=b.pzh and a.dbill_date=b.pzrq and a.inid=b.snid and a.cdigest=b.cdigest

and b.cd_c=1 and b.namount is not null

go

--更改凭证明细账贷方数量

update a

set a.nc_s=b.namount

from gl_accvouch a,pzmx b

where a.ccode=b.ccode and a.ino_id=b.pzh and a.dbill_date=b.pzrq and a.inid=b.snid and a.cdigest=b.cdigest 

and b.cd_c=0 and b.namount is not null

go

改完后要重新恢复记账 再重新记账