Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

MS Dynamics GP - Adding Distribution References

(0) ShareShare
ReportReport
Posted on by 260

community.dynamics.com/.../ms-dynamics-gp-adding-distribution-references.aspx

I came across this original post and I was wondering if you can add the GL description to the Edit List ? (Right before you post the batch)

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: MS Dynamics GP - Adding Distribution References

    The KB only works for non-intercompany transactions. I have checked with other report writers and, as of right now, now such modification to this report exists. I am going to look into creating scripts and inserting them into a SSRS report.

  • RE: MS Dynamics GP - Adding Distribution References

    Did you figure this out?

  • cbucks723 Profile Picture
    cbucks723 260 on at
    RE: MS Dynamics GP - Adding Distribution References

    The GL Distribution Reference is what I'm talking about. (I just revisited this post and realized I wasn't very spot on with my location)

  • Kerry Brooks Profile Picture
    Kerry Brooks 50 on at
    RE: MS Dynamics GP - Adding Distribution References

    Yes. KB Article KB865470 says not to use this method if you are utilizing Intercompany.  Is there a way to drag in this field if you do use Intercompany?

  • RE: MS Dynamics GP - Adding Distribution References

    THe only issue that I have is that when I try this KB article, it works great as long as you don't have any inter company transactions.  THen it pulls the account index from the originating company.  What have I left off that is causing this issue?

    thanks

    Carolyn

  • cbucks723 Profile Picture
    cbucks723 260 on at
    RE: MS Dynamics GP - Adding Distribution References

    Do you have a link to KB865470 ?

  • cbucks723 Profile Picture
    cbucks723 260 on at
    RE: MS Dynamics GP - Adding Distribution References

    Thank you Jim - I'm looking to see if I can get it on the AP Edit List. We base a Crystal Report off of the  "Trip #"  that is entered in the description.

    It would be great if I could look and verify this # before a batch is posted. Now we have to go into each entry and look at the info....

    I'll keep searching for a solution.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: MS Dynamics GP - Adding Distribution References

    KB865470 Will show you how to add the distrobution reference to the payables transaction edit list.

  • Olaf Laos Profile Picture
    Olaf Laos 1,890 on at
    RE: MS Dynamics GP - Adding Distribution References

    Yes, Jim's solution works for the GL Transaction Edit List.

    But Payables Transaction Edit List and others, I don't think you can.

  • Suggested answer
    Jim Lines Profile Picture
    Jim Lines 2 on at
    RE: MS Dynamics GP - Adding Distribution References

    Hi. I just added the GL Distribution Field in General Transaction Edit List.  If you open the report in RW and choose Allocation Amounts from the drop down, the field is called Description.  I was able to get my unposted transaction GL Line Reference on the report when printing the edit list from the batch.  

    Jim

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans