Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
1099 Custom App
I currently use a custom app created by a previous employee to generate our 1099 report. I have the formula. Anyone know how to reproduce this on a saved search?
FROM TRANSACTIONS a
join transaction_links b on b.APPLIED_TRANSACTION_ID = a.TRANSACTION_ID
join TRANSACTIONS link on b.Original_TRANSACTION_ID = link.TRANSACTION_ID
join Vendors Vendor on Vendor.Vendor_id = a.entity_id
Where a.Transaction_Type in ('Bill Payment')
and a.TranDate BETWEEN '2014-01-01' AND '2014-12-31'
and a.Status <> 'Voided'
and Vendor.IS1099ELIGIBLE = 'Yes'