Vicky
Forum Replies Created
-
It doesn’t seem like it’s the fetch size, Pietro. They can open a PO or WO, but as soon as they click on a stockline or try to add a part Quantum freezes up.
-
We have a similar technical setup to David. We have a separate company. The headquarters is located in Colorado and the sales people are located in California. The sales people VPN and RDP into a terminal server in Colorado.
Our Quantum setup is a bit different than David’s because these are two separate companies on the same server rather than one company with two locations. Quantum is set up to house the two companies by using two separate schemas on the same server. -
Warnings on parts on the BOM would be helpful, i.e., parts that will be customer supplied.
-
You can change it through SQL:
UPDATE wo_operation
SET wo_type = ‘Internal’
WHERE si_number = ‘WO123456’
Make sure to change your work order number and commit changes after you run the query. You can do the opposite also — change the WO type to External from an Internal WO. -
Vicky Carlson
Member05/03/2021 at 1:36 PM in reply to: WORK ORDER BILLING STATUS — NEED 2 DEFAULTS FOR PARTIAL AND FULL BILLINGHello, Kristen,
We do have a workaround, but wish that Component Control would make the changes to the process.
1. For the status of the work order post billing, we decided to always leave it at the closed status since we usually issue full billings. For partials, we have made it part of our procedure to change the work order status back to an open status after we issue the bill.
2. For the issue with the duplicate billing number, Quantum creates both a work order quote billing and in the background it creates an invoice. The second invoice number cannot be the same as the first invoice number, and the user will be prompted to enter a different invoice number. We then print the work order billing and use Adobe DC to edit the work order billing to use the second invoice number (we usually add a -1 to the end of the billing number). It’s cumbersome, but it works for us.
-
It is a tricky one — it is not under Company Management. The security setting is under User Settings > View Lookups Historical Data (code 1730).
-
We use it all the time. We take pictures of the components when they come in the door, then we take pictures of the issues we find, and then again right before the part is sent out. It is very easy to use and I think it is one that is worth the cost. It took a while to get it set up properly, but since then we have had no problems at all with the module itself.
-
I have attached a Powerpoint that Component Control gave me on the Physical Inventory module. It has details of how to run a physical inventory that aren’t provided in their help manual.
-
I had an issue where I got different results from a SQL query in our live database than I did in our test database. The test database is copied weekly from live, so the results should have been nearly the same. Component Control reset my user profile in the live database and that fixed the issue. That might be another thing to try.
-
It probably has to do with registry settings. There is a common known issue with Crystal Reports that it will only return a certain number of records. I had to change the registry settings for a few users for reports that wouldn’t return records. Here is a list of registry key locations.
Crystal Reports 2008:
HKEY_LOCAL_MACHINESOFTWAREBusiness ObjectsSuite 12.0Crystal ReportsDatabaseOptionsLOV
Crystal Reports 2011:
HKEY_LOCAL_MACHINESOFTWARESAP BusinessObjectsSuite XI 4.0Crystal ReportsDatabaseOptionsLOV
Crystal Reports 2013:
HKEY_LOCAL_MACHINESOFTWARESAP BusinessObjectsSuite XI 4.0Crystal ReportsDatabaseOptionsLOV
Crystal Reports 2016:
HKEY_LOCAL_MACHINESOFTWARESAP BusinessObjectsSuite XI 4.0Crystal ReportsDatabaseOptionsLOV
For 64-bit version of Microsoft Windows, the registry path will be slightly different, it will start with: HKEY_LOCAL_MACHINESOFTWAREWow6432Node
1. Add the key: LOV, if it is not present.
2. Add the String value: MaxRowsetRecords
3. Set the value of: MaxRowsetRecords to the maximum number of records in the table where the values are stored. If Crystal Reports application needs to scan 100 000 records to retrieve 20 000 parameter values, set the value to 100 000.
(https://docs.genesys.com/Documentation/GSM/8.5.6/KB/KB00004)
-
Thank you, Nadim and Thiago. I was able to link to the part number using the wob_ref. Now to figure out how to prevent my Cartesian join. 🙂
-
Thank you for your help, Mike. We must not be doing the WO quoting in a way that I could get that information, Mike. Most items are null in our quotes for the pnm_ref. Do you think it would work to concatenate the BOM pn and the description and see if I could match the quote description? The quote description seems to be a combination of the two: DESCRIPTION = AN960PD10L WASHER.
-
Vicky Carlson
Member09/11/2020 at 9:13 AM in reply to: SHWOING ATLTERNATE P/N’S ON PARTS BARCODE LABELHi Rick,
We just had Patsy from Component Control help us with that issue. The attached file references both the the part number that is issued to the work order as well as the part number that is called out on the BOM.
It also has a field for notes on the part listed on the BOM. We use the notes field to include tech data references.
We added the BOM status code field because we use that field to designate customer-supplied parts, fabricated parts, etc.
-
Mike, we would like them to be able to look them up electronically rather than printing them. We are currently printing the pages for the technicians.
-
Thank you, Pietro. We may want to test version 12.2 to see what capababilities with hyperlinks it offers as well.
-
Thank you, John and Mike. I looked at Flydocs and it isn’t quite what we were looking for. Mike, if you make any progress on your proof of concept, could you let me know? We will also research and see if we come up with anything.
-
Thank you, Thiago. It has not been included in Shop Control in the past, but I reached out to CC and it is now included in version 12.1. Great news!!
Work Order/Work Packages: Electronic sign off functionality has been implemented for work orders:
· New “Mechanic Sign Off Required†setting has been added to the Adding/Editing Task screen. When checked, a mechanic sign off is required before an inspector sign off can be completed.
· New “Inspector Sign Off Required†setting has been added to the Adding/Editing Task screen with the options of “None,†“One,†or “Two†inspector sign offs.
· New “Default Sign Off Required†setting has been added to the Work Order Control settings. This selection serves as the default for the “Inspector Sign Off Required†setting on new tasks.
· New “Reset Sign Off†option has been added to the Task menu on work orders. Security has been added to grant/revoke access to this menu option (Maintain User Security Profiles: Quantum > Work Order > Tasks > Reset Sign Off).
· A prompt to reset sign-offs (Yes/No) is now displayed upon reopening a WO task (status change) if the user has security permissions to reset sign offs. If the user does not have permissions to reset sign offs, the user is now restricted from reopening the task if any sign offs were completed.
· New “Strict Flow Sign Off†setting has been added to the Work Order Control settings. When this setting is checked, sign off resets must be done in reverse order unless the user is a reset admin. Reset admins can reset all sign offs. Security has been added to grant/revoke reset admin rights (Maintain User Security Profiles: Quantum > Work Order > Tasks > Reset Sign Off). Users can remove their own sign off without the security permission, as long as it was the last sign off.
· New “Mech Sign Off,†“Mech Sign Date,†“Sign Off1 User,†“Sign Off1 Date,†“Sign Off2 User,†and “Sign Off2 User†columns have been added to the Tasks browse on work orders and the Job Cards browse on work packages.
Sign offs and resets are now recorded on the task audit trail (Task > Browse Task Audit Trail).
-
One issue that we have with the task sign off is that there seems to be only one sign off. We require our techs to sign off on the task, then have our inspectors audit the work and sign off that the task was done correctly. We wish that a double sign off option was included in the task.
-
Vicky Carlson
Member10/31/2019 at 4:58 AM in reply to: WORK ORDER BILLING STATUS — NEED 2 DEFAULTS FOR PARTIAL AND FULL BILLINGAnother issue with partial billing is that the work order billing takes the quote number. When you are partially billing from the quote, all billings will have the same number. There should only be unique numbers for work order billings.
There is an option in the billing to add items from the work order. It would be nice to have an option to add items from the quote as well.
-
We used it very briefly, but in my opinion, it was not a good module. It has no flexibility — 2 clock ins (beginning of the day, after lunch), 2 clock outs (after lunch, end of day). So if someone goes to an appointment in the middle of the day and returns, there is no option to clock back in. It required an inordinate amount of time for supervisors to manage the punches logged in Quantum. Too bad it wasn’t what we hoped for.