Joining to applying transactions can be pretty tricky, what is the actual join you are using? Should be

Fulfilling/Receiving Transaction Fields...