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!
Group write-off amounts by vendor
Hi,
The RMA process has an option to restock the items or not which if not the items will be written off to a default account. We would like to be able to see the amount of product per vendor that is written-off to this account based on time period. Something like the pseudo-SQL: Select vendor, sum(amount) FROM Transactions group by vendor, where Account = Write-Off-Account and date > x and date < y;
How would we build a search like this? Is there a better way to get this information? Are there other approaches?
Thanks!