Here's my question:
I have one company in an installation that is not showing decimals in any of the SmartList currency fields for all SmartLists. This is only one company having this problem. It is not showing decimals for all users from all workstations, SmartLists built with SmartList Builder are fine. All other companies (including Fabrikam, are fine).
It is not showing decimals if you launch GP locally from the SQL console, nor if you access it using Terminal Server. All workstations are using the same operating system, version and build of Dynamics (as well as the same modules).
The export to Excel shows the decimals and the raw table data is fine.
I have a test company (which is a copy of production). I restored the current production company over the test company. Now, the test company is not showing decimals either. So, we know it's a problem with the company data itself, but what?
They are running GP2013, after the year-end tax update. The workstations are on Windows 7-64, the server is running SQL 2012 on Server 2012.
The only thing that happened between when it did work and now is that the pathnames where changed on one of their Integrations. It's looking at a .csv file, so I can't imagine how that could have made a difference.
Here's what I've done so far (in no particular order). Some of these I knew were worthless, but for some I had hope:
1. Check Links on everything (the old standby).
2. Database Maintenance Utility
3. Recreating the underlying views from a company that works
4. Ran Maintenance on SmartList Builder (these aren't SmartLists built with SLB, but I figured it wouldn't hurt)
5. Ran a repair on the wkst install (also didn't expect that to work, but hey, why not)
6. Removed the Forms & Reports dictionaries (they are shared)
7. Checked the Regional Settings (also shouldn't matter, and it didn't, it was correct)
8. Checked the currency setup (they are not using Multicurrency, however)
9. Removed the .vba
10. Removed all custom dictionaries
11. Checked the DU* files for discrepancies
12. Checked the ASI* tables for unusual entries
13. Restored the production company data over Fabrikam, still didn't work.
14. Exported it to Excel, all was fine, decimals were there.
15. Looked at the raw data in SQL, all was fine, five decimals with data.
That's it. I feel certain that the answer is right in front of me, but I am blind to it at this point.
I'm in a quandary, any ideas?
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * email@example.com
It's OK now, nevermind
What is the cause of this issue?
Note: Mark it as verified If my answer solved your problem. Because this will helps to some others who having the same problem.
Somakarpagamoorthy K | Dynamics Thoughts
Was it related to the currency assigned to the company?
Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com
It was a corrupted functional currency index in the MC40000 table. I truncated and repopulated the table, and my decimals came back.
Yes, it was a bad record (or records) in the MC40000 table. I truncated it and repopulated it and it worked.
Leslie thanks. Your reply will help to resolve if anyone facing the same issue.