Hi, I'm trying to join cm20200 with gl20000. I need to see which checkbook entries are missing from the GL cash account. I can get close, but I keep running into non unique fields to join on. I've used case statements to try and cut the data differently. They help, but generally lead to a one to many. Any suggestions on how to trace an entry from cm20200 to gl20000 that will cover all the different types of cm20200 possibilities?
tthanks!