it
Forum Replies Created
-
I have confirmed with the Stock Market team that this flag does, in fact, list your reserved repair order stock lines.
However, this will only list items reserved AFTER you set that flag. So, in order to capture the items that were reserved prior to setting the flag, you must do a complete re-posting of your inventory. This is done in two steps, through SQL
The first statement to run will remove all your stock listings from the stock market.
truncate table mkt_queue
This second statement will initiate the upload of your stock back onto the stock market.
declare
c qc_utl_pkg.cursor_type;
begin
c := qc_mkt_pkg.SPI_MARKETPLACE_REFRESH;
close c;
end;
-
Thanks for that Nick – I have checked this option in our system as well.
Sometimes, you just need to slow down and look at the settings. Lesson learned.
-
It is possible to call the .dll files in QC and pass the parameters for specific functions. We do it with a bridge for our shipping software.
It requires in depth programming knowledge, and since you want to do in Excel, most likely this would be in visual basic.
I can provide an example of calling a .dll file to print a document but it wont be in visual basic, and it wont be related to the work orders.
-
Mark, our functionality is all internal. Updates have been good so far. If you want to do something like this, the trick is to get CC to sell you the screen scripter module.
-
Nick – item one and two on your list already have patches out, in case you didn’t know.
-
Mark, we used screen scripter to modify our PO headers, and the RO header and RO details to create our own approval system. We found the PR functionality woefully inadequate, especially since it does not (or didn’t at the time) incorporate repair orders.
Our system is fully automated, uses approval limits and allows for resubmission. Additionally, we modified the receiving inspection module to block the receipt of any order that is not approved.
The initial request for approval provide a comprehensive analysis of buy and sell history, usage, stocking levels, etc. For the repairs, it shows a history of vendor performance, part and serial number reliability and quote history. All this is to give the approving person as much information as possible to determine approval or not.
Basically, we put our quality monitoring at the front of the process to prevent issues instead of looking back on past performance after its too late.
Our system also automatically notifies the vendors of the approvals if they are prepay in any way so that they can generate an invoice for payment without delay. And, for drop shipments it notifies our Quality team so they can collect the paperwork from the vendor.
Later, I did the same type of approval system for warehouse to warehouse transfers within the shipping module, so that a stock transfer must have approval first.
I am now working on a system for RMAs that will use the same approval mechanisms.
-
Shauna, you could do what we do here for our freight. I am pretty sure you can get extracts of your request for quote activity from the listing services. Take that extract and create a crystal report that looks at the request data and compares it to the quote data.
Your report would connect to the excel spreadsheet, using it as the base line information. Then, create a sub report that links by part number and possibly fax number or phone number (some piece of data that is common for anyone in a particular company requesting the quote) so that you filter your sub report data on the excel data.
We use this technique quite a bit to compare external data against QC. Everything from freight bills to check runs.
-
Are you wanting to company the number of inbound RFQs against what was entered into the system? As in you received a total of 100 RFQs from ILS, but only entered 50.
If not, can you tell us exactly what it is you want to compare?
-
Tony – here is the code in your form that I think is causing the problem
This is on the Region1 OnPrint statement.
Var
qc: tqcdataset;
S, S1: STRING;
begin
qc := TQcDataset.Create(nil);
qc.SetDataServer;
qc.TableName:=’QUANTUM’;
qc.RequestRow[1];
REGION1.VISIBLE := QC.FIELDBYNAME[‘MULTI_LOGO’].ASSTRING=’T’;
qc.Free;
IF (REGION1.VISIBLE = TRUE) THEN
BEGIN
qc := TQcDataset.Create(nil);
qc.SetDataServer;
qc.TableName:=’REPORT_IMAGES’;
qc.RequestRow[Parameters[‘LETTERHEAD_RPI_AUTO_KEY’]];
if not qc.Eof then
imgLetterhead1.Picture.Assign(qc.FieldByName[‘IMAGE’]);
imgLetterhead1.Stretch := stretchImage;
qc.Free;
LBLCOMPANYNAME1.TEXT := SO_HEADER[‘SYS_COMPANY_NAME’];
memoCompanyAddress1.Lines.Clear;
memoCompanyAddress1.Lines.Text := GetSysCompanyAddress(SO_Header[‘SYSCM_AUTO_KEY’]);
end;
END;
It looks to me like the Region1.Visible statement is what is throwing it off.
Your code sets the Region1.visible to true or false based on the field “multi_logo†being “T†or “Fâ€
Then, your code says, if region1.visible is true do the statement.
My guess is the reason it is different in is because in your test database, the quantum table field multi_logo is set to ‘T’ where in your live it is set to ‘F’
-
Can you send me the form and Ill load it and take a look?
-
Is the issue that the object is pushed off the work pallet after you imported it?
Is the object visible in your design view?
Is there something else, another onPrint formula, that is turning that object off? This can easily happen when doing a copy and paste of objects in design.
Is the paper size and other general elements the same?
-
Krista, we looked at using a barcode system to do that but it was too costly and we didn’t want to be doing technical support for the end user on our equipment.
That said, we have many custom reports Ive don’t that we use, but I cannot share those. Sorry.
-
I have not seen this issue but some basic questions I would ask are
1. Is it a wifi connection or a VPN connection?
2. Are you running v 11 oracle client, and are you use that is whats being used as the connection?
3. Are clearing cache on the oracle server periodically?
4. Are you exceeding your licenses for the OS on Oracle, Oracle or Quantum?
I doubt these question will point you in the right direction, but at least it might help eliminate possibilities.
-
We depreciate cores at a set percentage, allowing for the excess to be applied to the suspence account awaiting core.
For exchanges in a lot, we want that activity to draw down the lot costs so we allow the system to use the lot margin instead of the exchange depreciation margin.
We override these settings occasionally if it is a high priced item with low cost.
-
Cory – I may be wrong but I think you will only get an error if you changing the location, and not just validating current.
That said, the only solution I can think of is to engage CC in programming a change in that routine. Otherwise, review the steps in your process to see if there something you can do to change work around it.
Wish I had a better suggestion.
-
My parts master screen was modified by myself using the Screen Scripter module.
As for dual use, this all controlled through the Wassenaar Agreement.
The categories are laid out similar to the Export Administration Regulations (EAR)
If an item is dual use, it is typically controlled under the department of commerce side.
Plus, with the changes implemented last October with the ITAR products, starting with category VIII.h (aviation parts) that has all moved over to the DOC side as well and new exemptions are in place. You should review John Bushnell’s lecture from last year cover those changes.
-
Andrej,
Also, at this year’s conference we will have John Bushnell from the US Department of Commerce giving a lecture on the basics of product classification, licensing and changes coming in the export rules, as well as a question answer session.
It is a great opportunity to ask questions and get answers directly from the people who write the rules.
-
Andrej,
This is a great question. There are several ways this can be done. I suggest you look at the conference presentation I did last year on Export Compliance. You view the video of the lecture. It covers how we manage our entire compliance program.
Also, if you have not already signed up, you should do so to attend the 2014 conference. This year, Rockwell Collins will be giving a lecture on how they use event manager to enforce their export compliance policies, and block shipments when appropriate.
-
Nice little tip, thanks for the contribution!
-
Ken, I suggest you contact Component Control and get a screen share set up with them where you can look at the more current version. This will let you verify the new columns are where you need them.
Unless you know Dephi, you wont be able to change those grids. And, you can only change those grids if they are helf the VIEWS area of your Oracle Schema.
You might want to reach out to Cameron Price at C&L – He has done some pretty amazing stuff without upgrades.
-
The ECCN does print on the customs invoice in Shipping I believe.
If I were you, I would invest in the forms designer module for a few thousand more. It will pay for itself by avoiding those one off document changes.
-
Yep, we had the same problem and got the patch for it. Actually just wrapped that up yesterday. You should talk with Nicola, he oversaw the activities. Maybe the patch will work for your version.
-
Lydia, I just posted a few items about a recent upgrade to 10.4.4.0 and there were several patches applied all relating to the GL, deferred receiving and work orders too.
I suggest you look at this latest version, with the recent patches. They did a LOT of changes to deferred receiving and how it impacts the PO.
I am suggesting this because you might solve your problems with the current version only to find out the next one changes things. So, you might as well just all the way into the fire.
-
We came from 10.4.2.0 I believe. Now that the dust has settled, this release has some nice features.
-
Ken in version 10.4.4.0 when adding a BOM item to a work order, the master part browse grid has a column called “Qty Avail (no AR)” which shows you the quantity new.
Just drag that column to the left so it is readily visible, then save to your personal settings.
You can also use the PN summary at the top of the inventory screen when you are actually in the part screen. If you click the plus symbol to expand it, there is actually quite a bit of information in that grid.
-
Bob we print ours from the Sales Order Acknowledgment document.
We did use the forms designer to change the title of the document to Pro-Forma.
-
We just received several patches after updating to v 10.4.4.0
Nearly all were related to GL issues stemming from purchase orders, repair orders, work orders, exchanges and lots.
I suggest you contact Nicola Hanna
-
thanks for the update
-
Yes, we have done this in the past.
If you use the department in your gl structure there are a few things to think about.
Accounting needs to understand that the segment tied to that department will change going forward.
The rest of the staff should understand that all referenced to a removed department code will be changed to the new, this means orders placed from years ago will show the new department.
To delete a department code, you have to remove all depedancies from it. You can find out what tables point to the department code with this query
select ucc.table_name, substr(ucc.column_name,1,20) column_name, uc.delete_rule,
ucc.constraint_name fk_name, uc.r_constraint_name pk_name,
substr(pk.column_name,1,20) pk_column, ic.index_name
from user_cons_columns ucc, user_constraints uc, user_cons_columns pk,
user_ind_columns ic
where uc.constraint_name = ucc.constraint_name
and uc.constraint_type = ‘R’
and pk.constraint_name = uc.r_constraint_name
and ic.table_name (+)= ucc.table_name
and ic.column_name (+)= ucc.column_name
and pk.column_name = ‘DPT_AUTO_KEY’
THen in each of the referenced tables, see what data might have that DPT_AUTO_KEY in it with a query like this, for example
select * from XYZtable where dpt_auto_key= your auto key here.
THen, to change it to a new code, use this
update XYZtable set dpt_auto_key=NEW AUTO KEY where dpt_auto_key= OLD AUTO KEY
Of course, do this on a test DB first, and use this AT YOUR OWN RISK
-
Kristen,
There is no default packing slip in the shipping order that I am aware of, but none the less, you can use this code in just about any shipping document.
All you have to do is place a label on your document, and in the OnGetText event place this code in there.
Then, replace the SM_HEADER[‘ROH_AUTO_KEY’] pointers for ALL orders to use the existing documents data pipeline.
This code displays the order for repairs, purchases and sales depending on which type of order you are shipping for.
var
q : TOracleDataset;
begin
Text :=’INTER CO. XFER’;
q := TOracleDataset.Create(nil);
q.SetSession;
if SM_HEADER[‘SOH_AUTO_KEY’]>0 then
begin
q.Sql.Text := ‘select SO_NUMBER from SO_HEADER ‘ +
‘where SOH_AUTO_KEY = ‘ + SM_HEADER[‘SOH_AUTO_KEY’];
q.Open;
Text := q.FieldByName[‘SO_NUMBER’].AsString;
end
else if SM_HEADER[‘ROH_AUTO_KEY’]>0 then
begin
q.Sql.Text := ‘select RO_NUMBER from RO_HEADER ‘ +
‘where ROH_AUTO_KEY = ‘ + SM_HEADER[‘ROH_AUTO_KEY’];
q.Open;
Text := q.FieldByName[‘RO_NUMBER’].AsString;
end
else if SM_HEADER[‘POH_AUTO_KEY’]>0 then
begin
q.Sql.Text := ‘select PO_NUMBER from PO_HEADER ‘ +
‘where POH_AUTO_KEY = ‘ + SM_HEADER[‘POH_AUTO_KEY’];
q.Open;
Text := q.FieldByName[‘PO_NUMBER’].AsString;
end;
q.Free;
end;
-
Kristin – I can help with the code if you let me know which document you are using. Are you using the packing slip from shipping order or from invoices?
-
Sorry – Kristen not Kristin.
-
David,
I suggest you speak with Component Control. You are on an older version of QC so there could be something there that has been fixed already
-
Dave this really depends on the level of accounting detail you require. If you are like use, each line item might get coded to a different account.
Some companies enter one line for each group of items, others enter for each and others enter for the whole card.
Our company is run like a public company, and our auditors and banks require a great deal of detail. Therefore, we have to enter in quite a bit from the credit card statements.
With that said, we go through expense reports. Those expense reports are put together by the card holders and approved by management. I have created expense report spreadsheets that total up by category. And, it could easily be modified to total up by GL account. So that when the credit card expense report is turned into accounting, all of the math is done for you. Then, all you have to do is data entry.
Now, taking that a step further, you can theoretically have that spreadsheet also output a format that is suitable for import. Then, using the data import tool, an import script could be written to import that data directly into an ap transaction.
I would be willing to share that expense report tool if you are interested.
-
Oo, I didn’t know about that. Sounds like something Im going to have play with 🙂
New toy!
-
Wesley, we use the wireless barcode systems at our MRO. I think, however, it is unrealistic to entirely paperless in a shop environment. It has been my experience that the more can keep the mechanics from the computer, the more productive and revenue generating they will be.
Our approach is a combination of paper and technology using methods from both shop floor and heavy maintenance environments. We try to keep the process and quick and simple as possible and find that much of the work order capabilities are more than when we need.
Our jobs are created with two templates usually. The first is a high level template that outlines the disassembly, evaluation and assembly of the units. There are a few more high level tasks in there. These high level tasks are used primarily for the tracking of labor against these main functions. Then, a standardized template outlining common faults is applied. This template has associated discrepancy, corrective action and bill of material items. Once this is applied, a customized traveler is printed. The customized traveler suppresses the first template details and only shows the task along with a start and complete barcode. The remaining template tasks are shown with their respective discrepancy, corrective actions and BOMs. Along with that, each of these tasks prints check boxes that say found or not found, mechanics sign off and bar code start and complete scans. This customized traveler is printed at the beginning of the job, and printed ONLY ONCE. Never do we re-print the traveler.
Now, as the mechanic performs the initial evaluation, they scan labor against the primary task (the first template) they are working against. While they are evaluating, they mark off each of the common discrepancy as found or not found. Once the evaluation is complete, this goes to production control. (I’ll get to things found outside of the common discrepancy in a minute).
When production gets the traveler returned, they delete all tasks from the work order that were NOT found.
For items that were found which are outside of the common items, we have a 3 part non routine form. This form is numbered. The mechanic will grab one of these forms and fill out the form to include the work order, the discrepancy, the corrective action, and the BOM requited. This gets turned into Production control as well. Production control then enters this into the work order under a task called “Non Routine”. He inputs the non routine number pre-printed on that 3 part form into a UDF field on the task input screen. Then, he will print a different customized traveler that has been modified to be a barcode label. This label only has the work order and start and complete barcodes on it for purposes of scanning. The barcode label also contains the work order number, tasks sequence number and the non routine number. He then applies this to the back side of all three copies of the non routine.
When the job is approved, the original traveler and a copy of the non routines go back to the shop floor for work. When the mechanic starts to work on a task, they scan into the task. When they need a part for a task, including non routines, they take their badge and non routine card, or traveler, to the store room an the clerk scans their badge, the task barcode and the part to add, reserve and issue it to the job. Same thing for tools as it works the same way except there is no issue for a tool, only reservations.
So, as you can see, our process eliminates the need to constantly revise the traveler risking the wrong version being used, and/or the important hand written notes being missed. It expedites the work flow because we can take a non routine found, have it entered and back on the floor in a matter of minutes. The three part approach allows us to take copies and send it to procurement or other departments without the loss of work because another copy is on the floor. Lastly, it keeps the dirty finger print trace tied to the work order in QC through the use of cross referencing the pre printed non routine numbers on the cards tied to the work order number and the task sequence number on the job.
Anyway, hopefully this gives you some food for thought.
-
The ATA chapter is not something is printed automatically on the 8130 because there is no specific field for the ATA chapter that I am aware of.
The serial number will print on the 8130 if it is the engine (for example) that you are printing the 8130 for. Otherwise, it will print for whatever the part you are certifying.
THe customer name also does not normally print on the 8130 as this is a part related document. There are trace field that are printed from the stock line though.
Afraid to tell you but, you will need to customize your document. That said, will your customizations cause the document to fall outside of the FAA guidelines for the format and content of the document?
-
Henrik – doing the same thing to log out, then click the log in button from the main home page you will see a “Forgot Password” link.
I believe that will allow you to reset it. If it does not please let us know.
-
Tony, log out of your session. Go to the main QG website and log in by clicking the log in button.
This will take you to your profile page. At the top of that page you can click Edit Profile.
-
I have not seen anything. I know advance qc (consultant) has updated versions of it. But you need forms designed to install it.
-
Spencer, we just signed up two weeks ago and have not had enough time to evaluate the results.
Our logo looks nice though 🙂
-
For shared custom programming, the interested parties should identify a primary representative for the group. That person then contacts CC and begins coordination of the estimate and subsequent programming. CC should be told up front that billing will be shared amongst multiple companies and who those participants are.
-
Wesley, is the problem persistent when printing from any computer on your network?
Is it persistent when logged in as a different user on the same computer having the problem?
Sometimes printing issues can be relatives to the print drivers. If it does not happen on another computer, compare the printers installed on computer vs. the other.
Also, check adobe read versions and java versions.
-
I have asked for a similar thing. I have requested that the stock market use the ILS condition code found in the edit screen of the condition codes.
This would make the listings consistent with other services out there too.
-
Ken – the return parts to vendor screen will show only the actual stock line that was received. It must link to the PO. In the actual stock table for that stock line, the PO number and POD_AUTO_KEY must be present.
I think your BOM item should not have been turned in as this creates a new stock line. You should have used the Undo Stock Issue function to reverse the issuance of the original stock line. This would have retained the link back to the PO.
My guess is that your turned in stock line does not show the correct cost on it either. So, I suggest you undo the issue of the original stock line, process your return to vendor, then manually adjust you extra stock line down to zero – as long as there is no cost on it.
-
Ken, I submitted your posting to CC on 2/13 and Steve Powell replied to me that same day saying he would give you a call to clarify. If he has not contacted you, please shoot him an email at spowell@componentcontrol.com – he is usually pretty responsive.
-
Can you please outline the reasons why you are not able to quote the sub work order?
If you launch the work order from your BOM, for that BOM it will create a stand alone work order linked to the higher one. A side note to this we recently discovered is that the WIP will show for all work orders and not just the sub. Anyway you should be able to treat this WO independently for the most part.
I admit we do not use the WO quotes as it is way more than we need. Still, if you explain a bit more, perhaps we can help.
-
Adam – according to CC, this issue has been fixed for you. Please contact them for an upgrade.
-
Sounds like you need a custom form created to summarize instead of show detail
-
Adam I have sent this over to Component Control to investigate.