Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Help with Row Linking

Posted on by 35

Hello,

I am brand new to Dynamics and need some help using FRx, specifically in the row linking.  The account structure is as follows A-BBB-CCCC-DDD.  A=company, B=program, C=account & D=sub account.  I need to create a p(l) for 30 programs and have set up the tree as follows:

?-001-&&&&-???

?-002-&&&&-???

?-003-&&&&-???

and etc for all 30 sites

The link to general ledger (column H) is defined by the account (3rd component of above account structure).  On one line though I need to pull in the account and the sub account.  For example, I use CCCC for all lines except one.  For this one I need to use CCCC-DDD.  I can't figure out how to do it.  Can anyone help?? 

*This post is locked for comments

  • Rob Iversen Profile Picture
    Rob Iversen 695 on at
    Re: Help with Row Linking

    Kristi,

    I would be happy to help you out.  It does get a 'little' complex in explaining the linkages between tree and row.  

    Can you send me an email at Rob.Iversen@MSXGroup.com and we can work out a time I can connect with you to show you around a little.

    Thanks

    Rob

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Help with Row Linking

    You should be able to modify the row to say full account and enter it with wild cards ?-???-CCCC-DDD

    Hope this helps

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans