Mike
Forum Replies Created
-
If your tasks are processed in order by sequence number, then you the next task is the one after the current task, if you sort them by sequence on your query. That assumes that tasks are closed when finished and only the current task is open. So the current task is the open one and the next task is the first task with a sequence higher than the open / current task.
-
Tim- take a look at the auto number logs in Global settings… are the sequences and accounting companies crossed up?
-
What happens if they log in as a different user on that same workstation? If it still happens, I would consider deleting the computer\HKEY_CURRENT_USER\Software\Component Control USA, LLC.\Quantum Control registry key on that machine.
-
Hi Glen
You need to set up the style in the Crystal Reports Manager for the report you want the event to print. Then you can create the event in Event Manager and reference that style name.
-
Hello Henrik! I hope you are doing well.
I have seen that in the past- maybe try uninstalling the Quantum client and reinstalling? If you are on the older version where it is installed in Program Files, then use the Windows uninstall. If new version where Quantum is in c:\Quantum, then delete everything in that folder except Quantum.exe and Quantum.loc, then right click on Quantum.exe and run as administrator.
Does this happen on all reports or just one? Does it always happen? What Quantum version are you on? The parameters are static or dynamic?
-
I’d suggest to simplify this a little and not use the VIEW_DASH_WO_BASE just to get the work type- join the wo_operation to the wo_work_type to get this value (the view has a LOT of table joins, which will slow down your query).
Tim is right on about the joins- left outer joins are the way to go when there might not be a match on the tables. If no match, then that wo is not returned at all.
As far as the repair order, you need to look at the stock_reservations to find any ro_detail with a stm_auto_key that matches the main component stm_auto_key. Note that there can be multiple stm_auto_key . Here is a snippet showing the relation:
from ro_detail rod, stock_reservations str
where rod.woo_auto_key = woo.woo_auto_key
and str.rod_auto_key = rod.rod_auto_key
-
Saul- can you describe more detail about what it is not doing or what is happening differently between train and live? Are fields not being updated or are they being updated incorrectly? The script you show is only going to update open work orders that being with FP and MP where the due_date is specified.
-
This happens no matter what the printer is. The issue is with version 11( and probably earlier) of Foxit. Version 12 fixes the problem.
-
The quantum database is not defined to use “cascading deletes”, so you need to remove all child items from the parents before you delete the parent. The sql for this would not be trivial.
Are you deleting templates from the template browse or deleting templates that have been applied to a work order?
If you’d like help with doing this let me know
-
Hello Saul
This is pretty standard within Quantum. You need to delete/remove anything attached to an item before you can delete that item. This applies to templates, Quotes, sales order, etc..
-
What is your default PDF application? We have similar issues printing anything directly from documents and images when Foxit Pro is the default pdf handler.
If you want to send the rpt file to me I can take a look at it for any internal settings. Right click on it in the Crystal Reports menu option in Reports and save locally.
-
Hello Leo
If you do a search here in the forums on the QUE group site for “attribute”, you will find some posts and answers to your solution. I could post the answer for you directly, but better to “teach how to fish” as they say…
The search is the eye glass icon on the top right of the pages….
If you are still stuck on this, let me know !
-
I believe that if you just update the stock line gla_auto_key, you will not update the general ledger account for the inventory amount. This would make the GL out of balance with the actual stock. I would test this in a test system first to confirm.
-
What is in your GL default accounts/distribution for Late Receiver Adjustments? What does the Work Order show in the field next to the status when viewing the work order? does it say WIP or COG?
-
Zain
To search a string in Forms Designer, you would use the POS function. For example:
LOC := POS(‘abc’, INVC_HEADER[‘company_name’]);
if loc > 0 then
found it code
else
not found code
If you need help with Forms Designer, feel free to reach out. -
Thanks Pietro- that is what I was planning to do. I was hoping that there might be another way. It should be an easy screen scripter solution.
-
Rochelle- there are a couple of ways that we use. There may be other ways as well.
Change the RO cost for the item to 0.00 and receive it (you have to do it this way if it is the main component of the work order, but it works for BOM items as well).
Delete the reservation for the RO item and edit the RO item quantity to 0. Then reserve and issue the part back to the BOM item.
Then add an item note to the RO to document that it was cancelled by customer. -
The serial number functionality was added in version 10.10.5
-
I made a 3 up version that does not require the patch to work. It uses the original data output.
-
If CC is not going to supply a 3 up version, i am going to create one in Crystal….ourr accounting department also bought the 3 up forms lol..
-
Has the form changed from 2020 version ? if so, CC should be providing a new report to use. If it’s the same, can you exchange the 3 up for 2 up ?
-
Hi Jeff… We use Shop Control to build / manufacture parts and it works okay, as long as you don’t need to do anything fancy with it. You can create a stock line for the PN, then create the internal work order with that stock line as main component. Then apply labor and additional BOM parts, outside repairs, etc. When finished, the stock line has all of the costs added to it, and you can use it however you wish (SO, customer WO, etc).
Make sure that you just put 1 stock line on the internal work order, with a quantity of 1. If the quantity is > 1, then you cannot use any of the new parts until they are all finished and the work order is closed. (ie- no partial reconcilliations- you can do partial reconcilliation, but it will mess up the costs on all of the subsequent stock lines. CC said they are going to remove that functionality soon). -
Hello Jesse- there is not a forum for this module yet. We are building out a new replacement website for the QUE Group. I will see that this is added to the new site.
-
Josh
An event manager report or script could be run nightly to look for and email a list of specific image types and expiry dates within 30 days. -
Al-
You are right, there is no report in Quantum for this. Your inventory counts are probably in the Physical Inventory module as batches, which you can find in the PI module dropdown, search PI headers. It would not be too difficult to create a Crystal Report to summarize the batches. You can also print the count sheet and variance report for any batches one at a time.
If you need help with this, let me know. -
Good to know !
I ran a scan using our Lansweeper product and it found about 40 software products on our network that are listed as vulnerable. Most of these are Dell software products on the Dell workstations and some Oracle and Apache on the server. Interesting was that Fortinet VPN is amongst the vulnerable. -
Hi Glen
Yes, Quantum can do this. We had 2 label printers, 1 for FedEx and 1 for UPS. I switched UPS to use the FedEx printer, set it up with 4 x 3 labels and now Quantum uses the old UPS label printer. You can design your labels to fit the thermal label stock that the printer uses. We also have different size label rolls for special projects, etc. that we just swap when needed. If the label size that you need will fit the printer, you can print what ever you need from shipping module on them. -
Has anyone contacted CC about this ?
-
Sarah- the best way to learn about this is to look at other forms that have totals on them- like a PO or Repair order form. Look at the code (Calc tab) for the fields to see how they work.
If you need help, let me know. -
Josh- you would need to create an OCDIA script to update other fields that are not included in the import. OCDIA let’s you create your own input files and logic (with PL/SQL) to update data in any table.
-
Dana- it looks like the 2 different print methods that you want to use are based on different data feeds. This means that the form would have to be rebuilt using the new data feed that is available in the other form and cannot be just moved or copied over.
You can see this by opening any of the STD forms that the Global – Print – Authorized Release Cert shows as available forms, and look at the data pipeline. Do the same for any form that you can open in the Global – Print – 8130/PN Label/WO Label.
Let me know if that doesn’t make sense…
PS- i moved this topic to the Shop Control forum, it was originally posted in the Quantum Analytics forum.
-
This post was moved to the Shop Control forum.
-
Pietro- if you scan the code into Notepad, what string do you get ? If the barcode is not scannable, then maybe there is a font issue or the barcode is being truncated (on the left or right) or compressed so there is no quiet space between the bars…..
-
select
f.PN, f.description, a.mfg_code, b.group_code, c.application_code, f.list_price, f.foreign_list_price, f.list_price_date, f.REMARKS, dbms_lob.substr( f.notes, 4000, 1 ) notes
from MANUFACTURER a, PARTS_MASTER f, PN_GROUPS b, APPLICATION_CODES c
where f.MFG_AUTO_KEY = a.MFG_AUTO_KEY and f.PNG_AUTO_KEY = b.PNG_AUTO_KEY and f.APC_AUTO_KEY = c.APC_AUTO_KEY
order by f.PN
If you want to increase readability of your SQL, use the table’s auto_key name(1st 3 characters) as the table qualifier.. It helps identify which table the field is coming from in the select and where clauses.
For example- use pnm for parts_master, mfg for manufacturer
select pn, mfg_code
from parts_master pnm, manufacturer mfg
where pnm.mfg_auto_key = mfg.mfg_auto_key
-
John Boyce’s approach is pretty nice too, though you would need another procedure to remove the warnings (unless i am missing something).
The nice thing about the Forms Designer approach is that nothing has to run in order to make it work. When users update the vendor approval settings, the forms can be printed. The “raise” command can be used to block form printing, or the showmessage can be used to pop up a nag, then allow printing.
Let me know if you need help with this !
-
select dbms_lob.substr( notes-field, 4000, 1 )
-
McAllister- Doing this the SQL call might be more efficient and straight forward.
select case NVL(MN_UDF_002, ‘F’) when ‘F’ then ‘false’ when ‘T’ then ‘This is true’ end mn_udf_002
This also allows for null value to be treated as False
Then just use the MN_UDF_002 like
Memo1.lines.add(q.FieldByName[‘MN_UDF_002’].asSTRing)
-
There is a case statement- here is the syntax
case expression of
const: statement
const: statement
end;
It is usually more efficient and faster to do these types of things in the SQL than in the report.
-
If you don’t have event manager, but you have forms designer, another way to block PO and RO creation is to ad some code to check for expired approval in an event and either pop up a warning message or there is another way set an error to prevent the form from printing (but i can’t remember it off the top of my head).
The advantage of this is that you can create the RO or PO and then print /e email later once they are approved again.
-
Since this is an external work order, i think you will need to return all of the items and close this work order. Then open 2 new work orders with the correct quantities on each. I have found that when you change the qty on a work order that has any costs on it already, when you close the work out, the costs do not get allocated properly (it uses the old qty to split up the costs. So if you had 5 originally and switch to 3, then the 3 parts get 1/5 of the cost and you leave outstanding WIP.
-
Cinthya- the parts_master links to the position_ref via psr_auto_key. then position_ref links to ata_chapter via ata_auto_key in the position_ref.
Is that the connection you are looking for ? Are you trying to add the ATA info to a UDF in the parts master ?
-
Lee- this query should provide your connection- change the ROH header key (997) to the one you are looking at. this query allows for the RO to be for a BOM or main component of a WO/MO.
select
DECODE(ROD.WOO_AUTO_KEY,
NULL, DECODE(ROD.WOB_AUTO_KEY,
NULL, WOO_WOT.SI_NUMBER,
WOO_WOB.SI_NUMBER),
WOO.SI_NUMBER) SI_NUMBER
FROM RO_DETAIL ROD, WO_OPERATION WOO, WO_BOM WOB, WO_OPERATION WOO_WOB, WO_TASK WOT, WO_OPERATION WOO_WOT
WHERE ROD.ROH_AUTO_KEY = 997
AND WOO.WOO_AUTO_KEY (+) = ROD.WOO_AUTO_KEY
AND WOB.WOB_AUTO_KEY (+) = ROD.WOB_AUTO_KEY
AND WOO_WOB.WOO_AUTO_KEY (+) = WOB.WOO_AUTO_KEY
AND WOT.WOT_AUTO_KEY (+) = ROD.WOT_AUTO_KEY
AND WOO_WOT.WOO_AUTO_KEY (+) = WOT.WOO_AUTO_KEY
-
Craig- is this user profile part of a Quantum theme (User menu, system setup, themes, then highlight a theme listed and click “users”). There might be some screen designer code in the theme for that user on that task window.
-
Anthony- this is probably because the text font size in the box is causing it the text to overlap the box outline and cover it up. Change the height and or font size of the text, or make the box slightly taller.
It might help to make the box a region that has an outline, then place the items inside that region. If there are objects below the box/region, you will want to use the “shift relative to” right click command to allow those objects to flow properly as they expand.
-
Great idea Warren. You can set Work Order calendar for weekends and holidays (in the Work Order setup menu) and then query that for your non-work days. Then just maintain that calendar each year when you set up your new GL periods !
-
I would make note of what PN this happens on. Does it consistently happen with the same PNs? When you have 2 or 3 of them, then do a select * from parts_master where pn in (‘xx’, ‘xxx’ etc). Add 1 PN where it does NOT happen to the list. Then save this data to excel csv and open in Excel. Compare each column and look for differences in the PN row where it doesn’t have vs all the other rows. Maybe that will give you an idea ?
-
Does it happen for all parts? when you have the part edit window open, click on the Additional tab and look at the bottom of that tab. What is in the URL Link area ?
-
John- have you modified the barcode label so that there is not enough “quiet space” around the barcode itself? Also a dirty reader lens could cause mis-reads potentially. It would be great to hear how the 128 code works in comparison.
-
Susan- i tried this but it adds an additional cost to an existing PO as the charge. I would want this to be the only cost on the PO. So this would have the be the only line item on the PO then?
We have a PN called “Non-Stock Part” that we use for non-stock PO- the details on the actual supplier part number goes in the item notes, which print on each line item. So we could do similar with the PO Service Charge- add the item details / specifics as item notes.
I think that would work well.
-
Tony- glad you found it. We are having the developers add the recent activity link to the top of the forums list, similar to how it was on the old website!
Thank you for the feedback.