You’re offline. This is a read only version of the page.
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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
