Difference in amount for the same tnx

Question

I am comparing two tnx files from two different systems. I was able to find out tnxs which are not common/missing in each system. Now i am stuck and need to find out tnxs which are common/present in both the systems but have different amounts. Like in one system for the same tnx, tnx vlaue is different in system A & system B.

atcodedog05 · Answer

Hi @modiuttam88

Another method if you want all rows output.

Workflow:

1. Using join multiple since it always does outer join.

2. Using formula to compare and flag accordingly.

Hope this helps : )

amt match all.yxmd

atcodedog05 · Answer

Hi @modiuttam88

Here is how you can do it. Join on reference number and compare amount in formula.

Workflow:

Hope this helps : )

amt match.yxmd

messi007 · Answer

@modiuttam88,

You can do this with a join and filter

Attached a sample workflow.

Hope this helps !

Regards,

Compare_20210810.yxmd