Forum Replies Created

Page 1 of 20
  • Worthington Aviation

    Moderator
    11/25/2018 at 2:56 AM in reply to: SORTING DATA IN REPORT DESIGNER

    Tey creating a group or changing the existing group. That may give you a sort

  • Worthington Aviation

    Moderator
    09/05/2018 at 5:20 AM in reply to: EXPORT CONTROL ON PART NUMBER

    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.

  • Worthington Aviation

    Moderator
    08/07/2018 at 4:31 AM in reply to: EXPORT COMPLIANCE CONSULTANT

    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.

  • Worthington Aviation

    Moderator
    07/26/2018 at 6:50 AM in reply to: CLEANING UP COMPANIES

    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.

  • Worthington Aviation

    Moderator
    07/18/2018 at 6:42 AM in reply to: UPS EDI MANDATE JUNE 1, 2018

    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.

  • Worthington Aviation

    Moderator
    07/16/2018 at 2:57 PM in reply to: IMPORTING ITEMS

    Well dammit that is just too simple!

  • Worthington Aviation

    Moderator
    07/16/2018 at 9:29 AM in reply to: IMPORTING ITEMS

    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.

  • Worthington Aviation

    Moderator
    07/16/2018 at 6:33 AM in reply to: IMPORTING ITEMS

    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

    Moderator
    07/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/

  • Worthington Aviation

    Moderator
    07/06/2018 at 12:25 PM in reply to: BLANK BARCODE LABELS

    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.

  • Worthington Aviation

    Moderator
    07/06/2018 at 7:48 AM in reply to: BLANK BARCODE LABELS

    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

    Moderator
    07/06/2018 at 7:39 AM in reply to: RETURN PARTS TO VENDOR – SHIPPING ORDER

    It 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

    Moderator
    07/05/2018 at 9:28 AM in reply to: AUTOMATING ADDING NEW USERS AND DISABLE LEAVERS

    Adding 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.

  • Worthington Aviation

    Moderator
    07/05/2018 at 9:24 AM in reply to: INTERNAL CAPABILITIES

    We use the capabilities flag on the master part and also the approved parts/vendors functionality.

  • Worthington Aviation

    Moderator
    07/05/2018 at 9:23 AM in reply to: CRYSTAL REPORT VERSION

    We use v. 14.0.2 and have had no issues.

  • Worthington Aviation

    Moderator
    07/03/2018 at 7:03 AM in reply to: HOSTING QUANTUM CLIENT THROUGH REMOTE APP

    Please 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

    Moderator
    04/27/2018 at 4:07 AM in reply to: SO RESERVE / CONSIGNMENT CODE LINK

    Can 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

    Moderator
    04/27/2018 at 4:07 AM in reply to: SO RESERVE / CONSIGNMENT CODE LINK

    Can 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

    Moderator
    04/18/2018 at 3:04 PM in reply to: SECURITY CODES

    Pietro has a very nice Security tool available that was built by Kevin Otto. I suggest you take a look at what he has.

  • Worthington Aviation

    Moderator
    04/18/2018 at 7:01 AM in reply to: CUSTOM POP-UP WINDOW

    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

    Moderator
    04/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

    Moderator
    04/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..

  • Worthington Aviation

    Moderator
    03/26/2018 at 7:09 AM in reply to: CONTACT MANAGER VS EXTERNAL CRM

    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

    Moderator
    03/23/2018 at 6:54 AM in reply to: EXCEL INSTRUCTION TO CONNECT TO DATABASE

    This 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

  • Worthington Aviation

    Moderator
    03/06/2018 at 8:12 AM in reply to: DOC/IMAGES

    we switched all machines over to foxit. haven’t had issues since

  • Worthington Aviation

    Moderator
    02/07/2018 at 8:06 PM in reply to: FINANCIAL STATEMENT CONSOLIDATION

    LOL – I have to admit the light dim a bit with the Excel solution. 🙂

  • Worthington Aviation

    Moderator
    02/06/2018 at 6:59 AM in reply to: FINANCIAL STATEMENT CONSOLIDATION

    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

    Moderator
    01/04/2018 at 6:48 AM in reply to: TRACKING PARTS ISSUED USING BARCODE SCANNERS

    The audit trail on the actual stock line issued shows this information.

  • Worthington Aviation

    Moderator
    12/20/2017 at 6:34 AM in reply to: ARRANGING INCOMING SHIP ORDERS/ SHIPMENTS

    That 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

    Moderator
    12/19/2017 at 6:47 AM in reply to: ARRANGING INCOMING SHIP ORDERS/ SHIPMENTS

    This 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.

  • Worthington Aviation

    Moderator
    11/28/2017 at 8:34 AM in reply to: B2B EXCHANGES WITH RMI AND SALES

    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.”

  • Worthington Aviation

    Moderator
    11/28/2017 at 8:04 AM in reply to: RECONCILING MAIN COMPONENT

    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.

  • Worthington Aviation

    Moderator
    11/27/2017 at 11:11 AM in reply to: SIMPLE STOCK REPORT

    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

  • Worthington Aviation

    Moderator
    11/22/2017 at 6:56 AM in reply to: SIMPLE STOCK REPORT

    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.

  • Worthington Aviation

    Moderator
    11/22/2017 at 6:53 AM in reply to: SIMPLE STOCK REPORT

    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

  • Worthington Aviation

    Moderator
    11/17/2017 at 7:02 AM in reply to: UPDATE SQL

    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.

  • Worthington Aviation

    Moderator
    10/31/2017 at 6:54 AM in reply to: KIT QUESTIONS

    I don’t think the BC unit works with the kitting module. We manually pull items for the kits here.

  • Worthington Aviation

    Moderator
    10/30/2017 at 12:57 PM in reply to: PART HISTORY REPORT WITH COST

    Can you post your query?

  • Worthington Aviation

    Moderator
    10/25/2017 at 7:32 AM in reply to: FOB REVENUE RECOGNITION

    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.

  • Worthington Aviation

    Moderator
    10/23/2017 at 6:47 AM in reply to: KIT QUESTIONS

    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’

  • Worthington Aviation

    Moderator
    10/19/2017 at 12:13 PM in reply to: KIT QUESTIONS

    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.

  • We 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.

  • Worthington Aviation

    Moderator
    10/06/2017 at 7:05 AM in reply to: TARIFF CODES

    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

    https://www.census.gov/foreign-trade/schedules/b/index.html

  • Worthington Aviation

    Moderator
    10/05/2017 at 7:13 AM in reply to: TARIFF CODES

    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

    Moderator
    09/28/2017 at 7:20 AM in reply to: BPM SOFTWARE & QUANTUM – PROCESS MINING

    Most 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

    Moderator
    09/27/2017 at 6:56 AM in reply to: BPM SOFTWARE & QUANTUM – PROCESS MINING

    We 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 🙂

  • Worthington Aviation

    Moderator
    09/20/2017 at 7:14 AM in reply to: DOCUMENT IMAGING SCANNING

    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.

  • Worthington Aviation

    Moderator
    09/14/2017 at 6:47 AM in reply to: COMMERCIAL INVOICE – CUSTOM FORM

    I will share the custom form is you email me.

  • Worthington Aviation

    Moderator
    09/12/2017 at 10:02 AM in reply to: GRIPE!

    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.

  • Worthington Aviation

    Moderator
    09/08/2017 at 12:55 PM in reply to: GRIPE!

    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.

Page 1 of 20