Backorder Report by Descending Dollars by Entity/Warehouse
How to print: Select the By entity/whse field and optionally an entity code in the Entity field at the Backorder Report by Descending Dollars Screen (PBOD) and select Accept.
For more information: See the sample report in PDF format.
Contents:
• Selected report: the report you selected at the Backorder Report by Descending Dollars screen. You can select:
• By entity/warehouse: you selected the By entity/whse field. This report sorts in entity/warehouse/item/descending dollars sequence and displays backordered order detail lines for each entity.
• By division/warehouse: you selected the By division/whse field. This report sorts in division/warehouse/item/descending dollars sequence and displays backordered order detail lines for each division.
• By offer/warehouse: you selected the By offer/whse field. This report sorts in offer/warehouse/item/descending dollars sequence and displays backordered order detail lines for each offer.
• By warehouse: you selected the By warehouse field. This report sorts in warehouse/item/descending dollars sequence and displays backordered order detail lines for each warehouse.
• Offer for pricing: the offer you entered in the Select offer for pricing field. This is the offer the system uses to determine the selling price that prints on this report.
• If the item is non-SKU’d, the system uses the price from the Item Price table.
• If the item has SKUs, the system uses the price from the SKU Price table.
• If a price has not been defined in the SKU Price table for the SKU’d item, the system uses the price in the Item Price table.
• If a price has not been defined for the Item Price table or SKU Price table, for example with components of a set, the system leaves the price blank.
• Selected Entity, Division, or Offer: the entity, division, or offer that has backordered order detail lines. The system uses the source code on the order header to determine the entity, division, or offer where the order detail lines are backordered.
• Entity included if you selected the Backorder Report by Descending Dollars by Entity/Warehouse.
• Division included if you selected the Backorder Report by Descending Dollars by Division/Warehouse.
• Offer included if you selected the Backorder Report by Descending Dollars by Offer/Warehouse.
• Warehouse: the code for the warehouse where order detail lines are backordered. The system looks at the backorder warehouse in the Order Detail table to determine the warehouse where the order detail lines are backordered.
• Item: the code of the item that is on backorder in the entity and warehouse defined.
• SKU: the SKU of the item that is on backorder.
• Description: the first 19 positions of the description of the item that is on backorder.
• Quantity on backorder: the quantity of the item that is on backorder for the selection criteria you defined. The system uses this calculation to determine the backorder quantity:
quantity ordered - quantity shipped - quantity cancelled - quantity soldout - quantity reserved = quantity on backorder
Note: The calculation to determine the quantity on backorder does not include drop ship items or items with a future arrival date.
• Unused quantity on purchase order: the purchase order quantity that has not been applied to order detail lines on backorder. For example, if the purchase order quantity is 10 and you have 2 backordered order detail lines, the unused purchase order quantity is 8. To get the most up-to-date unused quantity on purchase orders, you should run Batch PO Layering before generating this report.
• Purchase order expected date: the date the next purchase order is expected to be received. The system uses the closest future due date to today that will cover the backorder quantity, based on the information in the PO Layering table. If a future purchase order due date is not available, the system uses the purchase order date in the past that is closest to the current date.
• Quantity on hand: the total on hand quantity for the item in the warehouse defined.
• Quantity on reserve: the total reserved quantity for the item in the warehouse defined.
• Selling price: the total selling price of the backordered items in the offer defined. For example, if the price for the item in the specified offer is 22.00 and 2 order detail lines are backordered, the total selling price is 44.00.
Note: The actual selling price used on an order detail line may differ from the selling price defined for the offer, for example the order entry operator may manually change the selling price on the order detail line.
• Cost: The total cost of the backordered items. The system uses the Costing Method (A25) system control value to determine which Cost field (average, standard, or FIFO) to use from the SKU table. For example, if the cost of the item is 15.00 and 2 order detail lines are backordered, the total cost is 30.00.
cost x backorder quantity = total cost
• Total warehouse: the totals for the order detail lines associated with the warehouse.
• quantity on backorder
• unused quantity on purchase order
• quantity on hand
• quantity on reserve
• selling price
• cost
• Total entity: the totals for the order detail lines associated with the entity. Included only for the Backorder Report by Descending Dollars by Entity/Warehouse.
• quantity on backorder
• unused quantity on purchase order
• quantity on hand
• quantity on reserve
• selling price
• cost
• Total division: the totals for the order detail lines associated with the division. This total is included only on the Backorder Report by Descending Dollars by Division/Warehouse.
• quantity on backorder
• unused quantity on purchase order
• quantity on hand
• quantity on reserve
• selling price
• cost
• Total offer: the totals for the order detail lines associated with the offer. This total is included only on the Backorder Report by Descending Dollars by Offer/Warehouse.
• quantity on backorder
• unused quantity on purchase order
• quantity on hand
• quantity on reserve
• selling price
• cost
• Total number of orders on backorder: the total number of orders that have at least one order detail line on backorder for the selection criteria defined.
• Grand total: the totals for the order detail lines across all selection criteria on this report.
• quantity on backorder
• unused quantity on purchase order
• quantity on hand
• quantity on reserve
• selling price
• cost
