The purpose of this page is to archive previously recorded videos. If you are new to the class and you want to review previous discussions. Start from the bottom of the archive page (first recording) and work your way up.
2015-07-23 - Next Generation Installation Script Changes
Removed ability to pull from sf.net - always pull from a Jenkens server.
Pull iDempiere from any jenkins server/project
Install directly on AWS RDS
Created parameter file for advanced installation options
Added ability to install a services only server (used when load balancing)
Change the DB name from "idempire" to something more secure
Change the DB username from "adempire" to something more secure
Install from development branch (3.0)
Enhancements to support scripts (backup, restore, upgrade, etc...)
2015-07-16 Open Discussion for Reusing Products Item Codes for Seldomly Used Products
Situation: someone get orders for products that they rarely use (if not ever before). In the event that a request for a unique product happens, the user does not want to create a unique product in the product master because it may not ever be purchased again. What to do…
Update: given the circumstances and iDempiere's ability to manage lots, I do not believe I would use a non-stocked product. I would go ahead and let the system track the lot inventory.
2015-07-14 Time #3 - Development Environment with Pack Out - Pack In - 2Pack
Includes special considerations for changes to complex windows like Sales Orders.
2015-07-07 Open Discussion - Gaurav - Attribute Set Instance Costing and Merging
Discusses how to manage costing within an Attribute Set Instance where you have logical quality-based price differences inside a single ASI (lot/batch costing).
Also discusses how to take RMAs across multiple Attribute Set Instances and consolidate them into a smaller group of new Attribute Set Instances.
2015-06-30 Automate MR and VI from Completed PO Continued
2015-06-25 Automating Material Receipt Completion Upon Purchase Order Completion Discussion
2015-06-16 - Business Partner Open Report - Including Allocated documents in the last X days
2015-05-07 Open Discussion Time #1
This discussion demonstrations how to rename the SalesRep field on the request window. It also shows you how to make the user not required where you can simply send to a role (not a specific user).
Training group note about system email when no user is specified
2015-04-28 AM Open Discussion Time #1
Dave consignment questions about modifying a core callout (CalloutOrder), Material Receipt => Create Lines From, etc... - answered from an integrator's perspective.
Business Intelligence (BI) choice discussion (Pentaho, Spago, Microstrategy, Tableau, etc...)
2014-04-23 Open Discussion - Customize Core iDempiere and Deploy to Local Server
2015-04-07 AM Open Discussion
0:00:00 Fitnesse - how to create lots of PO, MR, VI, Payments, etc...
0:06:00 - relationship between product, business partners and price lists
0:08:00 - introduction to fitnesse tests
0:22:30 - Fitnesse resumed - review example tests
0:18:00 monthly invoice consolidation
0:45:00 Invoice consolidation continued
0:26:30 Rumman's debug of why report is showing multiple records - not limiting by ad_pinstance_id
0:57:30 Push plugin to bitbucket - taking a long time
0:54:00 BOMDrop update
2015-03-19 - AM Open Discussion - Component Definition for Plugin Process
2015-03-10 PM Open Discussion - Advanced Replenishment Topics
2015-03-12 AM Open Discussion - Introduction to Plugin Development
Introduction to Document Validation
Document validation is an iDempiere plugin that helps you prevent human error. It gives you the ability to create validation tests that:
offers the user detailed feedback about the document (info)
requires the user to accept "potentially" incorrect situations (warn)
prevents the user from acting on known incorrect situations (fail)
Installation
Download the installation files from the Document Validation Base project => Source link => downloads folder
Install the 01_plugin (jar) via the felix console with a start level of 5
Install the 02_packin (zip) to create the main windows and configuration.
Install the 03_packin (zip) to add configuration records in the configuration tables (created in the previous step)
Download the installation files from the Document Validation Sample project => Source link => downloads folder
Install the plugin (jar) via the felix console with a start level of 5
Open the Table and Column window => find the "C_Order" record => open the Tab sub-tab
Create a new Column record with a system element of "ChuBoe_Validate" and a process of "Document Validation".
NOTE - com.chuboe.validation.base.event => MyEventHandler.java shows all the tables you can add "ChuBoe_Validate" to. Doing so automatically invokes validation during the DocAction.
Log in as your business client admin. NOTE: be sure to see the demo below for more details!
Create a Standard Order => Sales Order record with one charge line (no product).
Validate the Sales Order to see the issues. Open the Document Validation window to see the detailed results.
Complete the Sales Order to see validation automatically invoke.
Remove or modify the Sample project (via felix console) to remove the sample validation tests.
Document Validation Version 2
0:00:00 Introduction
0:01:45 Design Diagram - What is Document Validation
0:08:00 Demonstration in iDempiere
0:11:45 Why make validation a completely separate tab?
0:15:30 Questions about validation creation and approval
0:22:00 Table & Column => Logging was not originally enabled. This issue has been fixed.
0:22:15 Why put validation in code?
0:30:30 Validation Levels (INFO, WARN, FAIL)
0:31:30 Examples of how to use Validation
0:37:30 Design architecture discussion (OSGI service lookup)
0:40.15 Export Pack Out and Jars from code
0:44:30 Deploy Pack In and Jars via Felix Console
note: the issue in the video occured because I did not restore my environment properly. I later tested in a new environment - all worked properly as demonstrated.
2015-02-26 AM Open Discussion
0:00:00 - Rumman - development environment
how to connect via Remote Desktop
installation feedback file
0:03:45 - Rumman - updating your code to reflect the code from your production/test installation
0:16:15 - Evan - Choosing between AWS RDS and hosting your own Postgresql
0:23:30 - Evan - Options for VPN to help protect your iDempiere instance
0:28:45 - Hans - Search Foreign Key Search from Asset to OrderLine
0:33:15 - Evan - Variance between PO & VI price and MR & VI quantity
2015-02-10 AM - Open Discussion
This discussion shows you an advanced way to dynamically limit results in a window based on a user's role and the field in a given tab. Specifically, how to prevent certain roles from see the cash book entries of certain organizations. This is a very powerful concept.
2015-01-29 PM - Open Discussion
0:00:00 User Interface changes - hiding fields
0:05:30 Hiding options in a reference list
0:08:00 Options for creating an Invoice when the system creates a Shipment
0:10:30 Project Manufacturing discussion - including quick demo of the Project Line BOM Explode feature
0:06:15 Using the key strokes to navigate the Product Info window
0:10:15 How to create a Payment Terms to set to "Last Day of the Month"
0:15:30 How to delete a line after an order is either prepared or completed
0:18:30 Unit of Measure (UOM) - options for selling a partial pack. Example: case of soda (24 cans). How to sell 23 cans. Either add a UOM conversion or create a process to help users create a new product code.
2015-01-20 AM - Open Discussion
Unfortunately, the first meeting did not record
0:00:00 Product Info - Available to Promise
0:06:00 Create copies of Orders
0:06:45 When should you complete a Sales Order or Purchase Order
0:10:15 Adding a Print Invoice button to a Shipment
2015-01-15 AM - Open Discussion
0:00:00 Create document numbers that are specific to a given organization
0:04:45 Quick look at code (you can skip)
0:08:00 Documentation on new iDempiere feature that does exactly what Rumman wants
0:12:30 How context helps dynamically create a unique document based on the org's name/value
0:23:45 Gaps in document sequences
0:24:45 How to find when a document changes document number or field values
0:29:15 How to perform date math/functions using context (@SQL).
select * from ad_column where lower(defaultvalue) like '%sql%'
2015-01-13 PM - Open Discussion
0:00:00 Using Project to support manufacturing
Use Phase Line as plan or budget
Use Project Issue as actual
Use of Resource Allocation
0:02:30 Go on tangent to discuss "What is a Resource?"
0:05:30 Add S_Resource_ID column to the C_ProjectPhase table
0:10:15 Resource Type
0:11:00 Limitations of Resource Assignment
0:17:30 M_CostDetail (Cost Detail) discussion
0:30:00 Gantt chart for iDempiere Project (ZK and LibrePlan)
2015-01-13 AM - Open Discussion
0:00:00 Debug why Print Format does not respect Report View => Order By field (answer)
0:17:00 Using iDempiere Project to support manufacturing - getting each product/resource to post to the correct account
0:28:00 Illutrate how to add a Document Status (docstatus) field to the C_ProjectIssue (Project Issue) table to give the user the ability to manually post a record.
2014-12-08 AM - Open Discussion
0:00:00 Create an "Order Delivered by not Invoiced" Report from scratch.
The purpose is to help you see that orders were delivered but not invoiced.
A Report View is created for the RV_OrderDetail table with a special where clause (qtydelivered > qtyordered).
0:21:00 Using a "Resource" in a Bill of Material (BOM) - quick test