Question Status

Verified
Leslie Vail asked a question on 1 Feb 2014 8:04 AM

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?

Kind regards,

Leslie

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply
Verified Answer
Leslie Vail responded on 3 Feb 2014 6:40 AM

It's OK now, nevermind

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply
Somakarpagamoorthy Kanagasabapathy responded on 3 Feb 2014 6:58 AM

What is the cause of this issue?

Note: Please mark it as verified, if this answer your question. Because this will helps to some others who experience the same.

Best Regards,

Somakarpagamoorthy K | GP Techno-Functional Consultant | Dynamics Thoughts

Reply
Dan Liebl responded on 3 Feb 2014 9:08 AM

Was it related to the currency assigned to the company?

Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

Reply
Leslie Vail responded on 6 Feb 2014 11:43 PM

It was a corrupted functional currency index in the MC40000 table. I truncated and repopulated the table, and my decimals came back.

Leslie

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply
Leslie Vail responded on 6 Feb 2014 11:44 PM

Yes, it was a bad record (or records) in the MC40000 table. I truncated it and repopulated it and it worked.

leslie

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply
Somakarpagamoorthy Kanagasabapathy responded on 7 Feb 2014 12:01 AM

Leslie thanks. Your reply will help to resolve if anyone facing the same issue.

Note: Please mark it as verified, if this answer your question. Because this will helps to some others who experience the same.

Best Regards,

Somakarpagamoorthy K | GP Techno-Functional Consultant | Dynamics Thoughts

Reply
Verified Answer
Leslie Vail responded on 3 Feb 2014 6:40 AM

It's OK now, nevermind

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply