Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Help- need to create a Great Plains Smartlist report

Posted on by Microsoft Employee

Good Morning,

I am in desperate need of a smartlist report.  Can someone help me create a report which would show The vendor name, the vendor ID, 1099 status if flagged as 1099,  each check # that was issued to the vendor, the date that the check was issued, the $ amount of the check issued to the vendor (making sure that voids are excluded),  Wires included if any were issued. The purchases amount would be the entire amount that the invoice was presented for, the need for this is so that we can compare the amount that was booked into the 1099 amount vs the amount that should be expenses. 

Vendor Name Vendor ID 1099 status User defined note

Check 

#Number

Check Date Check $Amount Purchases amount

The next report that needs a modification is one that I found in Financial, Account Transactions, TRX for GL account this report needs to have a column included for user defined notes.   The AP Specialist would state in that field that the vendor is or is not 1099 eligible example as we look through the w-9s presented we would note that s corp not 1099, corporation not 1099 etc. ) , the reason for this is that these reports are run by GL account in an effort to catch 1099 eligible vendors that have not previously been identified.  If the user defined field already states that the vendor is not 1099 eligible it would save significant time spent manually looking up W-9s to identify when this has already been done but not captured on the report.

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Help- need to create a Great Plains Smartlist report

    Hi,

    First, do you have SmartList Builder or just SmartList Designer? Are you using GP2010?

    For the out-of-the-box SmartLists, look at the Payable Transactions folder, add the columns:

    1099 Type

    1099 Amount

    Unapplied 1099 Amount

    Tax ID# (if you have 1099 vendors, you need their tax ID)

    What field are you using for the 'User defined Note' field?

    We have an incongruence with the check information. A single check can pay many invoices - so you do not have a one to one relationship between the check and the purchase amount. Are you wanting the Purchase amount from the Vendor Invoice? If you need the 'apply to' information, you will need to build a new SmartList Object. What about the Invoice number? 

    In the second report, the Financial Account Transactions report is way different than the first report, so it's not just adding that additional field to the report, the questions above are still valid for the second report too.

    Since 1099 amounts don't go on the 1099 until a check is applied to the invoice, we have the column Unapplied 1099 amount. To find out what should be on the 1099, take the 1099 amount and subtract any amount that is in the Unapplied 1099 column.

    Please let us know, this one sounds very doable.

    Kind regards,

    Leslie

  • mm123 Profile Picture
    mm123 2,535 on at
    RE: Help- need to create a Great Plains Smartlist report

    dwydler ,Currently we are creating a very similar custom report for a construction company based on their specific business needs. If you are interested please drop an email to learn.

    sam

    samr(at)expsoltech(dot)com

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans