In GP we are always looking for subledger transactions that posted in different periods than the GL Journal entry.
Example - I have a complex SQL view that combines sub-ledger cash transactions and the Journal Entry that was created. In theory all cash receipts posted in a certain month should have corresponding Journal Entries in the same month.
I need to compare DepositGLPostingDate to ReceiptGLPostingDate - just for different periods (months). Example below.
If the dates are different but in same month - I don't want to see them - make sense?
