Hi @Andy BerntsonIf it is just the document date that is in the future the only implications are that the invoice will not show up in searches that include a document date qualifier, and you will not be able to delete the invoice until a fiscal period for that future date is setup. But, the document date can be updated through SQL. I don't have experience with this so someone better versed in SQL will have to advise on how to do this.To prevent this from happening again, in the PSTL there is a tool called Doc-Date Verify that prevents document dates from being entered that do not fall within a fiscal period that has already been set up.
EXECUTE dbo.uspSearchAllTablesForAnything @ValuePatternToSearchFor = N'%181137';
Value to search for; can be alpha, numeric, timestamp, or GUID.Column name pattern;Table name pattern;Search In XML fields: 0 = No (default); 1 = YesShow Full Row Results: 0 = No (default); 1 = YesNumber Of Rows To Show: Max number of full rows to display
If you've found this thread useful, dive deeper into User Group community content by role