Mike
Forum Replies Created
-
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 ?
-
Not sure I understand your issue…?
You usually do not need to print a location on the part/box label.
It is only the location itself that is barcoded with location info.
Then any part can be moved anywhere without the need to reprint a label.
Before we used barcodes many years ago, we did print locations on boxes. With barcodes that became unnecessary and a waste of time, as you only need to barcode a location & box and move things into the location. The location was removed from our labels about 10 years ago.
If you are printing a location ID on a box ( and you have the BC module) then I probably need to find a way to convince you not to do that … -
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.
-
We just tested 12.3.X, currently on 12.2.8.
No issues were found, we are upgrading because of reservation bug on the barcode relocations on 12.2.8.
We don’t use Accounting.
There are some changes to Imaging (setup of it) which you will need to be aware of, although on the user interface not much/any difference to it.
Event Manager changes etc. will need careful consideration/setup/testing
All these things should have been resolved for upgrades to 12.X.
There will be more work involved/testing for 12.X. that’s all I would advise as much as anything else.
-
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.
-
We find the Zebras need specific speed and density settings to print effectively, for thermal transfer.
Maybe whatever driver is being used is not setup.
Redirected printing maybe losing some of the tweaks/settings.
We have seen that with Citrix in the past with deployed desktops. -
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 ?
-
You need to be licensed / API to do this on v12.
-
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.