問(wèn)題描述:在使用用友t3普及版(包含部分標(biāo)準(zhǔn)版,不是通過(guò)項(xiàng)目管理做流量表)時(shí),在查詢現(xiàn)金流量憑證時(shí)比較麻煩 比如:這月有500張憑證,但是有200張涉及到現(xiàn)金和銀行的憑證, 正常情況下,我們?cè)谔钪茟{證的同時(shí)就順便指定了,現(xiàn)金流量的項(xiàng)目, 但是有時(shí)候由于誤操作,或不小心, 有的憑證在沒(méi)有制定流量的情況下就保存了, 憑證只是指定了部分流量。 當(dāng)月底發(fā)現(xiàn)流量表和負(fù)債表,或余額表核對(duì)不上時(shí),要查詢那些憑證沒(méi)有指定流量,在沒(méi)有出納的情況下,就要一張一張的查看,這樣太浪費(fèi)時(shí)間而且容易遺漏。 解決方案: 臨時(shí)解決,變通的方法如下: 1.進(jìn)入數(shù)據(jù)庫(kù)的查詢分析器,建立一個(gè)視圖,如下代碼: create view dbo.yqy_GL_CashTable as select GL_CashTable.i_id as 流量表自動(dòng)編號(hào),GL_CashTable.iPeriod as 流量表會(huì)計(jì)期間,GL_CashTable.iSignSeq as 流量表憑證類別排序號(hào),GL_CashTable.ino_id as 流量表憑證編號(hào),GL_CashTable.inid as 流量表憑證行號(hào),GL_CashTable.cCashItem as 流量表現(xiàn)金項(xiàng)目,GL_CashTable.md as 流量表借方金額,GL_CashTable.mc as 流量表貸方金額 , ( str(GL_CashTable.iPeriod) + str(GL_CashTable.iSignSeq) + str(GL_CashTable.ino_id) + str(GL_CashTable.inid) ) as 流量表期間憑證類別排序號(hào)憑證編號(hào)憑證行號(hào) from GL_CashTable 2. 通過(guò)數(shù)據(jù)庫(kù)憑證明細(xì)賬的表,和視圖做比對(duì),查看哪些憑證的那些分錄還沒(méi)指定,流量,代碼如下: select GL_accvouch.iperiod as 會(huì)計(jì)期間, GL_accvouch.isignseq as 憑證類別排序號(hào) , GL_accvouch.ino_id as 憑證編號(hào) , GL_accvouch.inid as 憑證行號(hào) , GL_accvouch.ccode as 科目編碼 , GL_accvouch.md as 借方金額 , GL_accvouch.mc as 貸方金額 , GL_accvouch.ccode_equal as 憑證對(duì)方科目編碼 , ( str(GL_accvouch.iperiod) + str(GL_accvouch.isignseq) + str(GL_accvouch.ino_id) + str(GL_accvouch.inid) ) as 期間憑證類別排序號(hào)憑證編號(hào)憑證行號(hào) from GL_accvouch where str(GL_accvouch.iperiod) + str(GL_accvouch.isignseq) + str(GL_accvouch.ino_id) + str(GL_accvouch.inid) not in(select 流量表期間憑證類別排序號(hào)憑證編號(hào)憑證行號(hào) from yqy_GL_CashTable ) and GL_accvouch.iperiod = 2 and ( GL_accvouch.ccode like \'1002%\' or GL_accvouch.ccode like \'1001%\' ) order by 期間憑證類別排序號(hào)憑證編號(hào)憑證行號(hào) 就可以直觀的查看結(jié)果了。 |