金蝶標準版報表應付預付公式如何設置?

金蝶kis標準版報表應付預付公式如下:

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

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

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

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

"預付款項"項目,應根據"預付賬款"和"應付賬款"科目所屬各明細科目的期末借方余額合計數,減去"壞賬準備"科目中有關預付款職計提的壞賬準備期末余額后的金額填列.