One View Open Sales Inquiry (P42270)

Access the One View Open Sales Inquiry application (P42270) on the Sales Order Inquiries (G42112) menu. Use One View Open Sales Inquiry to query open sales orders and create sales order reports including related data from the Item Branch and Customer Master Line of Business. One View Open Sales Inquiry uses the One View Open Sales Inquiry business view (V42270A), which include columns from the Sales Order Detail table (F4211), Item Master table (F4102), and Customer Master by Line of Business table (F03012). It also uses V42270B to fetch information from the Sales Order Header (F4201).

This application provides the ability to create and run reports on current sales orders including customer and item information, such as: open sales orders by customer, status of open orders, today's shipments by item, open sales orders by item, commitments by item, and current backorders by branch. Additional reporting is possible through customer and item category codes to allow reporting, for example, by sales catalog code or customer region.