問(wèn)題現(xiàn)象：用友U8年結(jié)問(wèn)題之供銷鏈年度結(jié)轉(zhuǎn)，結(jié)轉(zhuǎn)到存貨明細(xì)賬時(shí)，提示存貨結(jié)轉(zhuǎn)失?。?/p>

問(wèn)題原因：輔助計(jì)價(jià)表ia_valuationass有問(wèn)題，存在出庫(kù)和入庫(kù)金額都為null的記錄，可用以下語(yǔ)句查詢：select * from ia_valuationass where iIPrice is null and iOPrice is null

解決方法：根據(jù)存貨明細(xì)賬ia_subsidiary，修改輔助計(jì)價(jià)表ia_valuationass，可參考以下語(yǔ)句：select * from ia_subsidiary  where id in (select inid from ia_valuationass where iIPrice is null and iOPrice is null)  and cvoutype not in ('24','30')