Report Sales Backorder Report

This report generates a list of SOs that are able to be fulfilled or on Backorder. The quantity shown is the quantity on hand without quantity in not-available locations.

The Modify Report button allows the following report filters to be customized:

OPTIONAL TAB

Sort By - Choose whether to sort by Part Number, Part Description, Customer, SO Number, Date To Fulfill, Quantity Needed or Quantity On Hand. 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.
Location Group - Choose a specific location group to run the report for. Leave this field blank to run for all location groups.
Customer - Choose to run the report for a specific customer. Leave this field blank to run for all customers.
Product Number - Choose a specific product to run the report for. Leave this field blank to run for all products.
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 DateScheduledFulfillment on the SOITEM table in the database, meaning it looks at the fulfillment date per line item on the sales order.
Estimate - 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.
Format Report for Exporting - Removes the page breaks and displays the report on one long page for exporting to CSV, Excel, and other formats.
Show Backorders Only - Choose to only show orders with backorders by checking this checkbox. To show all orders, uncheck this checkbox.
Show PO For Short Items - Choose to show/hide the PO number for short items by checking/unchecking this checkbox.

HIDE/SHOW TAB - Choose which columns to show/hide on the report by checking/unchecking the checkbox next to each column name.

PRINTER TAB - Allows a default printer to be specified for the report in each location group.