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!