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.
![Inventory Cost Analysis page](images/inv_acc_mgr_cost.png)
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:
|
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:
|
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:
The following grid format is available:
|
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.
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). |
For additional information about the programs associated with these charts, see these topics in the JD Edwards EnterpriseOne Applications One View Reporting User Guide:
One View Average Cost Analysis from Item Ledger Inquiry (P41270)
One View Inventory Cost Analysis By Item As Of Inquiry (P41272)
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:
|
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: