billy
Forum Replies Created
-
I’m not sure about wp’s but wo’s can be done by creating and applying a blank template to the wo. Then go to Global, Template, Work Plan, Modify Template.
Be very careful who has access to this because the Modify Template option overwrites everything on the template that’s applied.
-
Matthew,
We’re dealing with this too. Caught it 2 months ago and was supposed to have been patched but our problem persists. Have they been able to fix you?
Billy -
We’ve always worked around it with GL entries and I’ve asked CC but never got a straight answer.
Just curious because I’ve never understood…does anyone know the rationale behind ‘NOT’ being able to void a non-stock item?
-
Awesome. Thanks Jae.
-
After re-reading my post, I don’t think I described the problem clearly.
The adobe print button doesn’t work at all. The Quantum print button works but “print selected” pages is unavailable. The only way to select print pages is to use the browser button and print from there.
Pietro, yes I’ve adjusted the security controls in Adobe and the problem persists. Foxit is an option that we’ve used before but we switched back to Adobe a couple years ago. I’d rather not have to go back if I don’t have to.
Scott, I’m pretty sure that setting would open every image with external app rather than Quantum’s viewer?
-
We made a pretty big jump from 10.7.99 to 12.1.5 Monday and have been dealing with issues all week.
Problems we’ve had…
Event Manger is still not working. I’m told it’s fixed with a new revision so we’ll be moving to 12.1.7 sometime next week.
Search Shop Control by SN is extremely slow using “Search WO Headers” Workaround is to use “Search WO (Advanced)”. You never know how many people use a feature until it goes down. Ticket CCTS-435
All reports that used Crystal (option to disable crystal reports where available is gone) were down for 2 days. Patched and resolved.
Can’t use “Add” to add a line to cash receipt. Workaround is to use Add/Apply. Ticket CC-2083
Can’t use “Quick Entry” to add to a credit to GL Batch. Ticket CCTS-434
There were a few other minor issues that were resolved as they came up but kudos to Ben and Leon who have been very helpful in getting the major problems fixed or sent to developers.
-
I can verify that this is fixed in v12.1
-
I’m interested too. Is anyone using it and happy with the product?
-
Awesome. Thanks again, Mike.
-
Thanks Mike. You’re right. These are BOM parts so the WOB_AUTO_KEY is what I need to use to pull the work order number number. With my limited coding skills I was able to get it to work. Here’s what I worked for me in case anyone else needs it…
var q: TOracleDataset;
begin
if (RO_DETAIL[‘WOB_AUTO_KEY’]<>0) then
begin
q := TOracleDataset.Create(nil);
q.SetSession;
q.SQL.Text:=’select WOO.SI_NUMBER, ‘+
‘WOB.WOB_AUTO_KEY from WO_OPERATION WOO, WO_BOM WOB ‘+
‘WHERE WOO.WOO_AUTO_KEY = WOB.WOO_AUTO_KEY AND WOB.WOB_AUTO_KEY =’+ RO_DETAIL[‘WOB_AUTO_KEY’];
q.Open;
Text := q.FieldByName[‘SI_NUMBER’].AsString;
q.Free;
end
else
Text := ”;
end;
-
Same issue here. It doesn’t say much for their record keeping if they say they have no record of it. I know I’ve reported it as well.
-
We asked for this enhancement many years ago and nothing ever came of it.
-
There are a couple ways to import list prices. You can use the ocdia.exe tool or from within Quantum, you can use the import feature built into the inventory module. The field you’ll be importing to is LIST_PRICE in the PARTS_MASTER table.
-
I have one user who does a ton of customization to her toolbars and as it would happen, this happens to her frequently. CC has been no help on this so I use a free utility called RegistryChangesView to create a before and after snapshot of her registry to generate a .reg file I can apply to her pc whenever she loses her settings. Just make sure you wade through the changes before creating the .reg to remove any non-Quantum registry entries.
-
Good luck troubleshooting these problems. Here are a few things I’ve found that might help.
1. I’ve never actually seen it fix the problem I was having but the first thing CC checks for such issues is that DEP is turned on for qcsysmod.exe and quantum.exe.
3. Uninstall and reinstall Quantum. Make sure you delete the program folders after uninstalling to get a fresh install.
2. Recently I had one user whose Quantum crashed regularly (multiple times a day). This person worked in accounting and was in AP and checks more than any other module. After a lot of back and forth, we discovered that turning off Integrated Crystal Reports (UserSystem SetupGlobal Settings) stopped her Quantum from locking up. It may not be a viable option for some but for us, we only have a couple integrated CR reports that we use so I can turn it back on as necessary.
3. We’re still dealing with this one. Quantum locks up frequently when emailing quotes. It’s hard to duplicate so CC hasn’t been any help other than checking that DEP is turned on and uninstalling/reinstalling but FWIW I’ve found that it happens less on users who have POP email accounts than my exchange users.
-
We don’t import application codes but I do import parts. Is it possible that you have spaces in your update file? I’ve run into an issue with them in other applications.
-
Our purchasing department reserves the available stock to the BOM, then print a pick ticket from the work order to a shared printer the stock room. The stock room pulls the parts, issues them to the work order and puts them in a bin awaiting PO’s.
-
Alonda,
We’re on 10.3.11 and are not affected.
Billy
-
Alonda,
One thing to look out for…we tried using credit validation but ran into a problem we couldn’t work around. The option “Validate customer credit before creating Sales Order” that is set on the Customer Quote Module actually applied to QUOTES in the Shop Control Module. When turned on, we were not able to create a quote to a customer IF that quote would put them over their established credit limit.
I raised this issue with CC. They said it was intended to work that way because “if a customers credit limit is or will cause to be exceeded it will not allow you to print a WO Quote because there would be nothing to stop or prevent you from creating a bill of materials and labor”. One problem with that logic is that creating a quote and creating a bill of materials and labor are completely independent. I can add all the labor and parts I want before ever creating the quote.
In the end, we stopped using it and put the responsibility to manually verify available credit on the sales department. I’d be interested in knowing how this works out for you.
-
We use Exchange offsite as well but I didn’t really consider the possibility of it being an issue with the mail server since new mail creation happens locally. They’ve been instructed to let me know immediately the next time there’s a delay. I’ll try changing the settings that worked for you next time I hear from them. Thanks.
-
Nick,
I read your post last week and hadn’t heard of it at the time. We’re on 10.3.11 and have been since May of this year. Oddly enough, today I had someone call and report it taking a long time for the Outlook window to come up while trying to email a quote using the steps you mentioned. He says this happens from time to time but didn’t think there was anything that could be done so he never said anything to me about it.
So I tried it on my PC and, sure enough, the same quote was taking a long time on mine too. Tried a couple different quotes and it seemed to take a proportionate amount of time according to the number of items on the quote…but even a quote with a few lines took 30 seconds or more.
I got side tracked for about 30 minutes and when I came back to reproduce the problem, I couldn’t. Called the other user and had him print (email) the same quote and his was working normally as well. Since I wasn’t able to look around while it was happening, I don’t have any ideas yet what could be causing it but it seems to be a transient condition and happens on all quotes for all users when it persists. Which leads me to believe it’s server side. Possibly a process running on the server? If I can narrow it down next time it happens, I’ll post an update.
-
Irena,
You can add field restrictions in User Security Profiles. If the field you want to block is not available, you can add it by going to User->System Setup->Security->Security Settings. Presumably that’s exactly what this was designed to do. However, be aware as I stated in a previous post (See System Administration), that I did exactly what you’re trying to do. I set the Company Name field to read-only but, in doing so, it restricted access to other completely unrelated fields in other modules.
One suggestion was to use screen scripter (which we don’t have), but that seems to be overkill when you only want to block one field and there are supposed to be system defined controls in place to do that.
-
Thanks Nick. I’ve been told by CC multiple times that screen scripter is no longer available.
-
Thanks Henrik!!! +1
-
That’s a great idea, Bill. Hope it gets legs. We’d be very interested in being able to electronically sign 8130’s as well.
-
We’re also on a previous version and were about to start the process of upgrading. Glad to see your comments because that’s a HUGE deal with us too. Owner will be furious to hear about this because there’s a bug fix we need but total price is a field he uses all day long. May have to push for a patch to our current version until this is resolved.
Oh, and we’ve been customers since 2003 and have never been asked for input on future releases.
-
That would be a great enhancement request.
-
Roque did our FB to MaxQ conversion in May and did a fine job. He was the only one we communicated with regarding conversion matters.
However, during our testing (nearly a year) of MaxQ, any issues with the Oracle Test Installation were sent through the tech support system just like you would with a live system, so any accounting issues were handled by their accounting support…Bruce Taylor mainly. And he does great work too.
-
Tinkered around with it this evening waiting on a large robocopy job to finish and found the answer to my own question.
The IMAGE_LIST.SOURCE_PK is the primary key for the SOURCE_TABLE. This gave me a list of all companies and their scanned documents.
SELECT “IMAGE_LIST”.”IMAGE_DESC”, “IMAGE_LIST”.”DATE_CREATED”, “COMPANIES”.”COMPANY_NAME”
FROM “QCTL”.”COMPANIES” “COMPANIES” INNER JOIN “QCTL”.”IMAGE_LIST” “IMAGE_LIST” ON “COMPANIES”.”CMP_AUTO_KEY”=”IMAGE_LIST”.”SOURCE_PK”
ORDER BY “COMPANIES”.”COMPANY_NAME”
-
Thanks Paul. I guess I was tired of scanning scripts by time I got the U’s that I overlooked it.
Got a chance to play with it today and found that the script runs and creates a master pn out of the alternate pn field but but doesn’t make entry into the alternate_parts_master table.
Any ideas?
-
Yes, I’m using Ocdia and I see a lot of part import scripts but none that include alternates which tells me one or two things. 1: No one else has an interest in creating alternate PN’s with master part imports or 2: It’s a difficult script to accomplish.
The PN/AltPN relationship has always given me fits writing crystal reports so trying to make it work in an Ocdia script (which is even less familiar to me) would not be possible.
-
Very nice. Thanks Paul.
-
We also use the imaging module extensively. It’s a great feature for managing electronic records but make sure the scanner you buy has a TWAIN/ISIS driver available.
Remember, however, that all scanners are not created equal. We recently purchased a Fujitsu Snapscan S1300i only to find out that we can’t scan directly into Quantum because it’s not TWAIN/ISIS compatible.
-
I had no idea about the SO Exchange Dashboard. This is why I subscribe to and read all of the forums. Thanks Nick!
-
Ha! Good one, Henrik.
-
Ditto what Spencer said. I had to update each table on every report.
-
Felix, You have to manually add the fields to be blocked.
Go to User, System Setup, Security, Security Settings. Under “All Fields”, Find the ones you want to restrict and add them to the “Block Fields” window.
Now go to User, System Setup, Security, Maintain User Security Profiles. Select the user you want to restrict, find the field name under “Field Restrictions” at the bottom, Click Field Option, Click Hide.
Now when they open any screen that has that field, it’ll be grayed out.
Hope this helps.
Billy
-
I setup and ODBC connection. To do this, you’ll need to download and install the Firebird ODBC driver then configure a user DSN for Crystal to use.
I don’t see how to attach images here but if you need more, shoot me your email. I could send the drivers and some screenshots with more detailed instructions.
-
Wow. Thanks Henrik. It’s interesting that tech support didnt know anything about this. Would be nice if the left hand knew what the right was doing.
I understand why they’d prevent editing a closed work order header but there’s so much information in there that I couldn’t believe they’d just lock it down like that without providing a way even see it without a report (like Paul mentioned) or having to change status.
-
Reports -> Shop Floor Control -> Labor Report
Select your parameters. Date Range, Work Type, Document, and Employee if you only want to report on an individual (leave blank for all employees). Click print.
The report shows labor added to every task on every WO that the technician worked on for the date range you provided.
-
It’s under…User -> System Setup -> Maintain System Tables -> Record Defaults
We actually lock that down so only accounting can change terms.
-
As long as you’re adding labor to the wo’s, you should be able to see most of what you want on the std labor report.
-
Good to hear, Henrik. I have 10.2.13 installed in a test environment and am experiencing the same thing.
-
Really nice, Eric. Thanks
-
Forgive me if I’m not reading this correctly but to find out who added a PN, wouldn’t you just go to Global->Historical Browses->Browse Part Changes in Inventory Module?
If you want to run reports from crystal, the table that holds the data is AUDIT_TRAIL
-
Very interesting question, Anthony. We’re in the process of converting and I was wondering if we’d renew.
I’d be interested to hear whether others keep their Oracle support current and if anyone else really uses it.
-
Thank you, Anthony and Paul, for the feedback.
-
Henrik Ekenberg wrote:
Hello Billy and Paul,
Thank you both for your answers.
I was hoping there was a method that ‘normal’ users could use since I’m not happy about giving users access to execute SQL commands.
On the other hand this is the first time it has happened since we went live last February so I guess that I could do it when these particular situations occur.
Billy – the method you mention will that take the cost from the work order and put on the stock line?
Paul – yes I don’t remember the exact words but it said that I could not convert to an internal WO when the stock line is customer owned.
I will try out the method you mention in our test system and see if it turns out ok.
Thanks again.
Best regards,
Henrik
Henrik,
Yes, the accumulated cost of the wo will go to the stock line when it’s released and as long as you don’t mark the main component “as shipped”, it will leave the stock line in your inventory. The next step is to use the sql script that Paul mentioned to change the customer_owned flag to ‘F’.
Paul,
Does the change wo type function work for you? It does work for us as long as we’re going from internal to external. But we get the same error (Cannot change work order type for customer owned stock line) that Henrik mentions when trying to change from external to internal.
It occurred to me, as I was typing this, to try changing customer_owned flag to F while still reserved to the external wo and then try to change internal/external type. That worked for me and may be a viable option but I’ll have to check gl transactions to see that everthing flows properly.
Also, I noticed in your sql script that you set closed_update=T in addition to the customer owned flag. What’s the purpose of that and do you have to set it back to F after running the script?
-
I’ve talked to CC about this on multiple occasions and got the idea that this was not something they support so I don’t believe there are any built in controls to handle this properly.
Of course, there are ways to do it. What we do is bill it out at $0, release wo (don’t mark main component as shipped), turn customer_owned flag off on stock line, and open internal wo.
This is the best way we’ve found to keep trace and wip/inventory accounts balanced.
Hope this helps.
-
Thanks for bringing this up, Michael. I tested and was able to duplicate the issue on our firebird db with a limited account in Quantum.
We actually have plans to upgrade to MaxQ sometime next year. I wonder if this is a problem in Oracle as well.