web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Checklinks - Multicurr...
Microsoft Dynamics GP (Archived)

Checklinks - Multicurrency Setup Table

(0) ShareShare
ReportReport
Posted on by Community Member

We recently enabled multicurrency management for some new companies and found out we needed to run checklinks against the setup tables. Unfortunately, our primary company (single currency) has millions of transactions over the past 10+ years stored in the system.

Are the steps for the stored procedures and various GP modules/series order documented when this process is executed?  The "Percentage Complete" only shows the percentage for the file/series that is actively processing and there is no "Overall Percentage Complete".   This process has been running for 56 hours and we are on "PM Paid Transaction History File" after a good 15 hours running of the "PM Distribution History File".  The screen shows "0%" but is otherwise cycling through transactions and I fear we have another 15+ hours ahead of us. It is Monday and we decided to "roll the dice" last night and now users are unable to get into the system.

Would it help things if I just did a quick SQL update against this table to set the currency for all records or is this checklinks process really the only way?

Finally, I fully expected my session to “freeze” after the final series completes, signifying the final step - report generation; which was set to output to the screen.  When this occurs, there is no percentage complete displayed on the screen as the report generation process initiates for me to gauge activity, but I would like to have some more assurances that it is okay to let users back into the system 

Looking for some light at the end of this tunnel - if you can call it a "tunnel"! 

Thank you for any insight!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Ryan,

    Did you actually enabled MC on the LIVE system  ? Have you tested prior the impact on the system when enabling MC ? MC is a system wide option that affects all the GP companies, including the ones you don't meant to use MC for initially..

    Usually this kind of feature isn't enable straight without permforing some tests in a 'cloned' environment, as the changes on the existing data can have tremendous side-effects in all the modules in GP..

    There is no way you can enable this by running some SQL scripts from the background, as MC has its implication in many modules (& touches severals tables consequently).

    Your partner should have warned you about before starting the whole process.

  • Community Member Profile Picture
    Community Member on at

    Béat,

    Thank you for your response.  Yes, MC was enabled and checklinks against the MC Setup Table was performed as per documented.  I understand the process and the best practices concerning dev/test environments and the far reaching impact of MC within GP. My inquiry is specifically concerning the lack of an "Overall Progress" or some documented or identified progression so that this type of maintenance and time-frame required can be estimated.

    A side comment would be that: while I respect and understand 'Check Links', when enabling MC for a company with only a single currency defined as functional & reporting, this approach of transaction-by-transaction inspection, calculation and record committed is extremely inefficient and likely unnecessary. Isn't this very CL process something that is enabling MC "by running some SQL scripts from the background"? Perhaps it is just me, but there is no reason I can think of to calculate any exchanges or inspect transaction level details, just set the default currency and rate tables across the tables impacted when MC is enabled.

    My question still remains largely unanswered, "Are the steps for the stored procedures and various GP modules/series order documented when this process is executed?"

    Many thanks!

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Ryan,

    I understand your concern.. however you'll hardly find any detailed technical documentation about the reconcile process.. since Microsoft doesn't publish this (not that I'm aware of at least).. You'd have to run a SQL trace in the background while running a limited reconcile to find out what happens behind the curtains..

    This applies for Check-links too of course.. Those processes perform deep validation in several tables that do write eventually data corrections, and that's why as a precaution you should always have a full backup before starting it. This is even more true if you can test it beforehand on another environment.

    Sorry to be not more helpful..

  • Community Member Profile Picture
    Community Member on at

    Béat,

    Thank you for your response.  Yes, that was my fear -- it makes sense to keep it closed so that the "black box" remains obfuscated and out of the prying eyes of those that might point out a better way or issues with the processes!  ;)

    That said, I am happy to report that after ~67 hours and touched 51MM records, the CL process did finally complete!  Granted, our T-Log is now 3x our DB size and so there is some maintenance needed to recover some expensive disk space.

    NOTE: I was monitoring the process and using some SQL to try and determine those table that have what appeared to be impacted data elements as well as determined the max record count for each table to find out what potential number of records were still outstanding.  I did discover that for one of the tables (RM30702), the CL process was extremely fast as it appeared to mass update the entire table vs. a transaction by transaction iterative update.  All said, there are still some tables (mostly 3rd party NCABRxxxx) that have those CURNCYID & CURRNIDX elements, yet which were not updated as part of the CL process and were not set as the functional currency as defined for the company.  This doesn't sit well with me, but perhaps I am just paranoid.

    Here are a few GP tables that I believe should have been updated, but still list an empty CURNCYID for most or all records: PM10201, PM00200, RM00101. 

    For those interested, here is the SQL I ran to identify those candidate tables for which MC likely applies.

    select * from sys.objects where object_id in (select object_id from sys.columns where name IN ('CURNCYID','CURRNIDX')) ORDER BY name ASC

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans