Announcements
We are looking for information for Fiscal Year (X) for a 990 report - what we need to report is any (not just 1099) vendor we paid 100k or more to in Fiscal Year (X). I am just not able to break through the fog of how to get this information out. We have a VERY limited IT staff and custom SQL queries are not an option - I need to find something I can run in SmartList or some other canned report I can manage on my own. Help! Thank you!
*This post is locked for comments
Hi Jeff,
You definitely need to take advantage of the free training videos on YouTube. SmartList is one of the most powerful features for reporting used by accounting staffers. You also have access to prewritten Excel reports that are refreshable and linked to your company data. Hopefully, your reseller deployed them when your software was installed/upgraded.
If you can only go with the Favorites already set up, I would use the Payables Transactions - Transactions by Vendor. You need to exclude Voided Transactions. Select the Columns button, then Add. Double click on the field named Voided to add it to the SmartList Favorite. Click OK and then click on the Favorites button and select Modify.
Dump it to Excel and then filter it to include only Payments and Voided = No.
Kind regards,
Leslie
Late in response from me - thank you for your input. We also have no resources here familiar with SmartList other than the existing report options. How does one select fields/build reports there?
Vendor Calendar Year analysis might work but it is not allowing me to choose a particular year?
Hi Jeff,
I just wanted to see if the information that has been posted has been helpful with finding out the information that you are looking for. In addition if you could also try the Vendor Calendar Year Analysis report to see if this would provide you with the information that you are looking for. It doesn't appear that you can restrict it by an amount but it will show the Amount billed, Amount Paid, Discounts taken and lost.
Reports | Purchasing | Analysis | Calendar Year
Please let us know if you have any additional questions!
~Thomas Newcomb
------------------------------------------
Microsoft Dynamics GP Support
------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
The Cash basis method is payments to the vendor within the date range. be sure to exclude VOIDED. you of course will need to dump this to excel, and subtotal by Vendor for a total. On the off chance that you need to report this info on accrual and not cash bases, make sure to include doctype column (as credits still show up as +) so you can adjust your calc as well as voided.
You can do this in smartlist. The fields you could use are: Vendor ID, Vendor Name, Address1/2/3, City, State, Zip Code, Amount Paid LIFE, Amount Paid LYR
In order for the LYR amounts to be correct, you should have run the year end closing in AP. (I've seen some places not do this and then scramble to get amounts)
If you didn't run year end closing in AP, you'll need to do this in detail by getting check date and check amount for each vendor. Then subtotal them (probably dump this into Excel and total there).
There are already a lot of SQL queries that exist (www.victoriayudin.com) so you don't have to recreate the wheel.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
