--1>.计算汇总数据

--判断出汇总后的数据差多少钱,比如差1元,

 select b.fdc,sum(a.fbeginbalance) 

 from t_balance a join t_account b on a.faccountid=b.faccountid  

 ---where a.fyear=xxxx and a.fperiod=yy and a.fdetailid=0 and a.fcurrencyid=0 and b.fdetail=1 group by b.fdc

 where a.fyear=2017 and a.fperiod=1 and a.fdetailid=0 and a.fcurrencyid=0 and b.fdetail=1 group by b.fdc

--------------------------------------

--2>.查询明细数字

--在记录中找到期初会计科目为1元的,分录

 select a.* ,b.* 

 from t_balance a join t_account b on a.faccountid=b.faccountid  

 ---where a.fyear=xxxx and a.fperiod=yy and a.fdetailid=0 and a.fcurrencyid=0 and b.fdetail=1 group by b.fdc

 where a.fyear=2017 and a.fperiod=1 and a.fdetailid=0 and a.fcurrencyid=0 and b.fdetail=1 group by b.fdc

----------------------------------------

--3.1>.进入金蝶的科目初始数据中,在哪个差的会计科目中填写差额,比如1元

--3.2>.点击,保存按钮后,试算结果肯定不平衡,

--3.3>.在将刚才补充的那个科目金额,比如1元,删除,

--3.4>点击,保存按钮后,再次试算平衡后,

--3.5>结束初始化,发现可以结束了

-----------------------------------------

--以下内容为从网络搜集的sql语句,参考使用,这里感谢作者的思路

DELETE from t_balance where FCurrencyID = 0

INSERT INTO

[t_Balance]([FYear], [FPeriod], [FAccountID],[FDetailID],[FCurrencyID],[FBeginBalanceFor],[FDebitFor],[FCreditFor],

[FYtdDebitFor], [FYtdCreditFor],[FEndBalanceFor],[FBeginBalance], [FDebit], [FCredit], [FYtdDebit], [FYtdCredit], [FEndBalance], [FFrameWorkID])

SELECT [FYear], [FPeriod], [FAccountID],[FDetailID],0, [FBeginBalanceFor], [FDebitFor], [FCreditFor], FYtdDebitFor],

[FYtdCreditFor], [FEndBalanceFor],[FBeginBalance], [FDebit], [FCredit],[FYtdDebit],[FYtdCredit], [FEndBalance], [FFrameWorkID]

FROM [t_Balance]

WHERE FCurrencyID =1

--------------------------------------------