Using the Inventory History Ledger

Use the Inventory History Ledger to review the following transactions for a product in and out of inventory at the specified branch:

Sales – Displays all sales orders for the product.
Purchases – Displays all purchase orders (P/Os) for the product.
Transfers – Displays all transfers for the product.
Adjustments – Displays all inventory adjustments for the product.
Work Orders – Displays all work orders for the product.

Note: If a product is tied to a work order, the Ledger only displays the work order and not the sales order to which the work order is tagged.

Open Serial – Displays all serialized transactions for the product.
Rentals – Displays all rental transactions for the product.

In addition, use this screen to view a product's activity and see how various transactions affect product availability. If necessary, make adjustments to other transactions, making more of the product available for sales.

Note: The INV.SLS.LIMIT.DETAIL authorization key limits your viewing of the sales order history to accounts to which you have been assigned.

To use the Inventory History Ledger:

From the Orders > Inquiries menu, select Inventory History Ledger screen.

Note: When accessing the Inventory History Ledger from other screens, the system uses the product information from those screens.

In the Desc field, enter the product for which to review activity.
Limit the information displayed in the following fields, as needed:

Field	Description
As of Date	Date as of which to view transactions for the selected product. Either arrow up to the field or use the Date hot key to change the value in this field. Leave the field blank to include all transactions through the current date.
Br	Branch for which to view transactions for the selected product. Either arrow up to the field or use the Br hot key to change the value in this field. If you access this screen from the menu, the system displays the information for your home branch.
Status	Transaction type to display. Use the Show hot key and select one of the following statuses to which to limit the display: All – Displays all transactions for the product. Sales – Displays all sales orders for the product. Purchases – Displays all P/Os for the product. Transfers – Displays all transfers for the product. Adjustments – Displays all inventory adjustments for the product. Work Orders – Displays all work orders for the product. Open Serial – Displays all serialized transactions for the product Rentals – Displays all rental transactions for the product.
Entity	Customer, vendor, branch, or territory for which to display transactions. Arrow up to this field to enter a value.

Review the following product availability information for the product at the selected branch:

Field	Description
On Hand	Total amount on hand both in stock and tagged to orders.
Commtd	Total amount committed to sales or transfer orders both in stock and tagged to orders.
In P/O	Total amount being purchased both in stock and tagged to orders.
In Xfer	Total amount being transferred from other branches both in stock and tagged to orders.
In Proc	Total amount being picked or received both in stock and tagged to orders.
In Work	Total amount scheduled for work order processing both in stock and tagged to orders.

Review the following inventory history information for the product:

Note: Use the Chng View hot key to change the screen view. You must be assigned the TO.PRICE.VIEW authorization key to view any price, cost, or COGS fields.

Column	Description
Reference	Transaction number.
PostDate	Transaction's posting date.
Type	Product location quantity type for the item on the transaction. If you have the OE.PRODUCT.TYPE.EDIT authorization key, you can change a transaction from Stock to Except to indicate that it is an exceptional sale and should be excluded from the demand forecast calculation. Otherwise, the value in this column is view only.
In	Incoming quantity of product on that transaction. Note: When In and Out quantities display in the same column, in quantities are positive.
Out	Outgoing quantity of product on that transaction. Note: When In and Out quantities display in the same column, out quantities are negative.
On Hand	Quantity of the product on hand. When multiple units of measure are defined in Product Maintenance, both the Inventory History Ledger screen and report use the unit of measure set for inventory counts (I).
Customer / Vendor	Customer or vendor associated with the transaction, or other information that defines the transaction, such as Xfer for transfers or ** Location Adju for location adjustments.
Unit Prc/	Unit price for the default unit of measure defined for inventory. This column displays the same overrides that display in Sales Order Entry, as follows: + – Unit price determined by a matrix cell tied to a contract customer. ! – Unit price determined by a customer-specific matrix cell or a system override. * – The original price on the sales order for the item was determined by a matrix cell tied to a contract customer, customer-specific matrix cell, or system override, but was then subject to a manual override on the sales order.
Unit COGS	Unit cost of goods sold (COGS) for the default unit of measure defined for inventory. This column displays the same overrides that display in Sales Order Entry, as follows: + – COGS cost determined by a matrix cell tied to a contract customer. ! – COGS cost determined by a customer-specific matrix cell or a system override. Note: If the original COGS on the sales order for the item was determined by a matrix cell tied to a contract customer, customer-specific matrix cell, or system override, but was then subject to a manual override on the sales order, an asterisk (*) displays.
GP%	Gross profit percentage calculated for the item.
Unit Cost	Unit cost for the default unit of measure defined for inventory. This column displays the same overrides that display in Sales Order Entry, as follows: + – Unit cost determined by a matrix cell tied to a contract customer. ! – Unit cost determined by a customer-specific matrix cell or a system override. Note: If the original unit cost on the sales order for the item was determined by a matrix cell tied to a contract customer, customer-specific matrix cell, or system override, but was then subject to a manual override on the sales order, an asterisk (*) displays.
Location	Product stocking location. You cannot update the location for a direct order.
Serial Ct	Number of units assigned a serial number for the transaction.
Customer PO	Customer's purchase order number.
Country Manufactured	Country where the item was manufactured.
Lead Time	Adjusted lead time for the item.

Press Esc to exit the screen.

More Options from the Inventory History Ledger Screen

The Inventory History Ledger screen also offers these options:

Hot key	Function
View	Displays the selected transaction in view-only mode.
Locations	Displays the Product Location Maintenance screen for the product. Use this screen to view multiple product stocking locations.
Future Ldgr	Displays the Future Ledger screen for the product. Use this screen to view projected product availability.
Inven Inq	Displays the Inventory Inquiry screen for the product. Use this screen to view product availability and inventory information.
Print	Displays the Inventory History Ledger Printing screen. Use this screen to print the Inventory History Ledger to a printer or to your Hold file. You can define the branch, date range, and customer for which to print a report. Note: To print the ledger for all customers, leave the Customer field on the Inventory History Ledger Printing screen blank.
Sales Hist	Displays the Product Sales History screen for the product. Use this screen to compare transaction quantities or dollar amounts.
Log	Displays the Product Activity Log Viewing screen for the product. Use this screen to view product activity.
Xref	Displays any cross-reference links for the product to related information on Web sites. Select the link to open it in your default Web browser.
Ser# Entry	Displays the Serial Number Entry screen for the product. Use this screen to view or edit serial numbers.
P/O Srch	Displays the Customer P/O prompt. Use this prompt to display only those transactions entered against a specific customer P/O. Enter the customer P/O and press Esc to display the specific transactions.
Edit Loc	Displays the Edit Location screen. Use this screen to edit the location type and location for the selected transaction. In the Typ field, edit the location type. In the Location field, edit the location. Press Esc to save changes and exit the dialog box.
Lot Desc	Displays the Search Material Detail For screen. Use this screen to search for lot billing items.
CostQ	Displays the Branch Costs Inquiry screen. Use this screen to view branch cost updates and related cost and quantity data for the product within a branch.