發(fā)布時間:2024-11-18
特價活動:>>>> 用友U8、T6、T+、T3軟件產(chǎn)品4折優(yōu)惠,暢捷通T+cloud、好會計、易代賬、好業(yè)財、好生意云產(chǎn)品6-8折優(yōu)惠。
【問題現(xiàn)象】
如何取科目的借方余額或貸方余額?
1、科目無輔助核算
100101現(xiàn)金-人民幣科目的明細賬如下:
QM函數(shù)參照設(shè)置如下:
即函數(shù)QM("100101",月,"借",,,,,,"y","y",,)取值結(jié)果為“14463.99”。
QM函數(shù)參照設(shè)置如下:
即函數(shù)QM("100101",月,"貸",,,,,,"y","y",,)取值結(jié)果為 空。
2、科目有輔助核算
112201應(yīng)收賬款-人民幣科目余額表如下:
如果按照無輔助核算的方法設(shè)置
函數(shù)QM("112201",月,"借",,,"",,,"y","y",,)取值結(jié)果“78701.00”,即客戶余額為借方的余額合計:78120.00+581.00=78701.00
如果函數(shù)設(shè)置時,勾上“按客戶編碼匯總”
即函數(shù)QM("112201",月,"借",,,"",,,"y","y","t",)取值結(jié)果仍然是“78701.00”
那么如何設(shè)置函數(shù),取112201的借方余額或貸方余額,而不明細到輔助核算呢?
可是使用條件取值函數(shù)iff函數(shù)來實現(xiàn)
先得出112201科目余額的取值函數(shù)(方向選擇默認):QM("112201",月,,,,"",,,"y","y",,)
使用iff函數(shù)設(shè)置取借方余額
邏輯表達式:QM("112201",月,,,,"",,,"y","y",,)>0
條件真值:QM("112201",月,,,,"",,,"y","y",,)
條件假值:0
即函數(shù)IFF ( QM("112201",月,,,,"",,,"y","y",,)>0,QM("112201",月,,,,"",,,"y","y",,),0 )取值結(jié)果為 空。
使用iff函數(shù)設(shè)置取貸方余額
邏輯表達式:QM("112201",月,,,,"",,,"y","y",,)<0
條件真值:-QM("112201",月,,,,"",,,"y","y",,)
條件假值:0
即函數(shù)IFF ( QM("112201",月,,,,"",,,"y","y",,)<0,-QM("112201",月,,,,"",,,"y","y",,),0 )取值結(jié)果為 “146806.14”。
客服電話:400-665-0028
關(guān)鍵字:用友財務(wù)軟件,暢捷通軟件,財務(wù)軟件,進銷存軟件,U9官網(wǎng),用友U8,用友T1,用友T+,用友T3,用友T6,暢捷通好會計,好生意,智+好業(yè)財,用友培訓服務(wù)售后公司,暢捷通運營培訓服務(wù)公司
版權(quán)所有:用友暢捷通軟件 Copyright © 2024 All rights reserved.