Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

Where to find Distribution Reference in SmartList

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,023 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans