The problem report was built with a row set listing the full range of main accounts (+Main = [????], for ease of maintenance), and a column set which included DESC and ACCT columns. Drilling down on the main report page for the account list displayed the account string and correct period amounts, but some of the account descriptions were missing.
The same report run for the prior month displayed all of the account descriptions.
Drilling down on various individual accounts revealed that those not showing descriptions each had only unposted transactions in the current month (for comparison, accounts with both posted and unposted transactions had their descriptions displayed)
When the open batches were posted, the report displayed all of the account descriptions.
Every once-in-a-while we receive a call from a client who launched an application, but the application didn't show up on their screen. They confirmed in the taskbar that the application was running. However, the window was not visible on their screen.
If you use a secondary monitor, and/or if you operate within a remote desktop environment, you may have experienced this issue. When a secondary monitor is disconnected, or the display settings are altered, sometimes applications will still operate as if nothing had changed with the monitor or display. The window opens in an "imaginary" place off to the side, where that monitor used to be.
Here are simple steps to move an off-screen window back to your screen:
1. Make sure the application is selected (choose it in the taskbar, or use the ALT-TAB keys to select it).
2. Type and hold down ALT-SPACE, then type M. (IMPORTANT NOTE: If you're working on a remote desktop or cloud, use ALT-DELETE instead if ALT-SPACE.)
3. Your mouse pointer will change to have 4 arrows.
4. Use the arrow keys on your keyboard to move the window back onto your screen.
Some tips to avoid this happening in the first place:
-- Move open windows to your primary monitor before disconnecting the secondary monitor.
-- If shutting down, do so before disconnecting the secondary monitor.
-- When working in a remote desktop, do not disconnect from the remote desktop using the "X" key at the top. Instead, close all open applications, and then go to the Start menu and select "Log Out". (This is a good practice in general, as failure to log out of a remote session could cause several other problems.)
We had a recent error message come up when attempting to set the default company within management reporter. The message stated the following:
"Microsoft Management Reporter 2012 error when you sign in to a company: “The connection to the Microsoft Dynamics GP database failed.”
The sa user was still able to access the companies, yet any other GP user was not. Access rights were confirmed for both the GP users and domain users within Management Reporter.
In researching this error the following cause was discovered:
The server name that is listed in the ODBC on the client computer that connects to GP has a different name for the SQL Server in it versus what is listed in the Company Settings in Management Reporter.
The following link provides instructions on how to correct this situation. Once we performed these steps all the users previously setup in Management Reporter were able to access their companies.
One of our clients called for assistance with a receivables batch which refused to post. GP did not return any error messages, and the user had sufficient permissions to post this batch. The DYNSA user was able to post this batch in the test company, but not in the live company. When posting was attempted GP briefly displayed the posting status window and returned to the batch entry window without making any changes.
No errors were found in the dex_sql log or a SQL trace.... but there was a lock on the PM10000 table held by another user. Once this user logged out of GP, the DEX_LOCK table cleared and the batch posted successfully.
You can use the following SQL command to view the list of active GP users, and any locks held at the time you run this query:
FROM DYNAMICS..ACTIVITY A
LEFT JOIN tempdb..DEX_LOCK L
ON A.SQLSESID = L.session_id
ORDER BY SQLSESID;
Try having any users with a lock close all windows, and if the lock persists, have them log out of GP.
If you're like most companies, your current quality management system is a cumbersome manual processes that involves a vast array of spreadsheets. You're constantly wrestling with how to collect the many types of data you need - and after that, how to organize the data so that it can be reviewed and communicated effectively.
I recently saw a demonstration of a simple, yet powerful solution to the complexities of quality management - and I was really impressed! The software is called Quality Essentials Suite.
Things that really stood out to me about this solution:
• The interface is extremely user-friendly, and is designed with tablets in mind.
• It has the ability to handle multiple types of test data (numbers, Boolean, date and time, pre-defined lists, text, document paths)
• Standard documentation and forms are easily created, and just as easily recalled as historical records
• Test data can be linked to serial and lot numbers, as well as purchasing and sales transactions for reference
• This software is available for integrated and non-integrated deployment with an existing Enterprise solution
• The possible benefits are not limited to manufacturers and distributors - this could be a great solution for any company interested in tracking and improving business processes
If you're ready to realize the true benefits of quality management without all of the rigmarole, I would encourage you to check out the Quality Essentials Suite - and let us know what you think!