庫(kù)存存貨對(duì)賬專題用友軟件股份有限公司高斌2008年5月11日概述庫(kù)存與存貨對(duì)帳貨位卡片表和貨位匯總表對(duì)賬帳表對(duì)賬庫(kù)存存貨對(duì)賬（業(yè)務(wù)）前提：庫(kù)存取自Rdrecord/s表數(shù)據(jù)；存貨取自Ia_subsidiary表數(shù)據(jù)庫(kù)存數(shù)據(jù)是業(yè)務(wù)發(fā)生時(shí)的單據(jù)記錄和數(shù)量統(tǒng)計(jì)；存貨數(shù)據(jù)是客戶根據(jù)業(yè)務(wù)核算的需要對(duì)庫(kù)存數(shù)據(jù)的分期間統(tǒng)計(jì)庫(kù)存存貨模塊當(dāng)月全部結(jié)帳（期末處理后月末結(jié)帳前）存貨模塊沒(méi)有沒(méi)記帳單據(jù)存貨采用出庫(kù)單進(jìn)行核算提示：直運(yùn)業(yè)務(wù)由于不涉及庫(kù)存，會(huì)造成對(duì)賬不平。期初對(duì)賬對(duì)賬范圍：進(jìn)行成本核算的倉(cāng)庫(kù)的存貨（warehouse.bincost=1）有數(shù)據(jù)權(quán)限的期初標(biāo)識(shí)。存貨參與對(duì)賬的期初期間的非暫估單據(jù)，庫(kù)存主要是期初標(biāo)識(shí)的單據(jù)（rdrecords.bisstqc=1）提示：1、按存貨核算可能會(huì)影響對(duì)賬2、870以上增加了按自由項(xiàng)核算，對(duì)賬期間自由項(xiàng)因素是要忽略掉的3、87以前版本通過(guò)試圖對(duì)賬，87以上直接按原單據(jù)進(jìn)行4、期初主要特點(diǎn)？？日常對(duì)賬對(duì)賬范圍：進(jìn)行成本核算的倉(cāng)庫(kù)的存貨（warehouse.bincost=1）有數(shù)據(jù)權(quán)限的和總帳數(shù)據(jù)對(duì)比庫(kù)存非期初的單據(jù)非假退料非預(yù)留代管業(yè)務(wù)不參與對(duì)賬實(shí)例分析問(wèn)題現(xiàn)象：庫(kù)存存貨對(duì)賬，demo對(duì)賬平衡，庫(kù)管員對(duì)賬不平，庫(kù)管員擁有所有權(quán)限庫(kù)存貨位賬對(duì)賬前提：庫(kù)存賬取自Rdrecord/s數(shù)據(jù)；貨位賬取自InvPosition數(shù)據(jù)貨位卡片賬不包括貨位調(diào)整單據(jù)庫(kù)存賬包括期初單據(jù)單據(jù)，但不包括假退料有貨位管理的倉(cāng)庫(kù)業(yè)務(wù)單據(jù)都指定貨位（87與以前版本有差異，單據(jù)審核時(shí)有選項(xiàng)控制是否檢查貨位）特點(diǎn)：千錯(cuò)萬(wàn)錯(cuò)都是InvPosition的錯(cuò)實(shí)例分析實(shí)例1倉(cāng)庫(kù)編碼04，存貨編碼004，貨位編碼01，對(duì)應(yīng)的貨位卡片表和貨位匯總表不一致實(shí)例2999演示帳套貨位卡片不一致,02倉(cāng)庫(kù),010104存貨帳表對(duì)賬庫(kù)存賬表類型：?jiǎn)螕?jù)賬，如出入庫(kù)流水帳，代管賬，跟蹤表類存貨賬，特征：期初＋本期入－本期出庫(kù)＝結(jié)存，如庫(kù)存臺(tái)帳實(shí)例分析實(shí)例存貨查詢現(xiàn)存量和庫(kù)存臺(tái)帳、收發(fā)存不一致可能原因：查詢庫(kù)存選項(xiàng)：審核或保存時(shí)修改現(xiàn)存量查詢庫(kù)存期初：保證所有記錄均已審核年結(jié)問(wèn)題：870年結(jié)沒(méi)有更新年結(jié)補(bǔ)丁，如果在上年做了下年的業(yè)務(wù)單據(jù)可能會(huì)出現(xiàn)問(wèn)題實(shí)例分析實(shí)例采購(gòu)結(jié)算余額表和未完成業(yè)務(wù)明細(xì)金額不一致存貨匯總表和收發(fā)存對(duì)賬前提：入庫(kù)匯總表的數(shù)據(jù)來(lái)自于IA_Subsidiary（包括未記賬單據(jù)特殊）非期初的單據(jù)非服務(wù)屬性的存貨期初數(shù)據(jù)主要是imonth=0和以前年度的非期初單據(jù)明細(xì)賬和總帳對(duì)賬數(shù)據(jù)來(lái)源：明細(xì)賬來(lái)源Ia_subsidiary,總帳數(shù)據(jù)來(lái)源ia_summary明細(xì)賬匯總數(shù)據(jù)和總帳對(duì)應(yīng)數(shù)據(jù)直接比較存貨對(duì)賬常見(jiàn)問(wèn)題明細(xì)賬和總賬不一致總帳入出庫(kù)合計(jì)數(shù)據(jù)和結(jié)存數(shù)據(jù)不等年結(jié)期初對(duì)賬不成功年結(jié)上下年度數(shù)據(jù)不一致庫(kù)存收發(fā)存匯總表和存貨收發(fā)存不一致小工具（單據(jù)來(lái)源不一致）簡(jiǎn)單對(duì)賬（來(lái)源對(duì)比）selectcoutno_id,ia_subsidiary.cpzidasiacpzid,ia_ensubsidiary.cpzidasencpzid,coutsysname,coutsign,*fromgl_accvouchleftjoinia_subsidiaryongl_accvouch.coutno_id=ia_subsidiary.cpzidleftjoinia_ensubsidiaryongl_accvouch.coutno_id=ia_ensubsidiary.cpzidwhere(ia_subsidiary.cpzidisnullandiperiod<>0)and(ia_ensubsi