用友-应收应付重分类公式设置

关于什么是重分类请自行百度，以下只介绍相关公式设置

情况一、应收应付类科目无下级明细，每个科目单一辅助核算，比如：

UFO公式设置：（以下公式适用于U8V11.1）

应收账款期末=应收期末借方+预收期末借方

应收账款期末=QM("1122",月,"借",,,"","",,,,)+QM("2203",月,"借",,,"","",,,,)

预付账款期末=应付期末借方+预付期末借方

预付账款期末=QM("2202",月,"借",,,"","",,,,)+QM("1123",月,"借",,,"","",,,,)

应付账款期末=应付期末贷方+预付期末贷方

应付账款期末=QM("2202",月,"贷",,,"","",,,,)+QM("1123",月,"贷",,,"","",,,,)

预收收账款期末=应收期末贷方+预收期末贷方

预收账款期末=QM("1122",月,"贷",,,"","",,,,)+QM("2203",月,"贷",,,"","",,,,)

情况二、应收应付类科目无下级明细，科目多辅助核算，比如：

针对多辅助核算的公式设置如下：

最终公式如下：

应收账款期末=QM("1122",月,"借",,,"","",,,"t",)+QM("2203",月,"借",,,"","",,,"t",)

情况三、应收应付类科目有下级明细科目，且明细科目的辅助核算设置不一样，比如：

上图中122102这个2级科目下的3级明细中，有的设置了个人往来辅助，有的却没有设置，此时就不能直接取122102的某一个方向余额，这样取出来是不正确的，应该取3级明细的和。

错误的公式：

QM("122102",月,"借",,,"","",,,,) 

正确的公式：

QM("12210201",月,"借",,,"","",,,,)+QM("12210202",月,"借",,,"","",,,,)+QM("12210203",月,"借",,,"","",,,,)+QM("12210204",月,"借",,,"","",,,,)+QM("12210205",月,"借",,,"","",,,,)