Mike
Forum Replies Created
-
Marcelo- I had a similar problem when using 2 monitors and they have different resolutions. They had me change the Override DPI parameter AND the scaling parameter, then restart Quantum. Maybe this will help (also see his note about the solution being made on the terminal server)
Issue After viewing a Crystal Report the screen resolution for Quantum would shrink
Conditions
· 2nd monitor resolution differs from default monitor
Resolution
Changing the DPI settings for your Quantum shortcut application
· Right click the Quantum Shortcut > Properties > Compatibility tab > Click Change high DPI Settings > Check “Override high DPI scaling behavior”
· Scaling performed by = System
NOTE: This solution must be in place of the local machine. If you are connecting to Quantum through a remote session, this solution must be in place of the terminal server.
Restart Quantum and attempt to open a Crystal Report
DPI setting will take place in your new instance of Quantum and will not change the resolution of your Quantum application after viewing Crystal Reports
-
Thanks guys- i have been playing around with the various options and have not found a way to not need to scan the skill barcode yet still enforce that the user has that skill.
On the User, system setup, work order menu, the Use Skills Barcode on Traveler option seems to dictate if the skill scan is visible on genericbc or not. While the Shop Control, Setup, Control options (why there are 2 sets of options, makes no sense), on the barcode tab, the Restrict Skill Selection by user and task skills seems to control if the user must have the skill or not. If you turn off the display of the skill scan and you Restrict skill selection by user, it gives the error that user does not have this skill, even if they do.
Out shop is smaller, so a user will have multiple skills and their default skill may not match the task skills, but one of their other skills does.
Maybe there is some other setting involved ?
-
Take a look at this forum post- they discuss this situation and what your options are with the new version of Quantum imaging…
https://quegroup.org/f_upgrades/9327613?rid=9330659%23#9330659#9330659
-
Jim- is it possible to just modify the STD Balance Sheet crystal report into the report that you are looking for? It already contains the SQL needed.
-
Are you seeing “remaining WIP” in the WIP Log? (GLobal, GL Utilities, WIP Log) Were there late costs applied to the Work Order ? Is there is a Reserved Qty showing at the top of the Work Order window ? Is the Main Component on a repair order still ?
-
This is from the Help in Quantum regarding Internal Work Order costs- hope this helps clear it up. Maybe you have main components reserved to the internal work orders still ?
When the work order is completed, it will need to be released and the disposition of the stock line will need to be determined. The main component may remain reserved to the work order, but the GL transactions in the WO Activity batch will be as follows:
Credit – WIP
Debit – Finished Goods
When the main component is returned to stock, the GL transactions in the WO Activity batch will be:
Credit – Finished Goods
Debit – Inventory
The release and the return to stock may be done at the same time while closing the work order; however, the GL transactions will be as mentioned above and will appear in the same GL batch. The Release WO function steps through this process.
-
Unfortunately, only items which CC determines should be on the audit log will appear there.
It would be nice if it could be a customizable list of fields that appear there- similar to the security setup where you can hide specific fields from individual users.
-
Gabrielle- I don’t know of any way to do make the linking work internally like PO/RO links.
I have created some customizations that allow links to be created and used for reporting purposes. (for internal work orders and purchase requests and some others that I can’t remember off the top of my head).
-
Sure, but not necessarily possible. Just need to return to sender
-
The mapi exe file dates may or may not indicate what version they are. The best way is to check the properties, details on the exe to show the version.
We used version 7.1.5.3 with 10.9 of Quantum and version 8.1.1.24 with Quantum 12.1. This allowed a user to use 64 bit Office with Quantum 12.1 with no problems (so far).
-
When you saved the report, did you specify “RPT_AP_AGING – AP Aging Report” as the Settings Group? Note that you cannot change this once you set it, so maybe delete the report and add it again to make sure you have the correct Settings Group.
Also, you will need to either log off and back on, or at least close the report settings window in order to see the new report.
-
What is the exact command you entered for the regserve and what version are your RWEasymapi32/64 programs ?
-
It could also be that there is user security on your version of the AP report. In Crystal Reports Manager, right click and select Security. If there are any users listed, then only those users can access that report. If there are none, then anyone is able. This might be why you are not able to see that report in the drop down.
-
You can block printing of a PO in the Forms Designer if the amount exceeds a limit by employee. You would need to set this limit someplace on the employee setup (you could use the PR limit field, if you don’t use Purchase Requests)
-
You should be okay.. but as they say, test in the train system first..
-
If there is no event that you can use, you could have EM run an SQL at 12:01am on first of each month to set the task status (or Work Order status) for that Admin WO to a status that blocks activity. You would need some way to identify that month’s Work Order- some flag or UDF or UDA that the SQL could look for.
-
Nate- how about Event Manager setting a task status to one which has activity blocked ?
-
Hi Craig- there might be better was, but this is how we do this. Since this is non-stock, it just made some GL entries when you received. Here is our process for void receiving of non-stock items
1. Open the PO with item to void.
2. If item to be returned has not been received in the PO, do the normal receive (Global / Receiving).
3. If PO is in Closed status, then change to Open (Global / Change Status).
4. Add a new line item to the PO:
a. Same Part Number and same quantity
b. Type is Non-Stock
c. IMPORTANT- Cost must be the NEGATIVE amount of the line item being returned, even if a return fee is going to be charged.
5. Receive this new line item on the PO (Global / Receiving).
6. Process the deferred receiver for $0.00, use PO number as the invoice number and date of the return as the invoice date.
-
Warren – the QUE Group board has this project underway as we speak ! We will update everyone as it get closer. In the meantime, thank you for your feedback and know that a better, more organized forum is coming !
-
Does this kill the 2nd session that gets created when you run a Crystal Report.
Simplest solution is to run that script as an Oracle Scheduled Job in SQL Developer.
-
I have seen this where a computer, especially a laptop, had 2 monitors attached and had quantum running in the 2nd monitor, then you remove the 2nd monitor. Windows remembers where to place the Quantum window, which is off the screen on the 2nd monitor that no longer exists.
Attach a 2nd monitor and i bet you will find your missing Quantum window. Or follow the instructions on this webpage. https://www.technipages.com/bring-off-screen-window-back-onto-screen
-
Scott- How does your method work to prevent duplicate login ? I would like to your source code if you want to share it.
Pietro- I would like to see that script as well. I was looking at this yesterday, to use a query to look for duplicate sessions and kill them. But I noticed that sometimes the duplicate sessions are for when a user has a Crystal Report viewer open in Quantum.
select v.machine, v.program, v.osuser, v.sid, v.serial#, s.user_name quantum_user, v.logon_time
from v$session v, sys_user_db_session s
where v.username = user
and v.audsid = s.audsid
-
In this case, I am trying to print an ATA 106 form for a specific stock line. I also need parameters for new/used, certified by, etc. It would be nice if the Crystal Reports method would work.
I have created an ATA 106 form in forms designer to be used as a print style off the stock line print label menu for now.. but unfortunately, the load style also sets the stock line to print…. so they need to click the edit and select the form instead of doing a load style to set the form.
-
yes that works, but it requires the main auto key (in this case, pnm_auto_key because it was invoked by Global, print custom crystal in the inventory module) to be entered, which a user will not know. Is there some way to retain that parameter ? Printing custom crystal always passes the relevant auto_key based on the module and context.
-
Hi Pauline- you can bring it back by going user, system setup, maintain system tables, company management browses, currency codes. Then click the find at the bottom of the window and check the Historical box, then Ok. You will see all of the currency codes including historical- edit the one you want to bring back and then uncheck it’s historical box.
-
I am still having this issue with another report now. There are several parameters defined in the report, one of the is the pnm_auto_key, which is passed to the report using custom crystal and rpt_custom_crystal. Passing the pnm_auto_key works great, but the other parameters (not optional) are never prompted for and the parameter panel on the left of the report cannot be changed (clicking with mouse does nothing).
any ideas ?
-
You could create an unverified company for them and be able to send out quotes. You can see the quotes in the company browse for customer quotes. Because they are unverified, you are restricted in what you can create for that customer until they are verified and become a regular company.
-
I get errors trying to import a table in 12.1.15. Same error when i try to just add a table.
I got around this by restoring the old OCDIA from before upgrade (10.9 in our case) and use it to import the table. Then close it and finish the rest of the setup and import with the new version of OCDIA.
-
Maybe you’re not getting the right costs summed up is due to multiple kit build quantity (and you don’t know which stock line went to which kit and each stock line as different costs), or the bottom window of the stock issue window only shows a couple lines and there were issues and un-issues and re-issues, etc. Resize that bottom stock_activity part of the window to see all the transactions and sort them by date to make it more clear what is going on.
Assuming that your kit build quantity is 1: run this query in Interactive SQL- change the MSI2072 to your SI number. it sums up all the stock issue stock line costs for that SI. That number should match the cost that you see when you go to the Global, Kit options, browse assembled kits and then inspect the built stock line.
If your kit build is for more than 1, this won’t work.
with bom as (select wob.woo_auto_key, wob.wob_auto_key
from wo_bom wob, wo_operation woo
where woo.si_number = ‘MSI2072’
and woo.woo_auto_key = wob.woo_auto_key)
select sum(stm.unit_cost * sti.qty)
from stock stm, bom bom, stock_ti sti
where bom.wob_auto_key = sti.wob_auto_key
and sti.stm_auto_key = stm.stm_auto_key
-
Anthony- if you have 10.11 or higher, you can use the Colored Grid / Color Management to create your own customized colors/fonts for various browse windows. The one to use for the IC Repair Order history is QQ,IC,REPAIR-SHORT. You should be able to provide a condition to meet your needs and set the color as needed.
-
Take a look at this post- Jason supplied the query for WO Cost analysis..
https://quegroup.org/f_crystal/10033943?rid=10041043%23#10041043#10041043
-
2 things to look at- what is the code that loads the memo field or is it a DB field ? And if you select the data from isql directly, does it appear as a long text string ? there might be carriage returns in the data..
-
Craig- if you uncheck the Char Wrap on the right click properties, does it display properly ?
-
Can you send a screen shot of what you are seeing ? i have noticed that some display monitors that have flatter aspect ratios (wide but not very tall) will cut off Quantum windows, not showing items at the bottom of the window.
-
Craig- is the memo field not expanding to as the text grows to multiple lines ? can you share a screen shot of what you are seeing and a screen shot of when you right click the memo field in the design view?
-
You can change the select statement to get the sequence and the text column. Then on the line where you add the rows to the memo field (memo.lines.add), you would put the sequence field like now and add
+ ‘ ‘ + q.FieldByName[‘text field name’].AsString
before the closing right parenthesis. So basically concatenating the sequence with the text on each line.
This will make the report print faster (each time it has to stop and get data from the database takes time).. Plus if the text spans multiple lines, i don’t think it will line up with the sequence number in your current report.
-
Gabrielle- group by and count are the answer here. This is a simple query to count the number of sales orders created each date. You can modify it to your query as needed.
SELECT entry_date, COUNT(*)
FROM so_header
GROUP BY entry_date
ORDER BY entry_date
-
Sarah- if you add “order by wti.sequence” to the end of your sql text in the code, it will sort the data returned in the proper order.
It looks like you are pulling 4 memo fields to display the info- just make sure they are all sorted by the same column. You could possibly combine the sequence number and text into a single memo field so that they line up when the text is longer than a single line.
-
How does Mobile Imaging compare with ImagePro in terms of price and functionality ?
-
Brandon- take a look at the QueSources in the members area, in the Forms Designer section. There is an entry there for querying the attributes.
Home/ Members-only /QUEsources/ Forms Designer
-
DIA is way more powerful, not quite as user friendly though. PL/SQL is pretty basic language. You can figure it out looking at other DIA scripts provided.
-
We just use the invoice that gets created from the WO Billing to send to customer. I created a modified WO Invoice form of the standard invoice that only prints the first line on the invoice and any charges that were added to billing or invoice. They load this as a style when printing. (invoicing a sales order, they use the regular invoice form). This prevents all the lines from every WO transaction from appearing on the invoice.
-
Another trick that i use is to aggregate the results into a single text field. In this case, the sub select is returning multiple rows, so there must be more than 1 Po for each SO. Maybe that is legit or maybe there is a cancelled PO that was recreated, so 2 exist.
There are many other scenarios where there might be one or more items that match in the sub select. You can try this listagg function and you will see the all the matching PO for that SO.
(
SELECT LISTAGG(POH.PO_NUMBER, ‘ | ‘)
WITHIN GROUP (ORDER BY POH.PO_NUMBER) “PO_NUMBER”
FROM PO_HEADER POH,
PO_DETAIL POD,
PURCHASE_SALES PUS
WHERE POH.POH_AUTO_KEY=POD.POH_AUTO_KEY
AND SOD.SOD_AUTO_KEY =PUS.SOD_AUTO_KEY
AND PUS.POD_AUTO_KEY =POD.POD_AUTO_KEY) PO_NUMBER
i have not tested this but have used something like this many times in other reports.
-
Josh on our Quantum, the WOS_auto_key can be null, which indicates a Pending status. So that join will not include those work orders. That may be your issue. Also, not sure what the p= is after the 2nd date comparison ?
-
single row sub query errors are generally produced by this type of statement- try removing it and see if the error occurs still- if not, then dig into this sub select and see what is causing it to return more than 1 row).
(SELECT DISTINCT POH.PO_NUMBER
FROM PO_HEADER POH,
PO_DETAIL POD,
PURCHASE_SALES PUS
WHERE POH.POH_AUTO_KEY=POD.POH_AUTO_KEY
AND SOD.SOD_AUTO_KEY =PUS.SOD_AUTO_KEY
AND PUS.POD_AUTO_KEY =POD.POD_AUTO_KEY
) PO_NUMBER
-
Figured it out with help from Jake Anderson. In a Formula Field, the Crystal Report function called FileName returns the file name of the report. When running the report in the Crystal Report editor, it shows the file path and name where the document lives on your local workstation.
But when the report is run within Quantum, some other magic happens. Apparently, Quantum creates a temporary file in the users temp folder, named like this:
C:UsersITADMI~1AppDataLocalTempqCRI_234_6c6b9368-5cb2-3e37-d500-e1781caab5c3_tmp.rpt
As you can see, the filename here appears to contain the cri_auto_key from the report. A little checking by hovering the mouse over the report name in Crystal Reports Manager confirms it to be correct.
So a little string magic and you have the cri_auto_key for the currently running report. Here is a formula that extracts cri_auto_key from the FileName function return.
Local Stringvar string1;
Local Numbervar loc1;
Local Numbervar loc2;
loc1 := InStr(Filename,”TempqCRI_”) + 10;
string1 := mid(FileName,loc1, 20);
loc2 := InStr(string1,”_”) – 1;
left(string1, loc2);
The reason for wanting the cri_auto_key is for a Sale Order C of C report i created. I wanted a drop down box for the signature name that only contained user names authorized to run this report. That makes it easier to maintain that dropdown when personnel change- changing the security of who can run the report changes the drop down list.
I am sure there are other uses for the cri_auto_key- like displaying the actual name of the report and date modified, as shown in Crystal Reports Manager, in the footer.
-
how to get the cri_auto_key, inside the report, for the report being printed is what i need to figure out.
-
awesome- glad it worked for you !
Learning RAP (the code for forms designer) is not easy, but once you look at existing code examples and learn to decipher the error messages, etc, it gets much easier. Browsing this forum is also a great way to learn it.
-
Thank Ian… i think we have the signature part figured out.. Now i am trying to figure out the CRI_auto_key for the Crystal Report being printed.
-
Sarah- look closely at the code in the message above. the Var statement and the next qc statement come BEFORE the begin statement. In yours, you have begin, then var, then qc.. then the actual begin statement.