金蝶標準版報表應(yīng)付預(yù)付公式如何設(shè)置?

金蝶kis標準版報表應(yīng)付預(yù)付公式如下:

應(yīng)付賬款項目取應(yīng)付賬款的貸方金額加上預(yù)付賬款的貸方金額;(ACCT("1123","DY","",0,0,0,"")+ACCT("2202","DY","",0,0,0,"")

預(yù)付賬款項目取預(yù)付賬款的借方金額加上應(yīng)付賬款的借方金額;公式為ACCT("1123","JY","",0,0,0,"")+ACCT("2202","JY","",0,0,0,"")

有計提壞賬準備的,上述公式中還應(yīng)當減去相應(yīng)的壞賬準備金額.

、"應(yīng)付賬款"項目,應(yīng)根據(jù)"應(yīng)付賬款"和"預(yù)付賬款"科目所屬各明細科目的期末貸方余額合計數(shù)填列;

"預(yù)付款項"項目,應(yīng)根據(jù)"預(yù)付賬款"和"應(yīng)付賬款"科目所屬各明細科目的期末借方余額合計數(shù),減去"壞賬準備"科目中有關(guān)預(yù)付款職計提的壞賬準備期末余額后的金額填列.