Where to find Distribution Reference in SmartList

(0) Share

Report

Posted on by KM4

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:

Microsoft Dynamics GP

All responses (6)

Answers (2)

KM4 5 on at

Like (0)

Report

RE: Where to find Distribution Reference in SmartList

We are looking into that - thank you!
KM4 5 on at

Like (0)

Report

RE: Where to find Distribution Reference in SmartList

Understood - thanks Brandon for your help!
Suggested answer

Lisa at AonC.com 3,141 on at

Like (0)

Report

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 75,730 on at

Like (2)

Report

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 40 on at

Like (1)

Report

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 2,950 on at

Like (2)

Report

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.