While validating or working with Journal Reports, mainly with Private documents, do not save with different username or with admin user. Because it will save with that user and the user can't see that document with his login.
If it happened, we can update username back with backend table change/update.
Go to database -- execute below query
Formulae to create multiple queries:
=CONCATENATE("Update <ApplicationName>_RPTS Set CreatedUser ='",B1, "' where label = '",A1,"' and ReportType=1 and Private=1;")
If it happened, we can update username back with backend table change/update.
Go to database -- execute below query
Formulae to create multiple queries:
=CONCATENATE("Update <ApplicationName>_RPTS Set CreatedUser ='",B1, "' where label = '",A1,"' and ReportType=1 and Private=1;")
Update <ApplicationName>_RPTS Set CreatedUser ='<username>@<domain>' where label = '<document name>' and ReportType=1 and Private=1; Not only Journal Reports, but we can also update any of the document username using the above method. Thanks, Madhusudhan |
No comments:
Post a Comment