用友t6中財務(wù)報表QM函數(shù)要怎么運(yùn)用
來源:牛賬網(wǎng) 作者:牛小編 閱讀人數(shù):12041 時間:2023-06-17
【問題現(xiàn)象】
如何取科目的借方余額或貸方余額?
【解決方案】
1、科目無輔助核算
100101現(xiàn)金-人民幣科目的明細(xì)賬如下:
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的借方余額或貸方余額,而不明細(xì)到輔助核算呢?
可是使用條件取值函數(shù)iff函數(shù)來實(shí)現(xiàn)
先得出112201科目余額的取值函數(shù)(方向選擇默認(rèn)):QM("112201",月,,,,"",,,"y","y",,)
使用iff函數(shù)設(shè)置取借方余額
邏輯表達(dá)式: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è)置取貸方余額
邏輯表達(dá)式: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”。
看到這,今天小編為大家介紹的內(nèi)容就到這里啦,上文小編整理了用友t6中財務(wù)報表QM函數(shù)要怎么運(yùn)用,不知道大家有沒有明白,如果大家還有什么疑惑的話,可以登錄牛賬網(wǎng)咨詢在線答疑老師,也可點(diǎn)擊下方鏈接領(lǐng)取相關(guān)的資料包,進(jìn)行自主學(xué)習(xí)哦!

贊