Payee reports - Navigator User Forums

Navigator User Forums

Transaction Reports

Payee reports

profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone!

next newest topic | next oldest topic

Author	Topic: Payee reports
jordonez Member	posted 11-01-2002 08:03 AM At year end I need to produce a report of all my 1099 Misc Payees. In previous years I have done a summary of transactions for all payees, sorted in in descending orders and then from that culled those who had to be reported (e.g. - no 1099 to corporations. I am trying to be more efficient and only list those who could possibly need a 1099. I believed that identifying them in the FOR/ as 1099 would do the trick. Now I find that I cannot produce a report for all payees with the "qualifier" 1099. I see no functionality for the FOR/ designation if it can't be used for a filtering device. I guesss I have to go back to all my 1099 designates and put them in one set, but that seems more troublesome and requires more at the front end to set it up. The Set Number field does not pop up when a new payee is discovered by the system. Is there a way to use the FOR/ field in the payees to do a report that I want? IP: Logged
Pamela Member	posted 11-05-2002 05:32 PM The For/From function in the payee/payor names is for identification purposes. It is not the same as an account qualifier. For example, some vendors are payees AND payors. Therefore, by setting up a payee for issuing funds and the same name payor for receiving funds, you can designate separate automatic entries and avoid confusion because it is the same vendor name. (e.g., Bank of USA/Interest, Bank of USA/Service Fees) Another example is if you want to identify the same payee/payor name for different payments or purposes. (e.g., IRS Est pymt/1st Qtr, IRS Est pymt/2nd Qtr, OR Auto Expenses/Buick, Auto Expenses/Volvo) In your situation, by designating the For field as "/1099", you can easily identify those payees that you need to issue a 1099 for within the Summary of Transactions for All Payees report because the "/1099" is part of the payee name. Again, the For field is an identifier in the payee/payor names not a qualifier as with accounts for report purposes. Currently the FN program does not provide reports by the For/From field identifier. See your Financial Navigator Reference Guide or the online Help system under the index item For/from indentifiers for more information on this subject. [This message has been edited by Pamela (edited 11-05-2002).] IP: Logged
jordonez Member	posted 11-06-2002 06:28 AM I appreciate your reply. I now see how I can use the For/From option. But back to my original goal. Is the only way I can issue a report on just 1099 vendors is to isolate them all in a unique set? IP: Logged
Pamela Member	posted 11-06-2002 08:32 AM Yes, if you put your 1099 payees in a set number, and then run a summary report for that set, then you will have isolated those payees into a report. When you add a new payee, select Periodic Transactions command button instead of OK command button after entering the new name, and you can add the set number at the same time that you set up the new payee! Excellent work around idea for your situation. Thanks for sharing it with the Forum so that everyone can benefit! IP: Logged
John Administrator	posted 11-07-2002 08:25 AM Also a range of set numbers can be used when requesting any payee report. This way a specific set number can be used for a single purpose. While the range of set numbers can be for a group of payees. For example set # 10 could be for salary employees, and set #11 could be hourly employees. The range 10 to 11 would be for all employess. Set numbers are limited from 1 to 255. IP: Logged
An Member	posted 06-11-2009 09:38 AM Another user had a similar 1099 Report request. The following shows how to utilize Set Numbers to filter miscellaneous payee information (i.e. 1099 Taxable Income reports). Federal ID #s for payees can be listed in one of the Miscellaneous fields by selecting Change or Delete Payee/Payor Name under the Transactions drop-down menu. After selecting the payee, hit the Address Info button and you will find the Miscellaneous fields. To designate a payee as needing a 1099, you could use Set Numbers if you aren’t already using them for another purpose. Select Change or Delete Payee/Payor Name under the Transactions drop-down menu. After selecting the payee, hit the Periodic Transactions button. On this screen, change the Set Number to 99. After doing so for all the appropriate payees, you can now run reports specifically for these payees by filtering for the Set Number of 99. [This message has been edited by An (edited 06-11-2009).] IP: Logged

All times are PT (US)	next newest topic \| next oldest topic
Administrative Options: Close Topic \| Archive/Move \| Delete Topic
	Hop to:

Contact Us | Home

Copyright 2010 Financial Navigator, Inc.

Ultimate Bulletin Board 5.47e