Matching Incremental Transactional Reports vs Snapshot Reports using TM

Summary

Matching Incremental Transactional Reports vs Snapshot Reports using TM

Content

Hi, 

This may have a solution already or may become a new feature in the future releases; but want to get your ideas first.

We've a requirement to match two sources using TM. One side holds incremental transactions(lets call it as AP Transactions); but the other side shows snapshot values as of report execution time(Vendor SoA)

This would be an easy task, only if we deal with a single period; we can easily identify matched and unmatched transactions from both AP and Vendor SoA data sources.

However, when it comes to the subsequent month load; the issue arises. The reason is, there might be some unmatched transactions in