[LEFT]
I am starting my 1099 process and installed the NetSuite 1099 Vendor Payment Report - Yearli, Bundle 199464. I have logged a Case with NetSuite reporting the Search Results returns duplicate amounts when a Vendor has more than one Address. Of course we can just remove the duplicate data from the final report before submission but wanted NetSuite to be aware. [/LEFT]
[LEFT]I am now reconciling my data to the Bundle Saved Search "1099 Vendor Payment Report - Yearli".[/LEFT]
[LEFT]I am finding that the "Formula" columns are only putting the amounts in one column ('Box 7. Nonemployee Compensation') instead of as appropriate ('Box 1. Rents', 'Box 2. Royalties', etc.) [/LEFT]
[LEFT]I am still testing....
Test 1.... I can overlay the 'Box 1. Rents' formula with the 'Box 7. Nonemployee Compensation' value and get ALL the data in that column but returning the formula to 'Box 1. Rents' does not return Rent data in the Rents (Box 1) Column. ---- Failed[/LEFT]
Test 2...Went to Setup>Accounting>Accounting Lists, "copied" the list values from here and "pasted" them into the Search formulas.... In case there had been a typo in the Bundle>Saved Search. ----- Failed [LEFT]
Test 3...while reconciling Amounts, I found that when one Vendor payment is coded to two different account numbers, only one account number amount is reported... still in only one column... no success yet getting amounts into correct columns/box #s.
If any of you are using this Bundle/Search and have found a way to get the data to fall into the correct columns, would you let me know.[/LEFT]
I have been tinkering and may end up logging a case for this as well... [LEFT]As anyone uses the saved search you might consider logging any defects you identify, as well.
Thanks all.[/LEFT]