Has anyone experienced an issue where the statement date gets populated incorrectly in the Bank Statement Interface (within the application)? We have processes that automatically load cleared check bank statements into Oracle and then auto reconciles those statements. We have one specific bank account that gets loaded into our interface table with a statement date that is usually off by 1 year. For example, if the creation date of the file is 5/18/09, the statement date will be 7/2/08. This creates a GL error because business for 7/08 is not open.
It is very inconsistant and I cannot reproduce it on test instances. It only happens with that one bank account, and occassionally statements with that bank account number/ID will pass through and auto reconcile without any problems.