it
Forum Replies Created
-
You can take a look at the vendor quote wizard.
Other than this tool, QC has no mechanism in place to accomodate this process. We have the same issue at Worthington.
-
Nic/James – please contact Kevin Otto to obtain the security tool.
Kevin Otto
888-416-6464
Fax: 909-475-6375
-
Candi,
Changing this is not too hard. Especially if the form has already been created.
you can re-position elements on the form by opening the form in the forms designer module, then clicking the element you want to move and use the arrow keys to move it. For more precise positioning, you can right click on the element and choose the positoin menu option and manually type in the X and Y coordinates on the form.
I think you need to work more closely with your bank to understand why they are saying the checks are rejected, and where the exactly things should be positioned.
-
Chris,
There are other reasons this is the way it is. From a programatic standpoint, all lot items (both in stock and historical stock lines) point back to the auto key of the main lot stock line. From there, they point out to the Lot Header through the stock reservations.This is done so that when you are looking at the lot item you can see which lot it is associated with. This is they link back to the lot.
So, if that stock line were to go away and the reservations be broken, all of your lot items would no longer reference the lot header.
The underlying design of the lot requires that main stock line to be tied to lot header for ever.
It is not the best design, I admit, but it is at best an annoyance and (in my opinion) not worth what they would charge to have it overhauled.
We simply do not use QC reports and create our own. Our report exclude stock lines that are main components which are linked to Lot Headers which have be Closed.
Much cheaper solution.
-
Just returned from vacaction. In thinking about this, I believe it would be much easier to embedd the signatures into the document, then hide or show the appropiate images based on who is printing the document.
I dont know how to pull that data down. Sorry.
-
Joost – i am unaware of any way to do this. I recommend you speak with Component Control about this – may have to be custom programming.
-
Well – after I wrote that post, we started having problems. I recant my posting 🙁
It will work if you do not have imaging. However, if you are remotely scanning then you will have problems because all connections share the same temp directory. We tried several options but ended up having the revert back to the old contruct.
-
It isnt too bad. I extract all of the code and keep it outside of the system.
I like to use NotePad ++ to edit and debug any code. Free download and a great tool to have.
-
You might consider bringing in a consultant to help you. The cost of the consultant would be offset by the time saved in the project, and man hours recouped.
I recommend using Kevin Otto from Advance QC
-
Billy – yes, we are running QC on much older machines, most of which are 32 bit.
-
James – the markup applies to the stock sell price. In the recieiving inspection module you can define your markup, then upon receipt it will do the calculation automatically for you and apply it to the SELL PRICE on the stock line.
Sorry if I missunderstood you.
-
Andy,
Yep – that is the case. There is no other option that I am aware of.
-
Matt – I believe this is a system setting function where you can automatically print the SO pick ticket upon PO/RO receipt if the order is linked to the SO
-
Andy – this is the only way to do it.
You can restrict visibility by Department code as well, but you will have to make sure to assigned departments to your stock lines upon receipt. Then, this will also restrict visibility to all transactions.
so, you are doing it the best way available for now.
-
You can use SQL to do mass updates, but the trick is inserting into the memo field.
The structure for the warning messages is a bit clumbsy so you will need to look at the table structure again. I suggest you use the SQL statements I posted in the admin forum that shows you the field name relationships. Secret SQL 1 and Secret SQL 2
-
We’ve used this feature before, but it doesnt fit our business model very well. The markup can be applied upon receiving automatically.
We not use price lines quite extensively to display customer and vendor pricing. We found this approach better.
-
James, you want to use the Discount Matrix in conjuction with Discount levels.
This allows you to create different discount structures off of list price and then assign the levels to multiple companies. When you want to change the discounts, all you have to do is modify the discount level.
This is outlined in the help files.
-
Bill – you may be able to create a different sort order in the document if you have the forms designer by introducing groups.
Otherwise, you can do what we do – create your own statement in Crystal Reports.
-
Nic, I havent seen this. Here are the things I would look at.
1. Check the distributions setup in accouting. Make sure any and all default distributions are all set up correctly.
2. Verify this issue with Component Control and see if it is present in the newest releases.
3. If you use lots, try testing this out and find out if it is doing it for all transactions, or only specific ones. Are they related to lots? are you using the vendor quote wizard? are they linked to SO exchange cores? And so..
-
Tony – the only way I could see doing this is to modify the check document to pull in the appropriate details. The method used for short paying will have to be consistant and be able to link back to your check batch somehow. Without looking at this in detail, I cannot say if this is readily available. If it is not, the screen designer module could be used to create an option for the use to input some sort of reference to the check batch somehow.
-
Nic, the event manager is great for running scheduled events. Those events can be made to modify data, send notices or generate reports.
However, if you are only looking to produce reports, you can have a very cost effective solution just using Crystal Reports and a tool called Visual Cut to automate them.
-
Damien,
There is no disposition tab. That field is calculated I believe. To replicate this tab all you have to do is link from RO detail to Stock, from stock (stm_lot) to second instance of stock (stm_lot links to stm_auto_key) , then to stock reservations then to WO_Operation. Filter on SI_Number.
The disposition you are speaking of is as such
On Repar = qty_repaired < qty_repair Repaired = qty_repaired = qty_repair
-
I have not heard of anyone deploying QC with this Oracle version. I would be leary of limitations on backups, customizations, external access, etc.
The best source of info on this would be Component Control themselves I would imagine.
-
Andy is correct – PO Global Menu, Void Receiving and then receiving it again with the corrections.
-
I do not see it in v9.5 for us.
-
If I understand you correctly, I believe you need to utalize the bill of materials by adding the part numbers you are removed, then turn them into stock, utlamately shipping them back to the customer or turning into your own stock.
A sub work order is for internal work where you want to have a seperate traveler and tasks list on a component of the higher work order. It would be used for example another department in your company.
The repair order is for external work.
-
right on the money.
-
Andrew – maybe I am missing something, but in v 9.5 Oracle there is no image for signatures in the sys users table.
there is an Email Signature but not images. Can ellaborate more on this?
-
Dave, Are you in Oracle or Firebird? Views are different between the two.
-
Spencer you should contact CC and look into the new Web Portal. Looks like it might solve your issue here.
-
The lot stock lines – here at Worthington – all have the ILS Flag code set to “N” which is excluded from our inventory listing extracts. We also remove the Stock Market flag so they do not get picked up by the stock market. Lastly, we put a location code against the main lot stock lines called “LOT HEADER” which clearly shows the stock line is only a main lot header stock line.
-
Adam
The scanned images are still retained against the historical stock lines. The new stock line that is created upon receipt should have all new paperwork scanned. Your point is understandable, and it is traced in the system.
In fact, the Series Number and ID are made specifically for this purpose. These two identifiers on the stock line allow you to lookup the historical activity of a stock line regardless of how many times it has turned in your system.
-
GREAT contribution! Thanks for the input. I know I will be looking at the last tool mentioned.
-
This is a re-post of two other posts I did in the Administrators forum. These two SQL statements allow you to see table relationships, as well as field relationships.
Here is another way to look at table data. This one works great as well. Just replace the column name value with any field name you want to research in all QC tables.
Saves a ton of time.
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’
— in this one, replace the last line DPT_AUTO_KEY with whatever field name you want to look for.
Ok, so have you ever been working with QC tables, in Crystal, or in SQL or whatever wanted to know what tables were dependant on any given auto key?
Well, here is an SQL statement you can run that will show you just that. Just replace the DPT_AUTO_KEY value with whatever field name you want, then run the statement. It will show you all tables in Quantum that have that field in it.
select utc.table_name, utc.column_name, subStr(utc.data_type,1,10) data_type, utc.data_length, (select min(pk.table_name) from user_cons_columns ucc, user_constraints uc, user_constraints pk where ucc.constraint_name = uc.constraint_name and pk.constraint_name = uc.r_constraint_name and uc.table_name = utc.table_name and ucc.column_name = utc.column_name) parent_table
from user_tab_columns utc
— where table_name = ‘WO_BOM’
— and column_name like ‘QTY%’
where column_name = ‘DPT_AUTO_KEY’
order by column_id
Actually this querry has some line commented out (that is — lines). You can uncomment the table name and change the WO_BOM table name with another table name to see this reverse. Dont forget to comment out the field name before you run it.
-
Be aware that CC is slowly fazing out the firebird platform and does not put much of the new enhancements into the firebird version.
This increasingly devalues your SMA as time goes by, and increases your risk of lost productivity (organizationaly).
The cost of an Oracle migration should be evaluated over the course of years, taking into account your expected growth, potential new business needs, number of employees increasing or decreasing, hardware needs, system support and availability, etc. This would provide the real ROI… good or bad.
-
Sandy there may a couple of options.
If these are external work orders related to customers, the tracking information can be input into the Invoice record.
If you use the shipping order module, that will and should be the primary repository of shipping and tracking information.
These changes will require a little user adjustment, but would probably be better in the long run anyway.
Hope that helps.
-
Irina, you are describing our business structure.
We have already set this all up in QC. Product lines and Segements are assigned to part numbers. Territories are assigned to company records. Department codes represent each physical office.
Our sales reports have budget numbers tied to each segment MTD and YTD as well as each territory so it is a matrix organization.
we use contact management to record and report on sales efforts which are more project driven. We also use it to enter our “hopper” numbers which is a weekly entry of what each sales person feels confident in getting for the remainder of the month. Then, these numbers, combined with open – unshipped sales order (pending) and invoice orders (out the door) make up our planning report. This report is also done by segment and territory and holds the same budget numbers as the regular sales reports so we can project against plan.
All this being said, there has been quite a bit of screen customizations done we can take advantage of user defined fields. In contact management, the screen design changes based on the contact type so as to not confuse people too much.
So, in a nut shell, if you have the screen designed module and crystal report – and the know how – you can create your own sales force managmenet capabilities.
-
Lydia,
We have found some of the following transactions to cause issues in reconciling.
1. Core returns on a PO
2. Void reciving on PO and/or RO
3. Manual adjustments, or entries to the suspense accounts. One thing to be aware of there is that is someone changes a system created entry, it still remains marked as a system created entry so if you then try to find manual entries there is no way to identify those ones.
4. partial reciepts or partial returns.
We continue to monitor and adjust as necessary.
-
Chris,
This largly depends on several factors, including which modules you use. If you use the reciving inspection module, it is different than if you do not.
Is there a quote already in place, or is this an unexected arrival.
The first step is to properly document, and flow your exisiting process. Then, redefine the flow with QC in the mix and test it out before launching the new process.
-
I think an easier and cheaper solution would be to create a unique quarentene location for each of your warehouses. Then, you can just print that location.
-
The main lot component needs to stay for sake of holding the money. Even if you precost the items, there will be situations where money will be applied to the lot header.
If you want to exclude it, identify lot header stock lines uniquely. Then, filter them out. You can put the stock line hold also – so that it does not show up in any stock reservation screens.
-
As a matter of fact, we just set up two wireless routers. One guest and one secure.
We access QC directly with great performance. I did quite a bit of research and decided on the Amped Wireless Model R10000G for its range and speed. They run a few hundred dollars, and they have a great suite of tools and controls.
Works great.
-
As an additional comment, the Shipping Order module can help eliminate this issue by better controlled the process flow.
-
The best way to solve this is to modify your 8130 in the forms designer.
Just delete the two date fields in the applicable boxes. Then, add a label object for
each of the new date displays. Position them on the form appropriatly..
Box 18 date field object should be
Left=223
Top=373
Width=79
Height=17
Box 23 date field object should be
Left=715
Top=373
Width=79
Height=17
You can set the position and size properties by highlighting hte label, then right
click and select Position from the pop up menu.
In the label Object’s OnGetText code area, add the following code to your procedure
area.
This will print the date that the work order was closed instead of the date that the
8130 was printed.
begin
Text := FormatDateTime(‘mm/dd/yy’, WO_OPERATION[‘CLOSE_DATE’]);
end;
To get the OnGetText area, click Calc tab, View and select Event.
Find your label object that you just added, click on it.
In the Events window, click OnGetText. Inset the code into the Procedure window. Right click on the Procedure window and select Compile. Make sure there are no error (display at the bottom of the screen).
Save your document as a new name. Print using the new document you created.
-
Tony, This depends for us on the product and the arrangement. Usually we put just the sold to and ship to. If necessary (like in US Government shipments) we will put the third and final destination in notes or something.
-
Ah, I see. That is a different subject. There are no reports for tax purposes that I am aware of in QC. However, that is easily created through Crystal Reports, or some other external reporting tool.
I recommend you contact Kevin Otto for your reporting needs. He can whip something up for you in no time.
Kevin Otto
888-416-6464
Fax: 909-475-6375
-
In the world of programming, there are different places a developer can grab time from.
It could be that event manager is not using the system time, or is not properly checking it for time changes.
I would suggest, at this point, to report the issue to component control. Hopefully they can correct it in a timely fashion (pun intended)
-
Jill,
Quantum has two options for managing tax. One is a flat tax per invoice, the other is a multi teir tax based on the line items. These settings are system wide, so you are either using the order based tax, or the item based tax.
It is pretty comprehensive, so becuase of that I will direct you to the help files. They actually do a pretty good job of describing the taxing methods, and setup.
Quantum can handle the situation you are speaking of, as well as much more complex situations.
You read about it in Chapter 3 under Tax Table Feature. If you have further questions beyond that, do another posting.
-
Did my posting in the other topic work for you Tony?
-
Spencer your Manufacture issue could probably be solved using the Catalog file.
Your part availability listings, that is a bit more complicated. I personally wouldnt clutter my DB with data like that. I would just make a spot on a shared drive with excel files. Then, show people how to use built in Windows search funcationality to looks for parts.