| 问题版本: |
2-财务通标准版2005 |
问题模块: |
2-UFO报表 |
| 所属行业: |
0-通用 |
问题状态: |
2-用友渠道员工帐户 |
| 关 键 字: |
预付,预收,应付,应收 |
适用产品: |
2 |
| 补 丁 号: |
|
开放状态: |
2-用友渠道员工帐户 |
| 原问题号: |
|
提交时间: |
2006-3-27 17:02:00 |
| 问题名称: |
报表取数 |
| 问题现象: |
在总账系统中只使用应收账款科目,没有使用预收账款科目,但在资产负债表中用应收账款的借方期末余额反映应收账款的期末数,应收账款的贷方期末余额反映预收账款的期末数，设公式QM("113",月,"借",,,,,,,,)取出来的数为 ，往来管理—客户科目余额表借方期末余额数为14011905.38；设公式QM("113",月,"贷",,,,,,,,)取出来的数为 ，往来管理—客户科目余额表贷方期末余额数为20212625.95。 联系人：袁浩容联系方式：13669542283 |
| 原因分析: |
你可以使用iff函数解决, 比如应收账款可以这样设定iff(QM("113",月,"借",,2005,"001",,,"y",,)-QM("113",月,"贷",,2005,"001",,,"y",,)>0,QM("2121",月,"借",,2005,"001",,,"y",,)-QM("2121",月,"贷",,2005,"001",,,"y",,),0) 预付账款iff(QM("113",月,"借",,2005,"001",,,"y",,)-QM("113",月,"贷",,2005,"001",,,"y",,)<0,QM("2121",月,"借",,2005,"001",,,"y",,)-QM("2121",月,"贷",,2005,"001",,,"y",,),0) 在这里年初余额需要手工录入，或者可以用批处理实现 |
| 解决方案: |
你可以使用iff函数解决, 比如应收账款可以这样设定iff(QM("113",月,"借",,2005,"001",,,"y",,)-QM("113",月,"贷",,2005,"001",,,"y",,)>0,QM("2121",月,"借",,2005,"001",,,"y",,)-QM("2121",月,"贷",,2005,"001",,,"y",,),0) 预付账款iff(QM("113",月,"借",,2005,"001",,,"y",,)-QM("113",月,"贷",,2005,"001",,,"y",,)<0,QM("2121",月,"借",,2005,"001",,,"y",,)-QM("2121",月,"贷",,2005,"001",,,"y",,),0) 在这里年初余额需要手工录入，或者可以用批处理实现 | |
