存貨核算結(jié)轉(zhuǎn)
發(fā)布于:2018-01-17 09:55:40
問題現(xiàn)象:此客戶的數(shù)據(jù)為U850sp版,采用先進(jìn)先出法核算,在2003年結(jié)轉(zhuǎn)到2004年時(shí)存貨期初數(shù)量很多不對(duì),大多數(shù)量是上年期初錄入的數(shù)量,可金額又結(jié)轉(zhuǎn)到下一年了
解決方案:請(qǐng)?jiān)诓樵兎治銎髦嗅槍?duì)2003年帳套執(zhí)行下面語句,修改IA_ValuationAss的入庫單的記賬日期,然后清空2004年年度帳,重新結(jié)轉(zhuǎn)即可。Update ia_valuationass set dikeepdate=ia_subsidiary.dkeepdate from IA_valuationass left join IA_Subsidiary on IA_Subsidiary.id=IA_valuationass.inid where dikeepdate<>dkeepdate and cvoutype not in '33','24','30'