Linking Report of Multiple Sales Orders to Their Respective Invoices
Is it possible to run a report or combination of reports that will link a sales order to the invoice it was billed on?
We want to be able to look up a series of sales order numbers over a period of time (say 3 months), and show which invoices those sales orders were billed on without having to do a report for each sales order (we get hundreds a month) and invoice many times a day.
The issue is that our sales orders ship across multiple invoices, and our invoices have multiple sales orders on them.
When you are billing only one sales order per invoice Sales by Item or Customer detail will pick up both, but when there are multiple all you get is "multiple" on those reports.
I don't believe there is a single report that can show both, but perhaps there are two or three reports that can be exported to excel to provide all the info through something common (transaction number perhaps?) If there is something simple we are missing it...