You’re offline. This is a read only version of the page.
185
When i pull up my GP2010 Smartlist, the financial information appears as integer format. ie: the decimal values are gone.
a Credit Amount which should be $67.46 appears as $67
My client is on GP2010 latest SPK running SQL2005
The client has multiple companies and the problem only occurs in one of their companies.
A
*This post is locked for comments
Hi Leslie,
I've run into this twice now and in both cases it was an issue with multicurrency. In one case the currency decimals were set wrong and in another case they had just upgraded, MC turned on as a result, and they were using the wrong currency id. I would start by checking out the MC setup and the currency ID assigned to the transactions.
Mike
Using Query Analyzer, access the Dynamics database and run the following statement and take note of the value in the CurrIndx column:
SELECT * from MC40200
Run the following script against the Company database with the problem and take note of the value in the FunCrIdx column:
SELECT * from MC40000
Verify the FunCrIdx in MC40000 is the same value as the CurrnIdx for Z-US$ in MC40200. If not, update MC40000 using the following statement against the Company database:
UPDATE MC40000 SET FunCrIdx=xxx
(where xxx = the value from the CurrnIdx column in the MC40200 for Z-US$)
yes I tried different user and wrkstation...
we have opened ticket w/ MS...
Thx for your reply - Appreciated...
--Ben
just a thought, i remember there was an article on how to refresh smartlist I am not sure if its still applicable on GP2010.
BTW, does the problem occur in any workstation? any user?
Thanks Michael... I tried this already but they all have same Ceurrency...if you think o fanything else let me know... also this is not just on the financials(series) Smartlists for that company. All Series in the Smartlist behave this way.... it is for the financial data... ie: currency... I should have clarified.
Thanks
--Ben
Just a thought. Is that company using a different currency code than the rest?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (