One View Historical Sales Inquiry (P42271)

Access the One View Historical Sales Inquiry application (P42271) on the Sales Order Inquiries (G42112) menu. Use One View Historical Sales Inquiry to query open sales orders including related data from the Item Branch and Customer Master Line of Business. One View Historical Sales Inquiry uses the following business views and tables:

Business View	Tables
V42271A	Sales Order Detail History table (F42119), F4101, and F03012
V42271B	F4101
V42271C	F03012

This application provides the ability to create and run reports on historical or closed sales orders including customer and item information, such as: average sales by item, total sales by customer, top customer sales by item, top sales by branch plant, and current backorders by branch. Additional reporting is possible through customer and item category codes to allow reporting, for example, by sales catalog code, sub section, or customer region.