After completing an Accounts Payable System Generated Check(APS) run, invoices still display in ‘Select AP Invoices to pay’ with a Session ID and a Document Number and the session cannot be posted or deleted.
IMPORTANT DISCLAIMER: We are providing the information in this article as a courtesy to our EWS customers. Assistance with installation or troubleshooting of 3rd party applications such as Microsoft SQL and SQL Server Management Studio falls outside of the scope of your Abila Maintenance and Support Agreement. If you should require additional assistance with your Microsoft SQL or SQL Server Management Studio, please contact your Abila Business Partner. If you do not have an assigned Abila Business Partner, you can contact Abila Sales (800-647-3863) for information on business partners in your area.
After updating EWS to 2020.2, the following error is received after being prompted to change the password:
New employees are not showing the hours accrued on the default timesheet. They are accruing hours each pay period, but it is not displayed on the default timesheet or in HR on the leave tab.
Void Session(s) created in the Classic Interface, with reverse Invoice selected, will fail to post in the Modern Interface but will display a message that two sessions were posted.
Receive (3) notice\error pop ups:
Session no longer contains any documents and cannot be posted. You cannot move all the documents to a new session. Review the documents in the session and make any necessary changes.
The Session: API:XXXX has an associated APV session that prevents posting in MIP Advance. Both sessions can be posted in MIP Fund Accounting
Attempting to disable database encryption results in error ‘NpsSMOError ExecuteNonQuery failed for Database ‘NpsSqlsys’. An exception occurred while executing a Transact-SQL statement or batch. The operation failed because an index or statistics with the name ‘idx_tblPREE_sSSN already exists’. It also puts the database in single user mode, preventing other users from subsequently logging back in
When reopening an unposted CD/cash disbursement session, there appears an error: “This Check ID XXXX has already been used for Session ID YYYY.” even though the Check number has never been used before. User is unable to reopen or edit the session to change the check number.
After upgrading MIP Fund Accounting to version 2020.2 and attempting to login the following message displays:
Cannot open database 'NpsSqlSys'. The owner of this database is not set to user 'NpsAdmin'. Change the owner of this database to 'NpsAdmin' in SQL Server. See Resolution Section.
After upgrading MIP Fund Accounting to version 2020.3 and attempting to login the following message displays:
Process FAILED. Scroll up to check the individual task status. Click Finish to exit dialog.
After clicking finish the following NpsSMOError ExecuteNonQuery failed for Database ‘NpsSqlSys’ error message is displayed and when clicking OK to the message displayed below an error displays that the upgrade was not successful.
OR
After upgrading MIP Fund Accounting to version 2020.3 and attempting to login the following message displays:
NpsSMOError ExecuteNonQuery failed for Database ‘NpsSqlSys’. An exception occurred while executing a Transact-SQL statement or batch. User does not have permission to perform this action. Contact your Technical Support representative.