Forum Replies Created
-
Tey creating a group or changing the existing group. That may give you a sort
-
Part warnings is the best way. The problem is the control is on the company, not the part inside QC.
You could put auto notices in place that tell you if someone is quoting the part or just added it to an order. That would allow for a double check of proper paperwork in place.
One final thought.. make sure you review your expemptions. Even though the part is controlled under MT you can probably use license exemptions in many cases to avoid d the license all together.
-
I’ve never worked with them. We too have always used MSR . I will say Ambry Hill just finished integrating Vista-quote.com with MSR so Companies get screened automayically ss the RFQ arives.. before it’s even in Quantum . And there is a audit log type note system to record changes in the company status.
It’s also cheaper than going directly to eCustoms.
-
We have the same problem. There are several factors to consider when merging companies. Credit limits, Freight Accounts, Credit Card Accounts, etc. When we merge companies we do a review of the companies first to make sure we end up with the correct one.
That said, we also take a pro-active approach. When someone creates a new company, and automated notice is sent out to our Export Compliance and Accounting teams, as well as the person who created the account. The notice includes a check in the system for similar named companies which immediately identifies duplicate entries. If it is duplicate, the new company is deleted.
-
For clarity are you talking about receiving part quotes from UPS or processing shipments via UPS?
The replies seem to touch on both the EDI module and the Shipping Integration so I am a little confused.
Thank you in advance for the clarity. I am interested in this topic which is why I am asking.
-
Well dammit that is just too simple!
-
Ok. Did a little homework on this.
1. The correct SQL to update that inspection flag is
begin
update quantum set disabled_triggers=’T’;
update wo_bom wob set wob.lot_req_inspection =’T’ where wob.woo_auto_key=(select wo.woo_auto_key from wo_operation wo where wo.si_number=’E1039′) and wob.lot_req_inspection<>‘T’;
update quantum set disabled_triggers=’F’;
end;
However, it is a mute point.
2. In order for the items to appear in the RI module the stock not must be created. When manually entering the item and you select the require inspection flag it ONLY ads the item to the lot. This is BOM in the work order BOM table. NOTE: The lot uses the work order tables.
So, in order to achieve what you want, you need to do a Work Order BOM import probably through OCDia because the import through the grid is actually a STOCK import. Well, if the stock is imported the system sees that there is nothing to “receive” because the qty reserved is great than 0. So even if you do set the flag above, nothing will show in the RI module for processing.
Hopefully this clears it up.
-
Right click on the lot items grid and use that import function to get the product into the lot. Once in, you can use a simple sql statement
update wo_bom wob set wob.lot_require_inspection =’T’ where wob.woo_auto_key=(select wo.woo_auto_key from wo_operation wo where wo.si_number=’ENTER LOT NUM HERE’) and
wob.lot_require_inspection<>‘T’
There are a few ways to do this update statement, but I chose this way so all you need to know if your lot number.
Test the SQL statement out first in your test DB
-
Worthington Aviation
Moderator07/10/2018 at 6:36 AM in reply to: HOW DO YOU PUBLISH A CRYSTAL REPORT TO ALL USERS?We don’t bother with the Crystal functionality within Quantum. We use DataLink viewing http://www.milletsoftware.com/
-
Good to know. Sounds like a forms issue.
Perhaps you could create a crystal version and run that instead. Or vice versa if you are using the crystal, perhaps you could use the standard forms. IDK just a thought.
-
Are you receiving through the Receiving Inspection module or through the RO and PO modules directly?
Are you using a custom barcode label?
Is your barcode printer the default printer?
What make/model printer are you using?
Have you tried purging temp files and restarting your print spooler?
Does this happen if you log onto another computer with the same QC user?
Does this happen if you log onto the same computer with a different QC user?
Does this happen if you log onto the same computer with a different NETWORK user ?
-
Worthington Aviation
Moderator07/06/2018 at 7:39 AM in reply to: RETURN PARTS TO VENDOR – SHIPPING ORDERIt is one or the other. If you are using the shipping module you do NOT use the return parts to Vendor as the shipping order performs the functions of stock relieving and GL impacts.
Therefore, the process is as such..
1. Open PO
2. Global Menu
3. Create Shipping
4. Select Items To Return
5. Launch Shipping Order
In shipments, apply a closed shipment status that has the “Process Returns” final action set.
-
Worthington Aviation
Moderator07/05/2018 at 9:28 AM in reply to: AUTOMATING ADDING NEW USERS AND DISABLE LEAVERSAdding new users can be done fairly simply using VBScript. Ideally your script could monitor Active Directory, for example. If the AD user profile contains a specific flag to add to QC, then the script could execute SQL to insert the new user, apply templates, assign to status codes, etc.
I know this isn’t anything specific, but just pointing out that it could be done and could be automated and could use Active Directory objects to trigger the event of adding user to QC.
-
We use the capabilities flag on the master part and also the approved parts/vendors functionality.
-
We use v. 14.0.2 and have had no issues.
-
Worthington Aviation
Moderator07/03/2018 at 7:03 AM in reply to: HOSTING QUANTUM CLIENT THROUGH REMOTE APPPlease look at my old presentation called Going Remote. It outlines a remote environment. We have been using Terminal Server and later RDP servers to operate Quantum for about 15 years. We are now experimenting with alternative hosting options. The issue with using RDP is access to the DB for things like barcoding, external crystal reports, shipping integration, etc. Not to mention document scanning and photo taking. Most of this is covered in my old presentation.
Hope that helps
-
Worthington Aviation
Moderator04/27/2018 at 4:07 AM in reply to: SO RESERVE / CONSIGNMENT CODE LINKCan you just use where qty available >0 ?
If the stock line is reserved the quantity available will be different than qty on hand.
-
Worthington Aviation
Moderator04/27/2018 at 4:07 AM in reply to: SO RESERVE / CONSIGNMENT CODE LINKCan you just use where qty available >0 ?
If the stock line is reserved the quantity available will be different than qty on hand.
-
Pietro has a very nice Security tool available that was built by Kevin Otto. I suggest you take a look at what he has.
-
Here is a piece of code I wrote for the sales order header on click button event.
It looks at the SO due date and if the due date is changed it asks the user if they want to update the due date on all of the items on the SO . If the user cancels that prompt, it asks them if they want to update only items that have no due date. If they cancel that it does nothing.
This is an example of prompting the user for input and using the input to update data in QC.
var
UserString : String;
UserDate : TDateTime;
q: TOracleDataset;
Result : String;
X : String;
begin
if form.dataset.fieldbyname(‘phone_number’).asString=”then
begin
raise(‘A Phone Number Is Required For All Sales Orders’)
end;
if form.dataset.fieldbyname(‘DUE_DATE’).asString=” then
begin
raise(‘A Due Date Is Required For All Sales Orders’)
end;
q := TOracleDataset.Create(nil);
q.Session := Form.OCSession;
q.Sql.Text:=’select max(sod.sod_auto_key) from so_detail sod where sod.soh_auto_key= ‘ + Form.Dataset.FieldByName(‘soh_auto_key’).AsString;
q.Open;
X:= q.FieldByName(‘max(sod.sod_auto_key)’).AsString;
q.free;
if (form.dataset.fieldbyname(‘SDF_SOH_015’).asString<>Form.Dataset.FieldByName(‘DUE_DATE’).AsString) and (Length(X) > 1) then
begin
UserString:=Form.Dataset.FieldByName(‘DUE_DATE’).AsString;
if InputQuery(‘DUE DATE HAS CHANGED’, ‘Update ALL items with this Due Date? Date MUST be in MM/DD/YYYY format. Cancel For More Options.’, UserString) Then
begin
q := TOracleDataset.Create(nil);
q.Session := Form.OCSession;
q.Sql.Text:=’update so_detail sod set sod.due_date= To_Date(”’ + UserString + ”’,”mm/dd/yyyy”) where sod.qty_ordered >sod.qty_invoiced and sod.soh_auto_key= ‘ + Form.Dataset.FieldByName(‘soh_auto_key’).AsString;
q.Open;
q.free;
end
else
begin
if InputQuery(‘DUE DATE HAS CHANGED’, ‘Do you want to update ONLY items with NO Due Date? Date MUST be in MM/DD/YYYY format. Cancel for no updates.’, UserString) then
begin
q := TOracleDataset.Create(nil);
q.Session := Form.OCSession;
q.Sql.Text:=’update so_detail sod set sod.due_date= To_Date(”’ + UserString + ”’,”mm/dd/yyyy”) where (sod.due_date=”” or sod.due_date is null) and sod.qty_ordered > sod.qty_invoiced and sod.soh_auto_key= ‘ + Form.Dataset.FieldByName(‘soh_auto_key’).AsString;
q.Open;
q.free;
end
else
ShowMessage(‘No Change To Item Due Dates Will Be Made’);
end;
end;
end;
begin
end.
-
Worthington Aviation
Moderator04/05/2018 at 7:19 AM in reply to: DRILL / INSPECT FROM REPORT TO ITEM ?Hi Mike. If I were to do the approach I would take is to see if I could execute a .exe file on the local machine through the link feature within the report.
If that is possible, then I would create a VB Script that establishes a session with QC (QC would need to be running) and calls the inventory module open function specifying the PN. The PN would be passed to the VB script as a parameter, then in turn the VB script would use that parameter value (the PN) to pass to the inventory module .dll function.
You then create the executable out of the VB script using VBS Edit (that my preferred tool its free) – just make sure you compile it and create in 32 bit as the Oracle installation and QC are 32 bit applications.
Here is an example in FoxPro on how to set a session with QC and call the Shipping Order Pick Ticket print function.
The same can be accomplished in VB Script – the lcCustid parameter is the SM Number that is captured in a different function and passed to this function. The .DLL this function is using is qqsmrpt.dll which you can find in the QC folder. I believe for the inventory module it would be qqicmod.dll
To view functions in the .dll file you can use a tool like PE Explorer
http://www.heaventools.com/PE_Explorer_Exports_Viewer.htm
Hope this helps!
************************************************************
Function Print_Docs(lcCustid)
************************************************************
Qintf=Createobject(‘Quantum.sysMod’)
If Type(“qIntf”) <> “O”
Messagebox(“Failed to create quantum object – Make sure Quantum is running on this machine before running this program”,48,”Quantum.Object”)
Return
Endif
lcPrintDocCmd = “‘QQSMRPT.TQQSMRPT’,'”+ Alltrim(lcCustid) + “‘,’PICKTICKET’,”,”,””
** Messagebox(lcPrintDocCmd)
Qintf.PrintDocument(&lcPrintDocCmd)
Qintf=””
-
Worthington Aviation
Moderator04/04/2018 at 1:50 PM in reply to: DRILL / INSPECT FROM REPORT TO ITEM ?This is a way to invoke the inspections of items within QC from within a crystal report.
It would take some clever scripting but I think it would be possible. All you have to do is call the .dll and function within in and pass the correct parameters.
We do this with some bridges we have created and I see no reason why could not do through a link. It would not be easy though..
-
We use contact manager for several things, but it is clunky when it comes to straight up contact management. Depending on what you want out of your CRM I would do some comparisons with other solutions.
-
Worthington Aviation
Moderator03/23/2018 at 6:54 AM in reply to: EXCEL INSTRUCTION TO CONNECT TO DATABASEThis is sample of kit components query.
The header of this shows the connection string. Just copy this to a text file, save the text file as a .dqy file and it should open automatically in excel. Once open, you can save the excel file and it will remember the connection.
XLODBC
1
DRIVER={Microsoft ODBC for Oracle};UID=qctl;PWD=quantum;SERVER=MAXQPROD;
SELECT PN2.PN, PN2.DESCRIPTION,PN.PN, PN.DESCRIPTION,KT.QTY_ITEM “QTY”,PC.CONDITION_CODE FROM PARTS_MASTER PN, KIT_COMPONENTS KT, PARTS_MASTER PN2, PART_CONDITION_CODES PC WHERE PN2.PNM_AUTO_KEY=KT.PNM_AUTO_KEY AND KT.KIT_PNM_AUTO_KEY=PN.PNM_AUTO_KEY AND KT.PCC_AUTO_KEY=PC.PCC_AUTO_KEY ORDER BY PN2.PN
-
we switched all machines over to foxit. haven’t had issues since
-
LOL – I have to admit the light dim a bit with the Excel solution. 🙂
-
Hi Tim. We have multiple databases with multiple GLs. To make things more difficult, our GL structures are different in both DBs.
We have consolidated financials using a couple of tools. We have many reports created in Crystal Reports that pulls the data from both DBs into a single report. This can be accomplished by specifying the Schema name in your connections on the report. To make that even easier, I modified the TNS file to create a separate entry for each schema. That way I get the log in prompt for each of my DBs.
The second tool we use, and this is for an income statement, is MS Excel. What I did here was create a query that pulls in the GL details for each DB, each on a separate tab.
Then, on another tab I created a tab that identifies the consolidated groups I wanted my income statement to use for both DBs. This was then pointed to two setup sheets that I used to map the GL Accounts from each DB to the new consolidate group.
Once that is set up, two more sheets were created to sum up the credits and debits for each DB. From there, another sheet was set up to create the actual income statements.
It was a lot of work, but accounting loves it, it is a live connection and it works great.
Hope that helps.
-
Worthington Aviation
Moderator01/04/2018 at 6:48 AM in reply to: TRACKING PARTS ISSUED USING BARCODE SCANNERSThe audit trail on the actual stock line issued shows this information.
-
Worthington Aviation
Moderator12/20/2017 at 6:34 AM in reply to: ARRANGING INCOMING SHIP ORDERS/ SHIPMENTSThat is a complicated issue.
Off the top of my head, the only thing I can think of is to create a Receiving Inspection “Unknown Receipt” for the pending inbound shipment. THat would at least give it visibility for you to track.
Then, when it arrives your warehouse staff would match it up, complete the receipt and you are good.
The other option is to incorporate Contact Management into it, creating a contact for the pending inbound shipment.
-
Worthington Aviation
Moderator12/19/2017 at 6:47 AM in reply to: ARRANGING INCOMING SHIP ORDERS/ SHIPMENTSThis sounds a little confusing to me.
Shipments are for outbound shipments. Receiving Inspection module handles the inbound receipts.
The inbound PO, RO and SO Cores are managed by the party sending the product to us.
These would be managed as “open orders” and when they arrive at the dock, the receiving inspection module recognizes them as such.
If you are suggesting that the system some how automatically create a return shipment, I think that is more of a carrier function. UPS and FedEx both provide services where you can provide a return shipment label. We have tried this but it didn’t work that well.
-
Andrej ,
As you may, or may not know, Worthington paid for a major overhaul of the RMI module after AJ Walter funded the initial design. The combination of AJW and WAV efforts resulted in a very powerful tool for the industry to use. However, there are still improvements that need to be made.
With that said, earlier this year WAV funded more changes to the RMI that allows exchanges for pool parts or on demand parts to be processed through the sales order instead of being issued. This is a system setting that was introduced in version 10.8.26 . This change basically lets you treat a pool part like any other sales exchange, including the core depreciation settings. Here are the release notes associated to that. Hopefully this resolves your issue.
“New “Allow creation of Sales Order for Pool parts†setting has been added to the Inventory Module Settings. When this setting is checked, the functionality to create a sales order for Pool type parts using the Global > Create SO function is enabled. In order for pool type items to appear on the flagging screen for transfer to a sales order, a requisition with one or more stock line reservations must exist for the part and the usage must have a stock line selected in the Stock Pref field. Note: Be sure the stock line selected in the Stock Pref field has a sufficient quantity to fulfill the usage quantity. The quantity transferred and reserved to the sales order will be the quantity reserved to the usage. If the quantity of the stock line selected in the Stock Pref field is greater than the usage quantity, a stock reservation split occurs, and only the usage quantity is reserved to the sales order. Any remaining RMI reservation quantities are updated appropriately. Both stock reservations are displayed under the Stock tab in RMI. New “Item Type†and “Usage Qty†columns have been added to the “Flag Managed Inventory Parts†screen to identify item type (Pool/Demand) and usage quantities for pool type items. For RMI parts, both pool and on demand, marked as an exchange, every requisition created with a quantity greater than 1 will now automatically be split into a batch of requisitions, each with a quantity of 1.”
-
Thank you both for the feedback.
The work order is internal so I cannot invoice and I don’t want to convert to internal.
I will use the stored procedure. Appreciate it and thank you both again.
-
I am certain there is a better and easier way to do this, but if you don’t have too many warehouse codes, you can use this statement and replace the ?? WH1 (ect) with your warehouse names
select
pn.pn,
pn.description,
wl.qty_max,
wl.qty_min,
wl.reorder_cond_level,
wl.sdf_whl_001 “CD LVL DESC”,
whs.warehouse_code,
ap.application_code,
(select sum(stk2.qty_oh) from stock stk2 where st2.pnm_auto_key=pn.pnm_auto_key and whs2.warehouse_code=’?? WH 1′) “Warehouse 1”,
(select sum(stk2.qty_oh) from stock stk2 where st2.pnm_auto_key=pn.pnm_auto_key and whs2.warehouse_code=’?? WH 2′) “Warehouse 2”,
(select sum(stk2.qty_oh) from stock stk2 where st2.pnm_auto_key=pn.pnm_auto_key and whs2.warehouse_code=’?? WH 3′) “Warehouse 3”,
from
parts_master pn,
warehouse whs,
warehouse_level wl,
application_codes ap
where
wl.pnm_auto_key=pn.pnm_auto_key and pn.apc_auto_key=ap.apc_auto_key and wl.whs_auto_key=whs.whs_auto_key
-
After re-reading your post I see you are having trouble pulling in some data.
Question: Are you trying to pull in part numbers that do not have a warehouse level created yet? Or, are you trying to pull in parts that DO show a warehouse level created, but are at zero?
The second should show in your query, or mine. The first would not and would require either a sub select or an outer join.
-
Jim,
We built an inventory levels management tool using several sql statements (including alternates) that pull into excel, then used a variety of formulas and pivot tables to pull it all into a summary.
Here is a statement similar to the one we use to pull in our warehouse levels. We are heavy users of the condition levels which is why they are present. We used a UDF field in the warehouse levels table to allow us to create minimums by condition level.
Hope this helps.
select
pn.pn,
pn.description,
wl.qty_max,
wl.qty_min,
wl.reorder_cond_level,
wl.sdf_whl_001 “CD LVL DESC”,
whs.warehouse_code,
ap.application_code
from
parts_master pn,
warehouse whs,
warehouse_level wl,
application_codes ap
where
wl.pnm_auto_key=pn.pnm_auto_key and pn.apc_auto_key=ap.apc_auto_key and wl.whs_auto_key=whs.whs_auto_key
-
Although your approach will work, I recommend grabbing the auto key which can be obtain by editing a stock line that has the warehouse in question, press CTRL+F10 and copying and pasting the auto key.
Then, your statement might look something like this..
update stock set whs_auto_key=??? where whs_auto_key=??? and
qty_oh>0
Hope that helps.
-
I don’t think the BC unit works with the kitting module. We manually pull items for the kits here.
-
Can you post your query?
-
I am little confused by this question. FOB is an INCO term not a payment term. INCO terms are used to determine who pays customs duties, taxes, freight and insurance on the items being shipped. Not the actual purchase of the item. These are supposed to be defined in the “Delivery Terms” table in the sales order header, which flows to the shipping order. That is the intent of this field.
Furthermore, INCO terms are defined and managed by the International Chamber of Commerce are internationally recognized as freight and fees payment terms, but most carriers do not, will not, use all INCO terms and actually change what you input on the shipment to their own consolidated definitions. Which makes even less sense to tie invoice posting to the INCO term.
INCO terms are supposed to be the “instructions” for the customs agents, freight carriers, etc. as to who they should bill for those various fees. Hereto it isn’t always followed because, for example, if the person shipping the part puts FOB (which requires the buyer to pay the duties and taxes) but does not supply the account number of buyer then the seller pays the duties and taxes.
Lastly, there are INCO terms for different types of shipments. The INCO terms also define who pays transport costs from and to certain points during the transit. FOB is supposed to be used only for shipments going via water. If the shipment is being sent AIR then the closest INCO term would probably be FCA. For us, the most commonly used INCO terms are DDP and DAP and on occasion CIF. We rarely use FOB, but that is us.
For reference, here is a link to the latest 2010 INCO Terms sheet.
LATEST INCO TERMS
All of that being said, I would question why a company wants to recognize revenue based on INCO terms and not payment terms.
-
Hi Mike. The Kit Material List (Assembly List) printed from within the stock issue shows all but the PO number. Will that suffice?
If not, the tables you need are
wo_operation (kit header)
wo_bom (kit items)
parts_master
stock_reservations
stock
location
warehouse
part_condition_codes
For a basic query to pull the data for only reserved kit items, see below.
select wo.si_number,
wo.kit_qty,
pn.pn,
pn.description,
wob.qty_needed,
wob.qty_reserved,
str.qty_reserved,
stk.qty_oh,
pcc.condition_code,
loc.location_code,
whs.warehouse_code,
stk.stock_line,
stk.ctrl_number,
stk.ctrl_id,
stk.ORIGINAL_PO_NUMBER
from
wo_operation wo,
wo_bom wob,
parts_master pn,
stock stk,
stock_reservations str,
location loc,
warehouse whs,
part_condition_codes pcc
where
wob.woo_auto_key=wo.woo_auto_key and
wob.pnm_auto_key=pn.pnm_auto_key and
wob.wob_auto_key=str.wob_auto_key and
str.stm_auto_key=stk.stm_auto_key and
stk.pcc_auto_key=pcc.pcc_auto_key and
stk.loc_auto_key=loc.loc_auto_key and
stk.whs_auto_key=whs.whs_auto_key and
wo.wo_type=’Kit’
-
1. The BOM Quantities are determined at the time of kit creation. The answer to your question is Yes, you need to create a new kit with the desired quantity.
2. The “QTY Needed” column shows the total quantity needed based on the number of kits you are building. The QTY Needed is determined by the Kit Qty defined in the kit list of the Kit Part Number * total quantity of kits being built.
3. Scrolling to the right on the BOM list you should see quantities available. Compare that to the Quantity you have reserved and it should show you your shortages. From there, you can use purchase management to buy the stock you need.
As for picking the parts, you can print the pick ticket and use that to pull the parts that have been auto reserved. There are a variety of print options to filter on as well.
-
Worthington Aviation
Moderator10/19/2017 at 7:04 AM in reply to: TRACKING FREIGHT COSTS ASSOCIATED WITH MANAGED INVENTORYWe track all freight costs against it’s order in QC.
Even so, to make it easier we set up dedicated accounts for each program if we are responsible for shipping costs.
-
Interesting approach.
We save the Schedule B code in the field called Custom Code on the part master- which is the original intent of that field.
With regards to multiple codes for different countries, you are correct in that. However, we have found the majority of the countries we service accept the US codes which are along NATO standards. Basically, US companies really only need to worry about the outbound code accepted by US Customs whereas the inbound code is the responsibility of shipper.
If you are using the US system to define the codes, a product can only be classified as one thing, one code. If your multi code approach is being populated from schedule lists of other countries.. again very clever.
We have never had an issue using only the schedule B code with the exception of a handful of shipments over my 13 years here at Worthington.
Here are some good reference material
https://2016.export.gov/california/sanfrancisco/qa/hssb/index.asp
-
By Tariff Codes I assume you mean the Harmonized Code or the Schedule B code.
The best source by PN for this that I have found is the WebFlis data, Defense Logistics. But if the government has not dealt with the part then it wont be listed. However, see my note at the bottom.
https://public.logisticsinformationservice.dla.mil/PublicHome/webFLIS/default.aspx
That said, we typically default to 8803.30.0010 Schedule B Code
CHAPTER 88 – AIRCRAFT, SPACECRAFT, AND PARTS THEREOF
There is a search engine for this as well
https://uscensus.prod.3ceonline.com
Now, the government LOVES to make things hard. There is a Schedule B code and a Harmonized Tariff Code. One is for imports, one is for exports. the Schedule B code is managed by the US Census Bureau
whereas the HSC code is managed by U.S. International Trade Commission
Their search engine is https://hts.usitc.gov/
We don’t both with assigning the HSC code, we only put the Schedule B code in Quantum.
You will NOT find a search engine by part number. All code assignments are based on commodity description.
The good news, there is a cloud based service that will be introduced in the next year that will address this issue along with a great deal more challenges faced by aviation companies in dealing with industry data of all sorts.
-
Worthington Aviation
Moderator09/28/2017 at 7:20 AM in reply to: BPM SOFTWARE & QUANTUM – PROCESS MININGMost likely not for Worthington. However, the visual aspects of it are very attractive.
One of biggest reasons I say not is because we are very pro active in our process analysis. What I mean by this is that we use what I like to call electronic kanbans . If we have an escape in our process, an alert is generated within minutes notifying the users of the escape. Or, we use the proactive alerts as part of the process in order to avoid the escape in the first place.
As mentioned earlier, these become the talking points in our process review activities in our weekly meetings.
This tends to keep the processes on track much better instead of doing reviews of the data in bulk.
One downside to this approach is that you can find yourself going down a rabbit hole for an issue that was temporary. So, it takes discipline in all participants to identify these escapes as patterns and not exceptions.
Software packages like this are great at laying out the process chain and make it easier for staff to understand where the fall outs might be, after the fact.
I think the bottom line is the value it might bring for the following reasons and if that is what you are looking for..
1. Value because there is no effective process analysis systems are currently in place. Processes are, but not the analysis portion.
2. Value through Monies gained through times saving of using the system vs. creating your own analysis reports.
3. Value through Monies gained through worker productivity as a result of process improvements that were identified by the easy to understand interface.
-
Worthington Aviation
Moderator09/27/2017 at 6:56 AM in reply to: BPM SOFTWARE & QUANTUM – PROCESS MININGWe are a very process oriented company, reviewing processes almost weekly and changing as needed.
The biggest contributor to effective process management from the perspective of the data is the input. I think systems like the one you mentioned are great. However, in order to identify gaps in your process you must have an effective process in place to capture the data that the mentioned system measures. It can be a bit of chicken and egg thing. I think these systems are very effective in refining current processes if the data they measure is accurately captured.
Here is an example.
Part goes to vendor for repair estimate. Ship date is recorded.
Event 1 Date= 1-1-2017
Vendor quotes the repair .
Event 2 Date= 1-5-2017
Repair Administrator records the estimate but tells the vendor to hold the repair for now. Quote date is recorded
Event 3 Date = 1-5-2017
Repair Administrator approves the estimate for repair and authorizes repair. Approval date is recorded.
Event 4 Date = 1-12-2017
Vendor repairs part and ships back you
Event 5 Date = 1-14-2017
You receive part. Receive date is recorded.
Event 6 Date = 1-16-2017
So, if you are measuring vendor performance, which dates do you use to accurately record their turn around times?
You must record all event dates in order to effectively measure. We capture most of these dates and measure our vendor’s performance on Quote turn around time based on the difference between first ship date and the date the quote was recorded. We measure vendor’s repair time based on the difference between the date the quote was approved and the date we receive the part.
My point is, the very scenario that the mentioned software provides as an example where it identifies if you are losing a week’s time to ship a part is great. But you must be recording the data accurately for it to measure. In order to do this you must already have a process in place.
If you have this process in place.. a report can easily be created to measure that metric.
My apologizes if this appears to be a soap box lecture 🙂
-
For what it’s worth, we have moved away from Scanners and Web Cams all together.
We currently use the Microsoft Office Lens app. We have several old iPhones that we purchased and connected via wifi. The phone is used to photo the parts and the paperwork. The straightening and cropping of the paperwork images is very impressive. You can take up to 10 photos per 1 PDF document. The PDF document then gets synchronized to OneDrive on the users computer. The user then drags and drops the files into QC Imaging and deletes them afterwards, leaving the OneDrive empty and ready for the next set.
Because of the quality of the pictures, the mobility of the app, the cost (free) it has been great for us. We use it in all of our facilities which makes remote scanning and photography very easy. For the remote sites, we set the OneDrive up on the Terminal Server (each user has their own) and the PDF’s synchronize directly to the Terminal Server session, way quicker than using RemoteScan or the ScrewDriver’s for scanning software.
We are investigating trying the new imaging app that was introduced at the QUE Group Conference, but for the cost and the fact that it does not crop the document images we are hesitant as the only thing it would do for us over our current solution is to insert the images directly to the record in QC.
Anyway, something to think about.
-
I will share the custom form is you email me.
-
Hi everyone, I have sent you all information on the proposed changes to the VQ Wizard.
If anyone else is interested, please let me know.
-
Yep – that is the one I was referring to. Very happy for Cole. He is a great friend and he is getting to do what he has always wanted. We should wish him the best of luck.
Let me know if you want to have further discussion on the VQ Wizard to explain in more detail what the mods are. Worthington is willing to pay for the evaluation in order to come up with the quote which would be shared. I may have AIR and possible ANSETT interested in the mods as well.