Product Scan Customization Example

The purpose of this tutorial is to give you an end-to-end example of customization. End-to-end refers to using many of the developer tools at our disposal to enhance the system.

2014-03-06 AM Meeting - Technology Session #1 (ppt)

Created Scan Table and Column
Created Scan Window, Tab and Field
Create SCan Menu
Added Product and MRLine fields and defaults
Added to MRLine tab/window

2014-03-06 PM Meeting - Technology Session #2 (ppt)

Add to Shipment Window
Add movement type reference to Scan
Create view to calculate qty from move type
Created window to see totals

--chuboe_scan_v - calculates multiplier and adjusted qty (qty * multiplier)
CREATE OR REPLACE VIEW chuboe_scan_v as 
SELECT chuboe_scan.ad_client_id, chuboe_scan.ad_org_id, chuboe_scan.chuboe_scan_id, chuboe_scan.chuboe_scan_uu, chuboe_scan.created, chuboe_scan.createdby, chuboe_scan.description, chuboe_scan.isactive, chuboe_scan.name, chuboe_scan.updated, chuboe_scan.updatedby, chuboe_scan.m_inoutline_id, chuboe_scan.m_product_id, chuboe_scan.qty, chuboe_scan.movementtype,
 CASE
 WHEN "position"(chuboe_scan.movementtype::text, '+'::text) = 0 THEN (-1)
 ELSE 1
 END AS multiplier,
 CASE
 WHEN "position"(chuboe_scan.movementtype::text, '+'::text) = 0 THEN (-1)
 ELSE 1
 END::numeric * chuboe_scan.qty AS qty_adj
 FROM chuboe_scan
 ;

--chuboe_scan_sum_v - sums adjusted qty grouped by product and scan. answers question "How many in stock"
CREATE OR REPLACE VIEW chuboe_scan_sum_v AS
SELECT sum(chuboe_scan_v.qty_adj) AS qty_adj, chuboe_scan_v.m_product_id, chuboe_scan_v.name, 100 AS createdby, 'now'::text::date AS created, 100 AS updatedby, 'now'::text::date AS updated, 0 AS ad_org_id, chuboe_scan_v.ad_client_id
FROM chuboe_scan_v
GROUP BY chuboe_scan_v.m_product_id, chuboe_scan_v.name, chuboe_scan_v.ad_client_id
;

2014-03-11 AM Meeting - Technology Session #3 (ppt)

Setup new development environment
- New server with Development Env
- Dev env setup demonstration (see last)
- Pack Out and Pack In existing changes
- Create Plugin (ADempiere: Create Customization)
Pack Out and Pack In
Create plugin
Started plugin

2014-03-11 PM Meeting - Technology Session #4 (ppt)

This session did not go as smoothly as I had hoped. The problem domain proved to be a little tougher to explain than I had hoped.

Create Column SQL to derive Lot
Test concept (MR to Shipment)
Re-Generate Model for Scan
Expose model using MyModelFactory
Create Process
Generate Model for Lot
Scan afterSave() ==> Lot instance for scan
Create Lot T&C and WT&F
Add Lot to MRLine and Scan

2014-03-13 AM Meeting - Technology Session #5 (ppt) Model Validator

2014-03-13 PM Meeting - Technology Session #6 (ppt) Processes in Depth

2014-03-18 AM Meeting - Technology Session #7 (ppt) Migration to new Prod Environment

Export Pack Out and Export Plug In - Install on New System via Felix Console in one step

2014-03-18 PM Meeting - Technology Session #8 (ppt) Pull Plugin Code into New Dev Environment

Notes:

Use iDempiere code (Plug In) found in Bitbucket and install as plugin in iDempiere.
If you get a permissions error ("Cannot access Process") when you try to use your new plugin, run the "Role Access Update" process. This will give your roles access to any windows, processes, etc.. that were missed during the Pack In process. Please note this only affects roles where Manual = "N" or not checked.