Mike
Forum Replies Created
-
Warren- this might be a Windows issue- I have this problem all the time with my laptop when I switch from single monitor to multiple (and not just with Quantum). It also has to do with which monitor is designated (or was designated in your case) as the main display. From what I can tell, if you position windows in the correct monitor and position on that monitor, then shut down the application cleanly, then Windows will open it properly the next time. This may or may not help but worth a try.
-
Rob- i believe that CR 2020 is a 64 bit program and it is not compatible with Quantum, which is 32 bit. It could also be an issue with the Oracle drivers not being 64 bit.
-
Would this be the same issues causing Quantum workstations to lose connection to the server and shut down Quantum? It likely isn’t a network issue as it only happens to individual workstations randomly.
-
Note that the STM received by the PO may not be the same STM in stock if the stock line was sent to repair or internal work order.
-
Leo- in the parts_master, there are a whole series of fields that start with GLD_
These are the pointers to the gl distributions table.
-
Warren
I was looking at replacing employee badges with RFID badges to improve security (anybody can photocopy a badge to impersonate another user).
The RFID badge would need to send the employee code associated with the badge to the USB port and into genericbc / tabarcodeentry like the 2d barcode badge reader does. Each badge would be “programmed” with that user’s employee code.
-
Gabrielle
you have single quotes in the SQL that are in the sql.text quoted string. You need to use two single quotes inside the quoted string like this:
q.Sql.text :=’select DECODE(EXTRACT(MONTH FROM TO_DATE(MFG_DATE)),1,”1Q”,4,”2Q”,MFG_DATE) QDATE from STOCK where STM_AUTO_KEY =’ + STOCK_RESERVATIONS[‘STM_AUTO_KEY’];
This looks like a double quote but it is 2 single quotes around the quoted items.
-
Ideally, this would be shown only to users who are administrator type accounts, since the info on the screen applies more to them.
-
Work Order Quotes- the Global menu has an option to Set Print Item Flag on selected items. Some customers use fixed price WO quotes and have to edit every fixed price item and check that box manually. If the Set Print Item Flag function could be expanded to include an option to check the Fixed Price box, that would prevent extra work or a quirky work around.
-
Look at the Receiver module settings, Misc tab. The Default Stock Cost Multiplier sets the value on the first screen on the receiving processing where you set defaults. If you put this to 0, it should resolve this for you. Take a look at the setting currently and make sure that you want this change to be global to all receiving functions and test it thoroughly.
Miscellaneous Tab
OPTION
DESCRIPTION
Default Stock Cost Multiplier
If you wish to calculate a sell price for stock received and store it with the stock line, you may enter a multiplier to use as a default. For example, if you use 1.5 as the multiplier and the stock cost is $100, the sell price will be calculated as $150.
-
Event Manager- add security (like Crystal Reports) to event groups or even individual events to limit who can run them manually.
-
Gabrielle- did you figure out how to export an Analytics report to the desktop so that you can open it in Power BI desktop?
-
Fix the Forms Designer function “GetSysCompanyAddress” to not display a comma after the phone number if there is no fax number.
-
It would be really helpful to have an “internal” Quantum change log. This is for settings, forms changes, styles changes, event manager changes, etc that administrators of Quantum can add items to and everyone else can view. Knowing that someone changed a form, or a setting and when it was changed would be very useful. I keep a manual version for myself outside of Quantum, but having this as a menu item inside Quantum would be ideal for anyone else to see.
-
Warren – do you have a CM Change alert and CM Reminder events in the library? they can be configured to do what you are looking for. If not, they may have been added in later releases of Quantum.
-
Create a PO authorization process the same as the Purchase Request authorization process.
-
Ability to link a WO BOM item to another internal WO that is making the part ready for use, so that it does not show up in Purchase Management as a need.
Move common global menu items to the same position in the menu- like Edit Header, Print, Status, Notes, Documents & Images, etc. They are scattered all over the place and different in each module.
Change Interactive SQL to only execute the SQL that is highlighted.
-
Change the statement above to this
qc.Sql.text := ’Select STOCK.STOCK_LINE from STOCK where stm_AUTO_KEY = ‘+ REC_STOCK[‘stm_AUTO_KEY’];
-
Hello John
You can use the same variable as in the XML / XSL stylesheet for the work order number in the subject line. It is SI_NUMBER.
-
The Stock ti table will give you the stm auto key which points to the stock line issues. The stock line contains the cost. There can multiple stock ti entries for each BOM so you need to sum them up to get total cost
-
I haven’t coded anything yet. I was looking for a way to get them to auto fill the price using standard Quantum processing. What I would really like is to have the RO Copy function bring over the header and item clauses as these indicate to the vendor what certs are needed and what work is to be performed on each item. The same part numbers are sent out to the same vendor for the same process many times.
-
As Nadim mentioned above, the connection is via the STOCK_TI table. The stock_ti has a wob autokey that points to the bom item in WO and it also as the stm autokey(s) for any issues. There can be more than 1 stock_ti for a bom item, so you need to sum up the quantities (to account for undo issue and multiple stock lines being issued for same bom item. multiple the qty issued by the stock line’s cost for each stock_ti entry.
-
Marcelo
I loaded your rpt file directly into Quantum v12 and it works, so not an issue with Crystal Reports designer apparently. it could have been fixed in ver 11 of Quantum or one of the v12 versions.
Can you create the report so it pulls the dynamic parameters right from the data being fed into the report, rather than having separate cmds?
-
Marcelo
I tested your report on my Crystal Reports (2016 support pack 9 patch 2) and in Quantum 12.3.10 and was not prompted for any logins. So, it must have been resolved along the way somewhere.
Looking at your report, you have the 2 cmd pulling the dynamic parameters, which are passed to the sub report. In the sub report, you use these parameters as Report select expert filters. this means that ALL records are brought into the report from the database and then filtered by the report.
It would be more “efficient” and make the report run faster if you use the 2 passed parameters in the SQL statement in the cmd of the sub report. This would only bring in the records that meet your criteria. Putting the workload on Oracle is usually always faster than transferring a lot of data and filtering locally.
Since your report is reading ALL of the records and then filtering them, you can just eliminate the sub report, use the sub report query in the main report and have the dynamic parameters be pulled from the main report query. This MIGHT resolve your double login problem on your version.
-
I used to get this a lot as well. It seems to not happen recently- maybe a new Quantum version or updates to Crystal Report designer program resolved it. What version of Quantum and Crystal Reports do you have?
I just created a small test program with 2 CMD that are used as dynamic parameters and passed one of them to a sub report and I was not prompted twice or for login.
If you want to email your rpt file to me, i can test it out on my system.
-
I’d suggest Updating some list price dates or a non used udf / sdf field with a date value. That way you will be able to reference which parts were updated if you need to undo or reset the price back for any reason. This would be especially useful if you didn’t change ALL parts prices and maybe updated where PN in a list for example.
-
Yes, you are right. The stock_reservations row for the SO item has a “printed” column. That might be what you are looking for.
-
What about the print_pickticket_flag column?
-
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).
-
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
-
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.
-
Gabrielle- Here is an example- if you are trying to query the xyz table in the CRYSTAL schema from the QCTL schema, you would grant select on xyz to QCTL, while logged in to the CRYSTAL schema in Ocrunner.
-
Thanks Pietro- in this case, it was caused by the subquery returning more than 1 row, but it just gives the data exception error, not the actual SQL error.
-
You can try opening Excel, then File, Options. Set the When opening multiple displays option to Optimize for Compatibility.
-
Josh- you need to be careful with the quoted string for the SQL when you continue a string to the next line, be sure there are spaces between the end of the line and the start of the next line. You have =PODETAIL_POD_AUTO_KEY’, the it continues on the line with ‘where…..’ this will create the string as =PODETAIL_POD_AUTO_KEYwhere, which is a syntax error in SQL.
-
Jim- when you say PO with more than 1 item, do you mean more than 1 po detail item, or a single detail item that receives multiple stock lines (like serialized)? The multiple stock lines per detail item requires different code to loop through the stock lines and append the SL number to the text field (or use a memo field) and also logic to prevent too many stock lines from spilling off the label.
-
Warren- the consolidated flag is for the email address. consolidating will combine all the emails to a single email address into 1 email, rather than individual emails being sent to the same email address.
-
Hi John- great glad you worked it out! XSLT is pretty darn powerful.
-
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.