|
|
此文章由 蓝咖啡豆 原创或转贴，不代表本站立场和观点，版权归 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 编辑 ] |
|
【全部更新完毕】大美西澳 记我那6000公里从南到北的WA行 (2019-8-9) aussi 
再战月饼--五仁，莲蓉，枣泥传统月饼 (2007-9-20) datou2z 
发表于 2010-11-15 13:12
