Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and 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!
0