速达财务系列问题处理

1、结帐时出纳与会计有差异,但出纳的数据与总分类帐里的数据是一致 软件版本:财务系列V6.0 解决方法:

A、出纳帐进行反引入

B、select * from aa_creditem where credit<>rawcredit and happendate>'出错的起始日期' and happendate<'出错的结束日期' and subjectid=’银存、现金或其他货币资金的subjectid’

/*查询凭证从表中本位币和原币金额不相等的记录*/ C、如果有记录返回,则运行

update aa_creditem set rawcredit=credit where credit<>rawcredit and happendate>'出错的起始日期' and happendate<'出错的结束日期' and subjectid=’银存、现金或其他货币资金的subjectid’ D、运行完毕,在出纳帐进行引入

2、在打开会计科目时,提示“你输入的数值不规范,请输入整数” 软件版本:财务系列V5.9

问题分析:科目编码太长或者为空 解决方法:

A、select * from al_subject order by subcode

B、 将会计科目进行排序.然后看到有subcode会计编码过长的或者为空的.直接删除或者修改就可以了.

3、在初始化阶级,已对某账户进行了辅助核算,并录入了该辅助核算的期初数,启用账套后,打开科目辅助汇总表时,发现期初结存金额全部显示为0。 软件版本:财务系列(财务STD、财务PRO、财务XP)V5.8-V6.0版本 解决方法:

A、升级到V6.0或6.0以上版本,并对原账套进行修复。 B、反结账到期初,并对账套进行反结账

C、重新录入辅助核算科目的期初余额,建议输入完毕后,再运行如下语句: Update aa_creditem set unclearamt=debit+credit

B、启用账套,并进行相关的签字、审核、登账、结账等操作。

4、打开某记账凭证时,系统出现“abnormal terminal program”的提示信息,然后软件自动退出。

软件版本:财务系列(财务STD、财务PRO、财务XP)V5.8-V6.0版本 解决方法:

A、select * from al_subject where allsubname is null

/*通过该查询语句,查找会计科目表单中,是否存在全称为空的会计科目*/ B、update al_subject set allsubname=' '+name where allsubname is null /*把会计科目全称为空的科目前,插入一空格,执行该语句后,科目全称将按触发器自动地进行更新*/

C、update al_subject set name=ltrim(name)

/*该语句可去除会计科目前的空格*/

5、“初始数据录入”的辅助核算货品期初数量与“收发存总表”的期初数量无法对应。 产品信息:速达财务XP 版本信息:V6.1 模块名称:报表系统 解决方法:

SET QUOTED_IDENTIFIER OFF GO

SET ANSI_NULLS OFF GO

/*********************************************************************************************** author: awens

last updated: 2005-10-26, awens remark:

***********************************************************************************************/

ALTER function ac_cost_balance( @bnyear integer, @bnmonth integer, @subid integer, @goodsid integer )

returns @local_tab table( balanceamt numeric(18,8), balanceprice numeric(18,8), balanceqty numeric(18,8) ) as begin

declare @initamt numeric(18,8), @amt numeric(18,8), @initqty numeric(18,8), @qty numeric(18,8),

@unitprice numeric(18,8), @tmpamt numeric(18,8), @tmpqty numeric(18,8), @startyear int, @startmonth int, @crntaccyear int,

@crntaccmonth int,

@startaccyearmonth varchar(10), @crntaccyearmonth varchar(10), @yearmonth varchar(10)

declare @credyearmonthbegin varchar(10) declare @costtype integer declare @todebit integer declare @IsSpecAcc integer

declare

@subjectid integer

set @initamt = 0 set @initqty = 0 set @amt = 0 set @qty = 0

set @unitprice = 0

set @yearmonth = '190001'

select @IsSpecAcc=cast(datavalue as int) from am_sysparam where paramid=906 or upper(name)=upper('IsUpdateFromOther')

select @startyear = cast(datavalue as int) from am_sysparam where lower(name)='startyear'

select @startmonth = cast(datavalue as int) from am_sysparam where lower(name)='startmonth'

select @crntaccyear = cast(datavalue as int) from am_sysparam where lower(name)='curraccyear'

select @crntaccmonth = cast(datavalue as int) from am_sysparam where lower(name)='curraccmonth' select @startaccyearmonth=credyearmonth from dbo.fn_aa_getcredyearmonthstr(@startyear,@startmonth) select @crntaccyearmonth=credyearmonth from dbo.fn_aa_getcredyearmonthstr(@crntaccyear,@crntaccmonth) select @credyearmonthbegin=credyearmonth from dbo.fn_aa_getcredyearmonthstr(@bnyear,@bnmonth) set @subjectid=@subid

select top 1

@yearmonth=m.credyearmonth,@tmpamt=isnull(liveamt,0),@tmpqty=isnull(liveqty,0) from aa_creditem d

inner join aa_cred m on d.credid=m.credid

inner join al_subject s on s.subjectid=d.subjectid where substock=@subjectid and goodsid=@goodsid

联系客服:779662525#qq.com(#替换为@) 苏ICP备20003344号-4