|
|
此文章由 蓝咖啡豆 原创或转贴，不代表本站立场和观点，版权归 oursteps.com.au 和作者 蓝咖啡豆 所有！转贴必须注明作者、出处和本声明，并保持内容完整
Need more details for needs.
The common data between supplier statement and aging report could be the supplier id or short description. It seems VLOOKUP would be helpful for data pool with common line items. Just be curious because your aging report is cascaded (period range) value of total outstanding payments by certain cutoff date, whilst the supplier statement is the transaction movement summary for each account. Are they really matchable?
The other challenge are those non match items when you use VLOOKUP, the if condition clause can eliminate the null item.
If two statements are converted from the same system, you may run two reports including suppliers with zero value item for both and simply run A to Z sorting to range 2 source data and consolidated them shoulder by shoulder.
[ 本帖最后由 蓝咖啡豆 于 2010-11-16 00:35 编辑 ] |
|
kimi 建房帖 (2009-10-22) kimi 
阳光熊穷游欧洲记/更新163楼 开始更新圣诞游 (2010-2-23) sunshinybear 
发表于 2010-11-15 13:12
