Report SO To PO Margin
From Fishbowl Advanced
This report displays the margins of Sales Orders where a Purchase Order is associated with a Sales Order. Sales tax is included in the total Sale amount.
The
Modify Report button allows the following report filters to be customized:
- OPTIONAL TAB
- Sort By - Choose whether to sort by SO, Customer, Sales Order Date, Sales Person, PO or PO Date. Add additional sorts that apply in sequence by clicking on the green Add More Sorting Options button. Also, choose Ascending or Descending order by clicking on the blue arrow icon.
- Sales Person - Choose which sales person to run the report for. Leave this field blank to run for all sales people.
- SO Number - Select the sales order number to run the report for. Leave this field blank to run for all sales orders.
- Date Range - Choose a date range to run the report for. This date range looks at the DateCreated on the SO table in the database, meaning the date the sales order is created.
- Closed Short - Choose to show/hide orders with this status by checking/unchecking this checkbox.
- Estimate - Choose to show/hide orders with this status by checking/unchecking this checkbox.
- Fulfilled - Choose to show/hide orders with this status by checking/unchecking this checkbox.
- In Progress - Choose to show/hide orders with this status by checking/unchecking this checkbox.
- Issued - Choose to show/hide orders with this status by checking/unchecking this checkbox.
- Void - Choose to show/hide orders with this status by checking/unchecking this checkbox.
- Format Report for Exporting - Removes the page breaks and displays the report on one long page for exporting to CSV, Excel, and other formats.
- PRINTER TAB - Allows a default printer to be specified for the report in each location group.
