UX One: Inventory Cost Analysis Page

The Inventory Cost Analysis page (P41001X/W41001XC) enables users to:

Monitor and manager item/lot cost on a monthly basis.
Track the cost of items across the years to monitor and manage inventory operational expenditure.
Easily access various inventory management programs.

To access the UX One Inventory Cost Analysis page, log in to the EnterpriseOne system using the Inventory Accounting Manager role. When you log in with this role, the system automatically displays the Inventory Accounting Manager page. Click the Inventory Cost Analysis task on the springboard to access the Inventory Accounting Manager page.

This graphic illustrates the Inventory Cost Analysis page.

Watchlist Alerts

These alerts are based on EnterpriseOne programs. By default, the alerts are set up to use queries that are based on delivered demo data. Each of these queries is associated with a specific program version. To use a different query or call a different program version, you can modify these queries or create new queries that better meet your requirements. Additionally, these watchlists have been set up with specific warning and critical threshold values. You can adjust these values to meet your requirements.

This table lists and describes the watchlist alerts that are available on the Inventory Cost Analysis page:

Watchlist Alert	Description
Items with Cost Undefined	This alerts the users about the number of items for which cost is not defined. The alert runs on the P41052 program where the Item Number (Cost File) is not defined. The watchlist considers item costs defined at the branch level. This alert is based on the Item Cost Inquiry program (P41052). When you click the alert, the system displays the Item Cost Inquiry form. The following grid format is available: Basic
Items with Price Undefined	This alerts the users about the number of items for which the price is not defined. The alert runs on the P41062 program where the Item Number (Price File) is not defined. The watchlist considers item costs defined at the branch level. It considers the item price for the branch level and does not consider the item group and customer group. This alert is based on the Item Price Inquiry program (P41062). When you click the alert, the system displays the Item Price Inquiry form. The following grid format is available: Basic
Obsolete Items	This alerts the users about the number of items that are currently obsolete. This alert is based on the Item Branch Inquiry program (P41027). When you click the alert, the system displays the Item Branch Inquiry form. The following form layout is available: Item Availability Inquiry The following grid format is available: Basic

Watchlist Alert

Description

Items with Cost Undefined

This alerts the users about the number of items for which cost is not defined.

The alert runs on the P41052 program where the Item Number (Cost File) is not defined. The watchlist considers item costs defined at the branch level.

This alert is based on the Item Cost Inquiry program (P41052).

When you click the alert, the system displays the Item Cost Inquiry form.

The following grid format is available:

Basic

Items with Price Undefined

This alerts the users about the number of items for which the price is not defined.

The alert runs on the P41062 program where the Item Number (Price File) is not defined. The watchlist considers item costs defined at the branch level. It considers the item price for the branch level and does not consider the item group and customer group.

This alert is based on the Item Price Inquiry program (P41062).

When you click the alert, the system displays the Item Price Inquiry form.

The following grid format is available:

Basic

Obsolete Items

This alerts the users about the number of items that are currently obsolete.

This alert is based on the Item Branch Inquiry program (P41027).

When you click the alert, the system displays the Item Branch Inquiry form. The following form layout is available:

Item Availability Inquiry

The following grid format is available:

Basic

For additional information about the programs associated with these watchlist alerts, see:

Setting Processing Options for Cost Revisions (P4105) in the JD Edwards EnterpriseOne Applications Inventory Management Implementation Guide.
Inquiry Programs for Inventory Management

Charts

These charts are based on EnterpriseOne programs. By default, the charts are set up to render using queries that are based on delivered demo data. Each of these queries is associated with a specific program version. To use a different query or call a different program version, you can modify these queries or create new queries that better meet your requirements.

This table lists and describes the charts that are available on the Inventory Cost Analysis page:

Component Title	Description
Average As Of Cost by Item and Fiscal Year (P41272X/W41272XA)	Use this chart to review the average as of cost by item and fiscal year, for a particular branch/plant. This chart is based on the One View Inventory Cost Analysis By Item As Of Inquiry program (P41272).
Average Cost of Item/Lot by Month (P41270X/W41270XA)	Use this chart to review the average cost of item/lot by month for a company. The chart displays the average cost for a particular item from various lots. This chart is based on the One View Average Cost Analysis from Item Ledger Inquiry program (P41270).

Component Title

Description

Average As Of Cost by Item and Fiscal Year (P41272X/W41272XA)

Use this chart to review the average as of cost by item and fiscal year, for a particular branch/plant.

This chart is based on the One View Inventory Cost Analysis By Item As Of Inquiry program (P41272).

Average Cost of Item/Lot by Month (P41270X/W41270XA)

Use this chart to review the average cost of item/lot by month for a company. The chart displays the average cost for a particular item from various lots.

This chart is based on the One View Average Cost Analysis from Item Ledger Inquiry program (P41270).

For additional information about the programs associated with these charts, see these topics in the JD Edwards EnterpriseOne Applications One View Reporting User Guide:

Springboard Tasks

You use tasks to access EnterpriseOne programs and other UX One pages. These tasks are included in a springboard on the page.

This table lists and describes the tasks on the Inventory Cost Analysis page:

Task	Description
Item Availability	Use this task to access the Item Availability - Work With Item Availability program (P41202). The following form layout is available: Sales Order Inquiry
Cost Revisions	Use this task to access the Cost Revisions - Work With Item Cost program (P4105).
Base Price Revisions	Use this task to access the Base Price Revisions - Work With Preference Base Price program (P4106).
Manual Inventory to G/L Reconciliation	Use this task to access the Manual Inventory to G/L Reconciliation - Manual Inventory to G/L Reconciliation program (P41500).
Item Ledger Inquiry	Use this task to access the Item Ledger Inquiry - Work With Item Ledger program (P4111)
Item Branch	Use this task to access the Item Branch - Work With Item Branch program (P41026).
Inventory Issues	Use this task to access the Inventory Issues - Work With Inventory Issues program (P4112).

For additional information about the programs accessed by these tasks, see these topics in the JD Edwards EnterpriseOne Applications Inventory Management Implementation Guide: