You see these fields in the Cost/Usage tab of the Item at Location dialog box:
The bottom section of the Item at Location dialog box is similar to the Cost/Usage tab, with information about the item's cost, on hand quantity, allocated quantities, and period- and year-to-date usage and sales for that location. Most of these values are maintained by the program based on transactions involving the item, so these values are zero for a new item. However, when you add a new location for an item, you can edit some of these values.
On Hand Val: This is the monetary value of the on hand quantity of this item at this location. Inventory Control calculates the on hand value based on the costing method your company uses.
Avg Cost: The program updates this figure as you receive units at this location. This value is a location-specific average for the item. You can see the company-wide average cost in the Item at Location dialog box.
Std Cost: Enter the unit cost for this item. The initial value shown is copied from the Cost/Usage tab, but you can change it when you set up each location. If your company is using standard costing as its inventory valuation method, this is the only time you can enter the standard cost directly in this dialog box.
Last Cost: For a new item, enter the cost at which you last purchased this item. After you save this item at location record, this field is updated by inventory receipts and purchase orders.
You can also enter dates in the following fields. Thereafter, the program updates these fields automatically.
Last Sale: Enter the date the item was last sold from this location.
Last Rcpt: Enter the date the item was last received into inventory at this location.
Last Cnt: Enter the date you last performed a physical count on this item at this location.
Last Order: Enter the date the item was last entered on a purchase order for this location.
YTD Unit Use/$ Use: Enter the quantity and total value of this item sold, shipped, and issued during the current year. Thereafter, these figures are updated by invoices you enter in Accounts Receivable, shipments you enter in Sales Orders, and item transactions in Inventory Control.
YTD Unit Sales/$ Sales: Enter the quantity and total value of this item sold during the current year. Thereafter, Accounts Receivable updates these figures whenever you enter an invoice for the item.
PTD and YTD ASP: These fields show the period- and year-to-date average selling price, which is calculated as sales divided by usage. You cannot edit these fields here.