Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Where to find Distribution Reference in SmartList

(0) ShareShare
ReportReport
Posted on by 5

I am new to using GP2010 and cannot find the Distribution Reference in the Purchasing module when creating a SmartList.  I don't see DSCRIPTN nor do I see DESCRIPTION either.  Is that field not available in this version?

Categories:
  • KM4 Profile Picture
    KM4 5 on at
    RE: Where to find Distribution Reference in SmartList

    We are looking into that - thank you!

  • KM4 Profile Picture
    KM4 5 on at
    RE: Where to find Distribution Reference in SmartList

    Understood - thanks Brandon for your help!

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,141 on at
    RE: Where to find Distribution Reference in SmartList

    The reference to Distribution Reference makes me thinkg you are possibly referring to posting purchasing/payables data in the GL.  If so, that is found at SmartList > Financial > Account Transactions.

    [I agree with the other posts about getting on a supported version of GP.  However, the distribution/originating information I think the AccountTransactions view back in GP 2010.]

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Where to find Distribution Reference in SmartList

    Do you have access to SSRS and SQL? You could create a SQL view with this information and then post a report using that view in SSRS. Is there any possibility of upgrading GP?

  • Verified answer
    sarafoster Profile Picture
    sarafoster 40 on at
    RE: Where to find Distribution Reference in SmartList

    It is possible that the Distribution Reference field is not available in the Purchasing module of GP2010. You may need to check with the software documentation or contact technical support for further assistance.        home bargains portal login

  • Verified answer
    Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Where to find Distribution Reference in SmartList

    Hey KM4,

    The distribution reference would be held in the distribution table. For Payables, this would be the PM10100 (Work/open) or PM30300 (History). The core GP smartlists do not look at these tables. You would need to join the PM10100 and PM30300 to another table that is being used on your Smartlist. Assuming this is a Payables Smartlist.

    The field in the table that holds this is DISTREF. Once you have the tables linked in Smartlist you should be able to pull the field onto the smartlist.

    Now, you are on GP 2010. You won't have Smartlist Designer to be able to accomplish this. You would need to have Smartlist Builder which is a third party product.

    I would also recommend that you start the process of looking to upgrade. There is no support for the version that you are on.

    I hope this helps!

    Thank you!

    Brandon | Microsoft Support Engineer.

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans