One View Sales Price Inquiry (P42273)

Access the One View Sales Price Inquiry application (P42273) on the Sales Order Inquiries (G42112) menu. Use One View Sales Price Inquiry to create item pricing reports. One View Sales Price Inquiry uses the following business views and tables:

Business View

Tables

One View Sales Price Inquiry (V42273A)

F4106, Item Key ID Master File (F40941), and Customer Key ID Master File (F40942)

One View Customer Master (V42273B)

F03012

One View Item Master (V42273C)

F4101

This application provides the ability to create and run reports for sales prices using customer and item information, such as: price list by customer, item price list by sub section, item price list by branch, highest priced items, item prices by region, and item price list by customer group. Additional reporting is possible through item and customer category codes to allow reporting, for example, by sales catalog code, sub section, or customer region.