应收账款科目公式问题
1,601次浏览
编辑于2018年02月01日 16:14:28
公司用的金蝶KIS 现在要调整应收账款科目计算公式,原来的公式
=ACCT("1122","JY","",0,0,0,"")+ACCT("1124","Y","",0,0,0,"")+ACCT("2204.02|客户|1.1.01.001:2.00002","JY","",0,0,0,"")+ACCT("2204.01|客户|1.1.01.001:2.00002","JY","",0,0,0,"")+ACCT("1231.01","Y","",0,0,0,"")
由于预收账款科目为2204.01,2204.02,上面是将所有的余额进入了应收账款科目,现在要改成 (2204.01+2204。02) 如果借方有余额进入应收账款,如果贷方有余额的进入预付款项科目。跪求高人指点!