Field Name Description
Location ID Enter a location ID.
Item ID Enter an item ID.
Sale Units Accept the current unit of measure, or enter a different one.
Price ID Enter a price ID (optional).
Customer ID Enter a customer ID (optional).
Cust Level Enter a customer level (optional).
Sale Date Accept the default sale date, or enter a different date.
Sale Quantity Accept the default quantity, or enter a different quantity.
On Hand Qty The quantity on hand appears.
Committed Qty The committed quantity appears.
In Use Qty The in-use quantity is appears.
Available Qty The available quantity appears.
On Order Qty The on-order quantity appears.
LIFO/FIFO Cost This field appears if you elected in the Resource Manager Options and Interfaces function to show costs in the price and availability lookup.
The LIFO/FIFO unit cost appears.
Average Cost This field appears if you elected in the Resource Manager Options and Interfaces function to show costs in the price and availability lookup.
The average unit cost appears.
To return to the Price and Availability screen, use the Exit (F7) command.
Standard Cost This field appears if you elected in the Resource Manager Options and Interfaces function to show costs in the price and availability lookup. The standard unit cost appears.
Base Cost This field appears if you elected in the Resource Manager Options and Interfaces function to show costs in the price and availability lookup.
The base unit cost appears.
Calc Unit Price The calculated unit price appears.
Calc Ext Price The calculated extended unit price appears.
Base The base level appears.
Quantity The sale quantity levels appear.
Unit Price The unit price for each quantity break appears.
Field Name Description
Use the Summary History function on the Information Inquiry menu to view information from the transaction history records for an item: number of items sold, purchased, transferred, adjusted, requisitioned, built, and issued for a period and year.
The Summary History screen has two sections. Use the default Summary History screen to view the totals of the items purchased or returned, COGS, COGS returned, and requisitions. When you press M, the second section of the screen appears, and you can view the totals of transfers, adjustments, builds, and issues.
To add or change information on this screen, use the Inventory Transactions function or the Location Transfers function.
Select Summary History from the Information Inquiry menu. The Summary History screen appears.
1. Enter the ID for the item for which you want to view summary history.
2. Enter the ID of the location for the item.
3. Enter the period for which you want to view summary history.
4. Enter the year for which you want to view summary history.
5. Enter Q to view the total amounts in quantities. Enter D to view the total amounts in dollars.
6. Enter the unit of measure for the item.
7. Select a command:
• Press M to view totals of transfers, adjustments, builds, and issues.
• Press N to view the next item record on file.
• Press P to view the previous item record on file.
• Press F to view the first item record on file.
• Press L to view the last item record on file.
• Press H to go to the Item ID field and change any of the header information.
• Press C to switch between viewing totals in quantities or dollars.
• Press U to go to the Units field and enter a different unit of measure for the item.
• To exit to the Information Inquiry menu, use the Exit (F7) command.
Use the Detail History function on the Information Inquiry menu to view selected information about transactions: period and year the transaction took place, transaction date, type of transaction, source ID, application, units, quantity, and total amount. If you do not keep detail history, you cannot use this function.
To add or change information on this screen, use the Inventory Transactions function or the Location Transfers function.
Select Detail History from the Information Inquiry menu. The Detail History screen appears.
1. Enter the ID of the item for which you want to view detail history.
2. Enter the location ID for the item.
3. Enter P to include purchase transactions, S to include sales transactions, M to include material requisitions, T to include transfers, A to include
adjustments, B to include builds, and L to include all transactions for the item.
4. Enter the range of periods and years you want to see.
5. Select a command:
• Press N to view the next item record on file.
• Press P to view the previous item record on file.
• Press F to view the first item record on file.
• Press L to view the last item record on file.
• Press H to go to the Item ID field and change any of the header information.
• Press V to view detailed information about a transaction. The View Transaction Detail window appears.
• Press S to view lot and/or serial number detail for an item in history.
• Press G to go to a specific detail history line (this command is only available if there is more than one page of detail history).
• To exit to the Information Inquiry menu, use the Exit (F7) command.