Mike
Forum Replies Created
-
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 ?
-
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).
-
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.