One View Sales To Date Inquiry (P42272)

Access the One View Sales To Date Inquiry application (P42272) on the Sales Order Inquiries (G42112) menu. Use One View Sales To Date Inquiry to query open and historical sales orders. One View Sales To Date Inquiry uses the One View Sales To Date Inquiry business view (V42272A), which includes columns from the F4211 and the F42119 and Fiscal Date Patterns table (F0008). V42272B fetches additional information from the F03012.

This application provides the ability to create and run reports on open and historical (or closed) sales orders including customer and item information, such as: customer sales by period, item sales by period, sales profit by period, sales price by period, sales costs by period, average profit per period, sales profit by customer, and sales profit by item. Additional reporting is possible through item and customer category codes to allow reporting, for example, by sales catalog code, sub section, or customer region.

This application also provides the ability to create and run reports to view sales orders, revenue, potential revenue, and profit information associated with sales opportunities.