one view report samples inventory management
TRANSCRIPT
![Page 1: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/1.jpg)
One View Report Samples Inventory Management
![Page 2: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/2.jpg)
One View Reporting – Inventory Management
Introduction ....................................................................................... 1
Application: One View Average Cost Analysis from Item Ledger Inquiry P41270 .............................................................. 2
Report: Average Cost Analysis by Lot/Serial Number .................... 2
Report: Average Cost Analysis by Month/GL Date ........................ 4
Report: Average Cost Analysis by Branch Plant ............................ 6
Report: Average Cost Analysis ...................................................... 8
Application: One View Inventory Valuation Analysis Inquiry P41271 ................................................................................ 11
Report: Inventory Valuation by Item ............................................. 11
Report: Inventory Valuation by Branch Plant ............................... 12
Report: Inventory Valuation by Location ...................................... 14
Report: Inventory Valuation Analysis ........................................... 16
Application: One View Inventory Cost Analysis by Item As Of Inquiry P41272 ............................................................... 18
Report: Average As Of Cost by Item and Branch Plant ................ 18
Report: Average As Of Cost by Location and Lot......................... 20
Report: Average As Of Cost by Item and Fiscal Year .................. 22
Report: Average As Of Cost Analysis .......................................... 23
Application: One View Item Usage Trace Inquiry P41273 ................ 25
Report: Item Usage Trace by Item Branch ................................... 25
Report: Item Usage Trace by Item and Date ................................ 27
Report: Item Usage Trace by Week ............................................. 29
Report: Item Usage Trace Analysis ............................................. 31
![Page 3: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/3.jpg)
One View Reporting – Inventory Management
1
Introduction
JD Edwards EnterpriseOne One View Reporting enables end users to access data for
simple to sophisticated reports using EnterpriseOne find browse applications with BI
Publisher layout reporting and distribution features. One View applications combine
essential transaction and master data including associated descriptions and category
codes. Users have the ability to view data in the exact layout they desire using all the
advanced capabilities of Oracle BI Publisher.
One View Reporting provides a host of pre-defined reporting templates designed to
address some of the most common and highly demanded reports enabling you to
realize value on day one. Delivered reports can be personalized by end users as needed
and additional reports can be defined without IT support.
This document provides report samples delivered with One View for Inventory
Management.
For information on setting up and running the reports, see the JD Edwards
EnterpriseOne Applications 9.1 One View Reporting for Inventory Management
Functional TOI
![Page 4: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/4.jpg)
One View Reporting – Inventory Management
2
Application: One View Average Cost Analysis from Item Ledger Inquiry P41270
Business View: V41270A [One View Actual Cost Analysis - F4111 and F4101 join]
Report: Average Cost Analysis by Lot/Serial Number
![Page 5: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/5.jpg)
One View Reporting – Inventory Management
3
![Page 6: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/6.jpg)
One View Reporting – Inventory Management
4
Report: Average Cost Analysis by Month/GL Date
![Page 7: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/7.jpg)
One View Reporting – Inventory Management
5
![Page 8: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/8.jpg)
One View Reporting – Inventory Management
6
Report: Average Cost Analysis by Branch Plant
![Page 9: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/9.jpg)
One View Reporting – Inventory Management
7
![Page 10: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/10.jpg)
One View Reporting – Inventory Management
8
Report: Average Cost Analysis
![Page 11: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/11.jpg)
One View Reporting – Inventory Management
9
![Page 12: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/12.jpg)
One View Reporting – Inventory Management
10
![Page 13: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/13.jpg)
One View Reporting – Inventory Management
11
Application: One View Inventory Valuation Analysis Inquiry P41271
Business View: V41271A [One View Inventory Valuation Analysis - F41021 and F4101 join]
Report: Inventory Valuation by Item
![Page 14: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/14.jpg)
One View Reporting – Inventory Management
12
Report: Inventory Valuation by Branch Plant
![Page 15: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/15.jpg)
One View Reporting – Inventory Management
13
![Page 16: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/16.jpg)
One View Reporting – Inventory Management
14
Report: Inventory Valuation by Location
![Page 17: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/17.jpg)
One View Reporting – Inventory Management
15
![Page 18: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/18.jpg)
One View Reporting – Inventory Management
16
Report: Inventory Valuation Analysis
![Page 19: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/19.jpg)
One View Reporting – Inventory Management
17
![Page 20: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/20.jpg)
One View Reporting – Inventory Management
18
Application: One View Inventory Cost Analysis by Item As Of Inquiry P41272
Business View: V41272A [One View Actual Cost Analysis As Of - F41112 and F4101 join]
Report: Average As Of Cost by Item and Branch Plant
![Page 21: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/21.jpg)
One View Reporting – Inventory Management
19
![Page 22: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/22.jpg)
One View Reporting – Inventory Management
20
Report: Average As Of Cost by Location and Lot
![Page 23: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/23.jpg)
One View Reporting – Inventory Management
21
![Page 24: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/24.jpg)
One View Reporting – Inventory Management
22
Report: Average As Of Cost by Item and Fiscal Year
![Page 25: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/25.jpg)
One View Reporting – Inventory Management
23
Report: Average As Of Cost Analysis
![Page 26: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/26.jpg)
One View Reporting – Inventory Management
24
![Page 27: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/27.jpg)
One View Reporting – Inventory Management
25
Application: One View Item Usage Trace Inquiry P41273
Business View: V41273A [One View Item Usage Trace - F41021 and F4111 join]
Report: Item Usage Trace by Item Branch
![Page 28: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/28.jpg)
One View Reporting – Inventory Management
26
![Page 29: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/29.jpg)
One View Reporting – Inventory Management
27
Report: Item Usage Trace by Item and Date
![Page 30: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/30.jpg)
One View Reporting – Inventory Management
28
![Page 31: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/31.jpg)
One View Reporting – Inventory Management
29
Report: Item Usage Trace by Week
![Page 32: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/32.jpg)
One View Reporting – Inventory Management
30
![Page 33: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/33.jpg)
One View Reporting – Inventory Management
31
Report: Item Usage Trace Analysis
![Page 34: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/34.jpg)
One View Reporting – Inventory Management
32
![Page 35: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/35.jpg)
One View Reporting – Inventory Management
33
![Page 36: One View Report Samples Inventory Management](https://reader034.vdocuments.us/reader034/viewer/2022051403/58637cd11a28ab0e3090ab15/html5/thumbnails/36.jpg)
One View Reporting – Inventory Management
July 2013
Author:
Oracle Corporation
World Headquarters
500 Oracle Parkway
Redwood Shores, CA 94065
U.S.A.
Worldwide Inquiries:
Phone: +1.650.506.7000
Fax: +1.650.506.7200
oracle.com
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
This document is provided for information purposes only, and the contents hereof are subject to change without notice. This
document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in
law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any
liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This
document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our
prior written permission.