Find Sale Backorder By Purchase Order Report

Find Sale Backorder By Purchase Order Report

This report allows finding all sales included in a specific purchase order created via the Reorder Backordered function. Use this report to see products ordered, quantity ordered, supplier and whether stock has been received yet. You can also change the column order to find a purchase order by sale backorder.

If backordered items are reordered from different suppliers, the report shows multiple purchase orders for the sale task.

If the purchase order contains backordered products sold using different sale tasks, the report shows the PO tasks for each sale order task.

Prerequisites

 

Data from this report can be exported in Excel, PDF or RTF format.

Input:

Layout

Set to the Default layout. Allows selection of saved layouts, if any.

Save Layout As

Allows saving a layout for potential future use.

Reset Layout

Resets the layout to the default layout or selected saved layout.

 

Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing Cin7 Core Reports - Filtering Reports for more detailed information about using filters.

Output:

The following output fields are available for this report. You may have to open the Configure Layout menu to add some of them to your report.

Fields

Purchase Order #

Purchase order number identifying the purchase order created via the Reorder Backordered function

Purchase Invoice #

Invoice number issued by the supplier

Supplier

Supplier name

Stock Received

Yes, if Stock Received was authorized on Purchase, otherwise No

SKU

SKU number for each PO included in the sale

Quantity Ordered

Quantity ordered per SKU for each PO included in the sale

Sale Order #

Sale order number identifying the backordered sale

Sale Order Date

Date of the sale order

Sale Invoice #

Sale invoice number identifying the backordered sale invoice

Customer

Customer name

Customer Reference

Customer reference from the sale document header

Sales Representative

Sales representative associated with the sale

Ship By

Required by date from the sale document header

Ready for Shipment

Indicates if the sale is ready to be picked and shipped

Supplier Additional Attribute 1-10

Additional supplier attributes

Customer Additional Attribute 1-10

Additional customer attributes

 

Note: If you have added an Additional Attribute set to your sale process, the attributes will appear as additional report fields.

Was this article helpful?

Have more questions? Submit a request