速達(dá)財(cái)務(wù)系列問題處理

速達(dá)財(cái)務(wù)系列問題處理1、結(jié)帳時(shí)出納與會(huì)計(jì)有差異，但出納的數(shù)據(jù)與總分類帳里的數(shù)據(jù)是一致軟件版本：財(cái)務(wù)系列V6.0解決方法：A、出納帳進(jìn)行反引入B、select*fromaa_creditemwherecredit<>rawcreditandhappendate>'出錯(cuò)的起始日期'andhappendate<'出錯(cuò)的結(jié)束日期'andsubjectid=’銀存、現(xiàn)金或其他貨幣資金的subjectid’/*查詢憑證從表中本位幣和原幣金額不相等的記錄*/C、如果有記錄返回，則運(yùn)行updateaa_creditemsetrawcredit=creditwherecredit<>rawcreditandhappendate>'出錯(cuò)的起始日期'andhappendate<'出錯(cuò)的結(jié)束日期'andsubjectid=’銀存、現(xiàn)金或其他貨幣資金的subjectid’D、運(yùn)行完畢，在出納帳進(jìn)行引入2、在打開會(huì)計(jì)科目時(shí)，提示“你輸入的數(shù)值不規(guī)范，請(qǐng)輸入整數(shù)”軟件版本：財(cái)務(wù)系列V5.9問題分析：科目編碼太長(zhǎng)或者為空解決方法：A、select*fromal_subjectorderbysubcodeB、將會(huì)計(jì)科目進(jìn)行排序.然后看到有subcode會(huì)計(jì)編碼過長(zhǎng)的或者為空的.直接刪除或者修改就可以了.3、在初始化階級(jí)，已對(duì)某賬戶進(jìn)行了輔助核算，并錄入了該輔助核算的期初數(shù)，啟用賬套后，打開科目輔助匯總表時(shí)，發(fā)現(xiàn)期初結(jié)存金額全部顯示為0。軟件版本：財(cái)務(wù)系列（財(cái)務(wù)STD、財(cái)務(wù)PRO、財(cái)務(wù)XP）V5.8-V6.0版本解決方法：A、升級(jí)到V6.0或6.0以上版本，并對(duì)原賬套進(jìn)行修復(fù)。B、反結(jié)賬到期初，并對(duì)賬套進(jìn)行反結(jié)賬C、重新錄入輔助核算科目的期初余額，建議輸入完畢后，再運(yùn)行如下語句：Updateaa_creditemsetunclearamt=debit+creditB、啟用賬套，并進(jìn)行相關(guān)的簽字、審核、登賬、結(jié)賬等操作。4、打開某記賬憑證時(shí)，系統(tǒng)出現(xiàn)“abnormalterminalprogram”的提示信息，然后軟件自動(dòng)退出。軟件版本：財(cái)務(wù)系列（財(cái)務(wù)STD、財(cái)務(wù)PRO、財(cái)務(wù)XP）V5.8-V6.0版本解決方法：A、select*fromal_subjectwhereallsubnameisnull/*通過該查詢語句，查找會(huì)計(jì)科目表單中，是否存在全稱為空的會(huì)計(jì)科目*/B、updateal_subjectsetallsubname=''+namewhereallsubnameisnull/*把會(huì)計(jì)科目全稱為空的科目前，插入一空格，執(zhí)行該語句后，科目全稱將按觸發(fā)器自動(dòng)地進(jìn)行更新*/C、updateal_subjectsetname=ltrim(name)/*該語句可去除會(huì)計(jì)科目前的空格*/5、“初始數(shù)據(jù)錄入”的輔助核算貨品期初數(shù)量與“收發(fā)存總表”的期初數(shù)量無法對(duì)應(yīng)。產(chǎn)品信息：速達(dá)財(cái)務(wù)XP版本信息：V6.1模塊名稱：報(bào)表系統(tǒng)解決方法：SETQUOTED_IDENTIFIEROFFGOSETANSI_NULLSOFFGO/***********************************************************************************************author:awenslastupdated:2005-10-26,awensremark:***********************************************************************************************/ALTERfunctionac_cost_balance(@bnyearinteger,@bnmonthinteger,@subidinteger,@goodsidinteger)returns@local_tabtable(balanceamtnumeric(18,8),balancepricenumeric(18,8),balanceqtynumeric(18,8))asbegindeclare@initamtnumeric(18,8),@amtnumeric(18,8),@initqtynumeric(18,8),@qtynumeric(18,8),@unitpricenumeric(18,8),@tmpamtnumeric(18,8),@tmpqtynumeric(18,8),@startyearint,@startmonthint,@crntaccyearint,@crntaccmonthint,@startaccyearmonthvarchar(10),@crntaccyearmonthvarchar(10),@yearmonthvarchar(10)declare@credyearmonthbeginvarchar(10)declare@costtypeintegerdeclare@todebitintegerdeclare@IsSpecAccintegerdeclare@subjectidintegerset@initamt=0set@initqty=0set@amt=0set@qty=0set@unitprice=0set@yearmonth='190001'select@IsSpecAcc=cast(datavalueasint)fromam_sysparamwhereparamid=906orupper(name)=upper('IsUpdateFromOther')select@startyear=cast(datavalueasint)fromam_sysparamwherelower(name)='startyear'select@startmonth=cast(datavalueasint)fromam_sysparamwherelower(name)='startmonth'select@crntaccyear=cast(datavalueasint)fromam_sysparamwherelower(name)='curraccyear'select@crntaccmonth=cast(datavalueasint)fromam_sysparamwherelower(name)='curraccmonth'select@startaccyearmonth=credyearmonthfromdbo.fn_aa_getcredyearmonthstr(@startyear,@startmonth)select@crntaccyearmonth=credyearmonthfromdbo.fn_aa_getcredyearmonthstr(@crntaccyear,@crntaccmonth)select@credyearmonthbegin=credyearmonthfromdbo.fn_aa_getcredyearmonthstr(@bnyear,@bnmonth)set@subjectid=@subidselecttop1@yearmonth=m.credyearmonth,@tmpamt=isnull(liveamt,0),@tmpqty=isnull(liveqty,0)fromaa_creditemdinnerjoinaa_credmond.credid=m.credidinnerjoinal_subjectsons.subjectid=d.subjectidwheresubstock=@subjectidandgoodsid=@goodsidand(s.costtype=1ors.costtype=2)andm.credyearmonth<@credyearmonthbeginandm.origintypenotin(2501,2002)orderbybilldatedesc,m.crediddesc,itemnodescif(@yearmonth>=@startaccyearmonthor@IsSpecAcc=1)beginselect@amt=@tmpamt,@qty=@tmpqtyendelsebeginselecttop1@initamt=debit-credit,@initqty=casewhen(debit-credit<0)thencasewhen(quantity>0)then-quantityelsequantityendelsequantityendfromaa_creditemd,aa_credm,al_subjectswherem.credid=d.credidandm.credid=-2and(m.origintype<>2501andm.origintype<>2002)andd.subjectid=s.subjectidand(s.costtype=1ors.costtype=2)andd.subjectid=@subjectidandd.goodsid=@goodsidselect@amt=isnull(sum(debit-credit),0),@qty=isnull(sum(casewhen(debit-credit<0)thencasewhen(quantity>0)then-quantityelsequantityendelsequantityend),0)fromaa_creditemd,aa_credm,al_subjectswherem.credid=d.credidandm.credid=-1and(m.origintype<>2501andm.origintype<>2002)andd.subjectid=s.subjectidand(s.costtype=1ors.costtype=2)andd.subjectid=@subjectidandd.goodsid=@goodsidset@amt=@amt+@initamtset@qty=@qty+@initqtyendif(@qty<>0)set@unitprice=@amt/@qtyifnot((@unitprice=0and@qty=0and@amt=0)or(@unitpriceisnulland@qtyisnulland@amtisnull))insertinto@local_tab(balanceamt,balanceprice,balanceqty)values(@amt,@unitprice,@qty)returnendGOSETQUOTED_IDENTIFIEROFFGOSETANSI_NULLSONGO7、在進(jìn)行憑證錄入或打開會(huì)計(jì)科目時(shí)提示:“l(fā)istindexoutofbounds”。產(chǎn)品信息：財(cái)務(wù)PRO版本信息：V6.1版本模塊名稱：帳務(wù)模塊問題分析：是科目編碼列表有超出范圍的,其范圍首字段超過8.很可能是用戶自己添加.要解決這問題只能進(jìn)到后臺(tái)數(shù)據(jù)庫去查看,因軟件是無法打開科目的,在后臺(tái)查一下最大值的那些編碼解決方法:A、/*先把科目進(jìn)行下排序,由大到小地排*/select*fromal_subjectorderbysubjectid(或是subjectcode)descB、/*找出存在問題的記錄,把它刪除*/Deletefromal_subjectwheresubjected>=’查出的那個(gè)記錄’8、財(cái)務(wù)PRO5.9升級(jí)到6.10之后，發(fā)現(xiàn)“出納日記賬”的外幣金額取數(shù)錯(cuò)誤，外幣金額變成本位幣金額。產(chǎn)品信息：財(cái)務(wù)PRO版本信息：V6.10問題模塊：出納系統(tǒng)解決方法：A、反結(jié)賬到期初B、取消出納會(huì)計(jì)對(duì)帳C、刪除出納日記賬，再重新引入10、修復(fù)帳套時(shí)提示錯(cuò)誤：不能在具有唯一索引‘Uq_al_subject’的對(duì)象‘a(chǎn)l_subject’中插入重復(fù)鍵的行.dbo.al_subject適用版本：速達(dá)財(cái)務(wù)系列6.0問題分析：會(huì)計(jì)科目名稱重復(fù)解決方法：A/*查詢存在問題的記錄*/select*fromal_subjectwherenamein(selectnamefromal_subjectgroupbynamehavingcount(*