Viewing Customers' Last Price Paid

The Last Price Verification screen shows comparative pricing information for a single product on the current sales order. Using this screen, you can easily compare prices and adjust the current price if you want to. The screen shows:

The customer's current price for the line item and
The last price the customer paid for that same line item.

By default, the last price is based on the last price paid at all branches. However, if the Override Basis Name For Last Price Calculation control maintenance record is set, then the basis identified will be used instead of the actual last price.

To view the last price paid for an item:

Create or open a sales order and display the Body screen.
Select the item for which to compare prices, and use the Quick Prc hot key to display the Last Price Verification screen.
Review and edit the following fields, as needed:

Note: Some fields are view-only.

Field	Description
Order #	A letter followed by a unique series of numbers that identifies the order.
Lot Ids	A number that identifies the detail lot to which this item belongs.
Qty	The total quantity of the item ordered.
Price	The selling price per unit. For example, if the unit of measure is bx (box), then the unit price is the amount the customer pays for one box of the item. If authorized, pressing F10 from this field displays the profit wheel.
COGS/Cost	The cost incurred in producing (by unit of measure ordered) the line item on the current order. If the item was purchased previously, the system displays the cost for the line item on the last order. You can edit this field for the current sales order. Authorized users can use the Cost/COGS hot key to view the cost or the cost of goods sold.
GP%	The percentage of the price your company receives as profit as a result of the sale of the item, based on cost of goods sold.
GP$	The dollar amount your company receives as profit as a result of the sale of one unit of the item, based on cost of goods sold.
Ext GP$	The dollar amount your company receives as profit as a result of the sale of the specified quantity of the item, based on cost of goods sold.
Formula	The calculation used to determine the price basis. For more information, see Pricing Formulas.
PO#	The customer's purchase order number for this sale.
Mfg	The company that manufactures the item.

Use hot keys, as needed:

To...	Use this hot key...
review all customer activity for the selected item	Cust Inv Hist The Inventory History Ledger screen displays.
review all product activity for the selected item	Inv Hist The Inventory History Ledger screen displays.
determine to what detail lot this item is assigned (if any)	View Detail Lot The Detail Lot Maintenance screen displays.
review all purchases made for the selected item	View Purch Hist The Inventory History Ledger screen displays.
view a list of open orders on which this item has been purchased	Order Inquiry The Open Orders screen displays.
add a standard note to the order	Product Notes A list of standard notes displays.
customer's last order for the item (in view-only mode)	View Last Sale The Sales Order Entry Body screen displays.
toggle between the price information for the ship-to address and the bill-to address.	Use ST/Use BT
assign this item to a detail lot	Select Det Lot The Detail Lot Selection screen displays.
view all bids on which this product is present	Future Bid Inq An inventory type selection list displays. Select a type and press Enter to display the Future Ledger screen.

Press Esc to update the item price on the Sales Order Entry Body screen.