search

bezlio / bezlio-gallery

Collection of bezls that you can import and use in your Bezlio account
MIT License
3 stars 0 forks source link

Purchasing - Consumable Material Quantity On Hand - Cylinder Gauge #22

Open aellis opened 7 years ago

aellis commented 7 years ago

The idea behind this one is to have some consumable material (let's say, bolts) that a given work center or purchasing agent needs to really stay on top of. So we will present that as a Cylinder Gauge from here: https://www.fusioncharts.com/charts/gauges/. When installing this Bezl there should be a variable for the part number that is blank initially. The, upon first run, we detect that, prompt for a part ID, and then going forward that is baked in (use the bezl update functions to update the variable). I'd envision some users having a screen full of these for different consumable parts and they would just repeat this installation process for each. The Excel file should just be parts and quantities and we will need to pull in the whole file and filter onDataChange. The Epicor and Visual queries will have inputs for part number so they just return one row (data subscription to utilize bezl.vars) so the part filtering onDataChange will not do anything substantive but won't do any harm.

aellis commented 7 years ago

Oh, and here was the description of what the query will return:

Description: This query should take a raw material and return a single row with the quantity on hand, min quantity, and max quantity. For now just hard code it to a single part but the Bezl will make this dynamic.

aellis commented 6 years ago

Updated query to conform to standards specified to Raman:

Consumable Material Quantity On Hand.txt

gramang commented 6 years ago

@aellis Updating the Oracle Apps Query for this, Please note this is for Oracle Apps Consumable Material Quantity On Hand.txt