|
|
此文章由 蓝咖啡豆 原创或转贴，不代表本站立场和观点，版权归 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 编辑 ] |
|
2015 蓝山秋天游,仙境般的雾中的红叶美景 更新几张LD的照片 (2015-5-1) jmms_smmj 
发表于 2010-11-15 13:12
