The purpose of this page is to help you create a new report from an existing report that gives you better summary and cross topic information. Specifically, we will take the Storage Detail Report and extend it to include sales data and replenish by product by warehouse as a means to identify under-performing stock.. We will use in-window reporting as a means to make the report much more interactive.
You can find the SQL and Pack In here.
2014-11-06 PM Open Discussion - Update RV_Storage to Include Sales and Replenish Data
This videos walks you through the process up extending RV_Storage (Storage Detail Report) to include sales and replenish data. This video is quite long because it brings you through the entire thought process including trial and error on SQL query. The query was created with phppgadmin.
2014-11-11 PM - Open Discussion
0:00:00 Take a SQL query and expose it as a Window
0:02:45 How to add created, createdby, updated, updatedby to a view where you cannot derive it from the existing data
0:05:00 Import the SQL view as an iDempiere Table and Column (Table & Column)
0:09:15 Expose the SQL view through a Window Tab and Field. This is a great technique to make your reports more interactive.
0:13:15 Add the window to your Menu
0:13:45 View the new report in your window
0:15:45 Adding a where clause to the Tab to limit records based on business logic
0:19:30 Adding subtabs with graphs to visualize data
0:21:00 Exporting your window and SQL so that someone else can have the same report
0:24:45 POS Tangent
0:31:15 Resume pack out of report
0:33:00 Take the report pack out (2pack) and pack in into a new environment
0:34:45 Deeper discussion about how to reporting with parameters
0:36:00 Product Category Tangent
0:39:30 Back to reporting with parameters
0:40:35 Using Alerts to send xls based report via email on a schedule
0:42:45 Using the slow moving stock report to optimize inventory movement
0:43:30 Warehouse visibility Tangent
0:46:00 Inventory Move between organization's interCo accounting consequences