[Elena Konoryezova]

Hello dear colleagues!
I have an AP related question.
Can somebody help with the following? How to run a smart list in GP by vendor ID and GL code? I am looking for all purchasing transactions for a certain vendor coded to a certain GL. 
Thank you
Elena

——————————
Elena Konoryezova
Atlantic Corporation Limited
Halifax
——————————

[Carol Kossoris]

Hi Elena,

I recommend creating this using Account Transactions in the Financial Series of smartlist.  Add the columns “Series” , “Originating Master ID” and/or “Originating Master Name” and possibly “Main Account Segment”.  Search on Series = “Purchasing”, Main Account Segment that is greater than your AP accounts (maybe less than also), and a TRX Date range.

——————————
Carol Kossoris
GP Consultant
Heartland Business Systems, LLC
Pewaukee WI
——————————
——————————————-

[Elena Konoryezova]

Thanks for help , Carol.
Have a great day!
Elena

——————————
Elena Konoryezova
Atlantic Corporation Limited
Halifax
——————————
——————————————-

[Shari Bruno]

Hi Elena,

If you want to see a report for one vendor and a particular GL code use the Account Number column then sort by the vendor and Account Number.  If you need to sort by different account segments choose the columns for those segments and do a search on the vendor and an individual segment.

——————————
Shari Bruno
Accounts Payable Specialist
Bible League International
Crete, IL
——————————
——————————————-

[Lou Spevack]

We use a SmartList based on a SQL view for Payables GL distributions in Dynamics GP from Victoria Yuden’s blog.  She also has instructions on how to create a SmartList report using a view.

——————————
Lou Spevack
Systems Accountant | Dynamics Credentialed Professional
American Council on Education
Washington DC
——————————
——————————————-

[Nancy Beaudoin]

You would be able to run this under the Financial section, Account Transactions and search with the account number equal to what you need and also have the “originating Master ID” equal to your specific vendor.

——————————
Nancy Beaudoin
Staples SchoolKidz
Woodridge IL
——————————
——————————————-