select * from  FAM_Account where  Code ='科目编号'

select * from FAM_AccountHistory where  Code ='科目编号' and shopcode='门店编号' order by Accpid

select * from FAM_CredenceBillDetail where  AccountCode='科目编号' and shopcode='门店编号'

select sum(Debit) as sumvalue from FAM_CredenceBillDetail where  AccountCode='科目编号' and shopcode='门店编号'
select sum(credit) as sumvalue from FAM_CredenceBillDetail where  AccountCode='科目编号' and shopcode='门店编号'
select sum(Debit) as sumvalue from FAM_AccountHistory where  Code='科目编号' and shopcode='门店编号'
select sum(credit) as sumvalue from FAM_AccountHistory where  Code='科目编号' and shopcode='门店编号'

若非连锁门店，则“门店编号”可填写为 0。

update FAM_AccountHistory  set debit=debit-数值,credit=credit-数值,pebalance=pebalance-数值,debit4year=debit4year-数值,credit4year=credit4year-数值 where Code='科目编号' and shopcode='门店编号' and AccPid='会计期间'

update FAM_AccountHistory  set psbalance=psbalance-数值,debit=debit-数值,credit=credit-数值,pebalance=pebalance-数值,debit4year=debit4year-数值,credit4year=credit4year-数值 where Code='科目编号' and shopcode='门店编号' and AccPid='会计期间'

exec SYS_SyncPushToShop_InsertAsSQL 门店编号,'update FAM_AccountHistory  set debit=debit-数值,Credit=Credit-数值,pebalance=pebalance-数值,Credit4Year=Credit4Year+数值 where Code=''科目编号'' and shopcode=''门店编号'' and AccPid=''会计期间''',0,10