Mike
Forum Replies Created
-
I would like to be able to link Work order and sub work orders for a different reason. If a Work Order has a BOM need for a part that is being overhauled or built using another work order, a link would “fill the need” for this BOM item and not have it show up in Purchase Management as an open need. (much like linking a BOM item to PO).
-
Setting is Reservation base location Transfer. Depending on setting the stock left keeps the SL or gets a new one.
-
You can change behaviour/resulting actions in inventory settings.
-
If you are using Outlook to send your email, you can write a VBA script to rename the attachment when you send it. Let me know if you need more info on doing this.
-
Kristen
It seems there are a lot of non standard quotes and other characters in this query if you copy it directly. Email me at mike@cordobaq.com and I can send you the cleaned up version that works.
-
Leo- take a look at the warehouse_locations table…. do you see your location / warehouse pairs in there ?
-
I asked this question to Konstantine at the QUE Group Conference. I was wondering if the users could define what gets added to the audit trail. It isn’t practical to check each and every column on each update / insert to see if a column should be added to audit table or not.
But I have heard multiple times from CC people to let them know what fields you would like added to the audit trail and they would likely add them in release updates.
-
Warren- is this going to break something soon if nothing is done to our Office 365 accounts? Do you have a copy of the PS script that needs to be run?
-
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
-
It’s local. Quality of print is very good, although with maybe 30 Zebras being used for label printing, we could easily have one slightly off being 100%.
We could force the error by manipulating the label a little. So it only takes someone not putting the label in the best position/flat, or slight damage at some point to the label.
I am hoping that Code 128 may offer a better solution for misreads.
-
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
-
Fairly sure this feature we had CP done to add this a few years ago, so its not a new feature. I believe it came up in a quality audit and this was the solution for the issue of controlling these parts into the system.
Security permission 2660 is required for it, but you would still see it in Global menu, however it is also in the drop down from the Inventory button in the menu, which shows all PN/SN combinations from there.
It will flag up parts when they are received, that’s all we needed at the time.
The bigger question of expanding warnings, it would be useful. -
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..
-
Patch applied for this version and that fixed the issue.
CC-4716
Noticed whilst looking at series data fixes and checks, we had a bug, maybe in a previous version prior to August 2020 or user error, probably for a year or so previously, which appeared to break the series link on Cancelled Exchange Cores and Credit/Returned Stock. -
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). -
This is a confirmed bug, patch/fix to be supplied soon.
So far, I guess its only an issue if anyone uses Unknown Receipts, which not many users do.
If you do, then I would suggest checking your Series data, I use some SQL to do that if anyone feels they need it. -
At the moment, on our system, it seems to be anything received in via the Unknown Receipts initially, then being Researched and converted has this issue on the stock when finalized. TBC.
-
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 John- great glad you worked it out! XSLT is pretty darn powerful.
-
We had to reboot the Quantum/Oracle server as it completely crashed it.
Works fine with Stockmarket turned off.
We had this issue years ago, this should not be happening, by design.
It is frustrating, an outage or maintenance on a cloud product should not take down an on premise server.
-
That would be great but you cannot set less than 20 seconds in the options now…
Fairly sure we have set this lower previously so maybe an upgrade has stopped that?
Version 12.3.13
-
There is plenty of space around the label, in practice it is damaged labels or for example a small crinkle in the label when it gets stuck on the box. Statistically these misreads hardly ever occur, its just that even a few over 6 months is a big problem if it is a $50K unit at any time.
We are going to double check with Component Control, but it seems from our testing that the Code 39 in Quantum does not have support for the Check Digit/Checksum. If I use a mobile app on my phone and enable the Code 39 Check digit feature, the existing Stock labels with Code 39 cannot be read at all. If anyone knows any different then please do let me know.
We have already switched to Code 128 as it contains a mandatory check digit as far as we can see.
The barcode readers, existing Worth Data and Mobile apps all appear to work with Code 128 without any problems at all.We will monitor the usage and see if there any practical problems, but no issues so far.
The main issue for us is the existing stock, is there anything we can do to make sure those Code 39 labels cannot present us with mis-reads, at the moment there does not appear to be a solution for that, my guess is the label has not been printed with anything that meets the requirement for checking.
-
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.
-
Thanks, Warren, I will get the equipment checked in the morning. I would hope that would be enabled but it might explain the situation.
-
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.
-
Further suggestion, open the print queue for that printer in Windows. Then Pause printing.
Send the print job to the printer and it may stay in the queue. You could then select that print job and look at the properties to see what it actually is, possibly a RAW format.
-
It makes no sense initially, as .RPT would not be sent to a printer.
Does it do the same from more than one client/computer?
Have you ever had this working, has it just failed now?
-
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.