stomlinson
Forum Replies Created
-
What version are you on and are your work plans deferred?
-
Quantum 10.8.9 – bug alert. If using deferred BOM, when doing Global/Template/Deferred get an error that says qty must be greater…..and locks up Quantum so you have to close out using task manager. Seth is looking at it for us at Quantum. Anyone else have this issue?
So, we won’t be anywhere close to even be able to test it until this issue is resolved.
-
Thanks for the information Jason! Hope they get your Crystal fixed, so you can go live.
-
We have requested 10.8.8 for our test environment. We are waiting on CC to add an enhancement to the Work Order Header that will give Contact, Notes, Documents, etc. symbols. Will start limited testing once that is done prior to New year.
-
I was looking at something else and spied this in the release notes for 10.8.1 on Quantum’s site. Worth a call anyway.
[T6310] New Audit Trail System Browse has been added to User > System Setup > Maintain System Tables > System Browses. This browse window displays all of the audit trail entries in one location. The Find option enables searching by the following parameters:
Source Table – table where the change took place (ex: POH or WQD)
Source AK From – numerical primary key of a table; used in conjunction with Source Table
Source AK To
Source Field – field name (ex: BILLING_RATE or UNIT_PRICE)
Value – searches Original Value and New Value
Description – change description (ex: “insert†or “updateâ€)
User Name – user name that made the change
Date From
Date To
The Description has been improved for insertions and deletions of header and detail items for the following modules: Sales Orders, Purchase Orders, Repair Orders, Invoices, Customer Quotes, Vendor Quotes, and Shipping Management. (10.8.1)
-
Thanks. With this as a starting point and a little help (ok a lot) from Quantum we made a label and on get text
var
q : TOracleDataset;
begin
q := TOracleDataset.Create(nil);
q.SetSession;
q.Sql.text :=’SELECT MFG.mfg_code, MTP.type_code, MNL.revision, MNL.revision_date, MLS.status_code ‘ +
‘FROM manuals MNL, manufacturer MFG, wo_manual wml, manual_status MLS, manual_type MTP ‘ +
‘WHERE MNL.mls_auto_key = MLS.mls_auto_key (+) ‘ +
‘AND MNL.mfg_auto_key = MFG.mfg_auto_key (+) ‘ +
‘AND MNL.mtp_auto_key = MTP.mtp_auto_key (+) ‘ +
‘and mnl.mnl_auto_key = wml.mnl_auto_key ‘ +
‘and wml.woo_auto_key = ‘ + WO_OPERATION[‘WOO_AUTO_KEY’];
q.Open;
Text := q.FieldByName[‘mfg_code’].AsString;
q.Free;
end;
-
I am on 10.7.97. If you want to wait until 10.8.1 comes out they will also be adding buttons in the work order header for document images, etc.
-
The tracker associated with this feature has been resolved. We just upgraded to version 10.7.97.0 and I now can get the forecast repairs for the deferred bill of materials in purchase management with the Qty OH and Qty Avail, on order etc… all populated.
-
I concur – granted it doesn’t even give me the option to choose or reserve a stock line on hold from an SO or WO, but if you are using the information to phone quote an estimated lead time based on Qty on Hand it is not very useful AND worse could cause you to have an unhappy customer when you can’t deliver on your lead time promise.
-
Abigail –
I do have SQL Developer, but I can’t figure out how to get around the error java virtual machine not found. It’s in a cloud environment. I’ve tried everything on “google” search to do, but no luck. Any suggestions?
Thanks
-
After you create the stored procedure, you then reference it in the templates as the other user stated. He’s quite correct in the get your hands dirty.
-
I know enough to be dangerous, but not an expert by any means. Hopefully, someone with more knowledge can comment if this isn’t quite right.
You will need to run as an administrator with a command prompt
ex. m:Userscarolsqlplus qctl/quantum@maxprod
will say connected to:
Oracle database 11g…………………
SQL>example is at this prompt is
create procedure GENERIC_WO_CONTACT as
2 begin
3
4 f
Hope this helps.
-
We scheduled a two hour training session with Quantum and he wrote a couple of custom scripts for us and then gave us a website http://www.sqlcourse.com to get familiar with sql commands.
You can then look at how Quantum does it and have a framework to write your own.
-
Thank you. Hope to see you at the conference next month!
-
Thanks Anthony. Let me know what the consensus is.
-
I’m in same boat. Are your answers with an onsite server or cloud environment?
-
Leah,
I am currently working with Jamie on several enhancements, I will keep everyone posted on the EDI for Aerorepair as I find out information. The airlines are forming a consortium to make a big push on Aeroexchange side for improvements and ability to interface with users software. Once, the improvements are done on their side, we won’t be as competitive without an EDI on CC side to Aerorepair.
-
Thank you for the input. Paul are you using the EDI for Aerobuy or Aerorepair? It is my understanding there is not an EDI bridge for Aerorepair at this time on component control’s side. We use advanced shop control features in quantum.
-
We have a newer version, but do not use that feature yet. It is an advanced feature and I will probably want to get over the phone training on it if the need arises.
-
Thank you Paul.
-
If you also have shop control you can use the shop planning feature. You are able to set up what if scenarios and put the quantity you estimate and it will take the BOM qty times the number you need.
There is also a planning (what if) scenario in the MO module.
I used the help feature and played around with it in our training company to get kinks worked out and ran it by Ryan R to be sure my process was correct.
Within Shop control planning I have reported a bug and Ryan verified it and reported it. If you do the what if currently it doubles the qty needed (once in WO and once for MO) the population to the purchase management. My work around is I divide my what if qty by 2…..
Hope this helps.
-
We currently do it like you as well. We are getting ready to implement Event Manager and I am hopeful that we can create a script to do that. I will let you know when/if we figure something out.
-
We are just getting started with this. I am setting these up in regards to internal process checkpoints. ex. Receiving, sales, delays – parts and labor seperate. In the hopes that after time, I can easily see any bottlenecks/errors and look for solutions to improving processes or training.
-
We have been assigned a tracking number and we will see how it goes.
-
Henrik –
In the Form Design –
Remove all the 8130 forms and put them in the recycle bin. Then they won’t be able to print the form out, but it will still exist.
-
The quickest way would be to export to a file and open in Adobe Pro and manually change quantity.
-
We just have one template per part number. If you have more than one contract you may want to ask what other modules or fields may link to that field. It may be more efficient than setting up 7 templates per part. I will be out there late this month for que group. I plan on addressing links that are not available as of yet to cut down on data entry and clicks. Feel free to contact me stomlinson@taerospace.com.
-
Ours automatically populates in response to how the template is set up. It uses the number of days to complete in the template to calculate the field.
-
I am interested in this as well. I have discussed with component control and they are working on a potential enhancement if there is enough interest.
The reason why this can’t be done is because there is NO link between the work order and the quote. If you will notice, all those quote items really are just text. You can change it to whatever you want.
It’s the same reason that the vendor quotes sent for all the work orders do not update the quote when you enter the price/lead data. There is no direct link. If you would like to discuss further, I can be reached at 901-647-9846 mobile or 901-367-8944 work.
I currently have a report Quantum is supposed to complete that does just what you want in crystal reports. It still does not work and I am pretty sure it’s because without a link it may not be able to be done.
I will be at Que Group Conference.