Mike
Forum Replies Created
-
Jesse- thank you.. The link didn’t work, but it gave me incentive to dig around more on the SAP site to find the updates I needed. (That site is probably the most user UNfriendly site ever built.)
-
Out of interest, where are you saving your commodity codes per part number? We use the Part Group. When we had Konstantin here he was not sure where everyone else saves it.
This was not giving us enough fields though as commodity codes can be different depending on the country.
We have added a number of custom fields with CP, I think maybe 4 or 5 to the table, to allow alternate codes for the different countries.
That should be in the latest 10.9.X build.
When the customs invoice is printed it uses the correct commodity code for country it is being sent to/imported into.
Also having to add a custom date field to the part to prove that we have an audit date per part.
-
Hi Andre- i was referring to the software used to create the reports, not the viewer inside of Quantum.
-
We had similar problem with RO’s and had a patch done.
I assume later builds have the patch already in them.
Have you checked with Component Control?
If you have already get them to double check as sometimes the tech support don’t fully appreciate what has been fixed recently.
Sound very similar to what we saw after upgrade.
We had Konstantin here on site and he fixed it with a patch immediately. That was on ROs, so may not be the same bug.
-
Never mind- found the answer. StrToIntDef converts a string to Integer if it is a valid number, or to a default value if not. Similar function for Float is StrToFloatDef.
https://www.freepascal.org/docs-html/rtl/sysutils/strtointdef.html
-
Hi Duane.. See if this is what you what you are looking for. It pulls invoice data for sales orders and work orders.
select ‘Sale’ inv_type, soh.so_number so_wo_number, condition_code, ind.*
from invc_detail ind, so_detail sod, part_condition_codes pcc, so_header soh
where sod.sod_auto_key = ind.sod_auto_key
and pcc.pcc_auto_key = sod.pcc_auto_key
and sod.sod_auto_key = ind.sod_auto_key
and soh.soh_auto_key = sod.soh_auto_key
and ind.route_code = ‘S’
union all
select ‘WO’ inv_type, woo.si_number so_wo_number, condition_code, ind.*
from invc_detail ind, wo_quote_detail wqd, wo_operation woo, part_condition_codes pcc, wo_stm_complete wsc, stock stm
where pcc.pcc_auto_key = stm.pcc_auto_key
and wqd.wqd_auto_key = ind.wqd_auto_key
and ind.route_code = ‘W’
and wqd.woo_ref = woo.woo_auto_key
and wsc.woo_auto_key = woo.woo_auto_key
and stm.stm_auto_key = wsc.stm_auto_key
order by inv_type, so_wo_number
-
Did you figure out how to do this (Set a default printer by document) ?
-
You can use a free mobile app on your mobile to check the printed bar code is actually the same / what you expect.
We had a issue in recent upgrade where the number count on bar codes being printed exceeded 999999.
The ‘custom’ bar code form was done years ago when Quantum had a limit of 999999 accidentally written into the code. So when it went over 1000000 it trimmed off a character making the bar code incorrect.
Subsequent upgrades in Quantum did fix this, but as it was a custom form it never got fixed. It was easily fixed once we could see the bar code had been trimmed.
May not be your issue, but it is only problem we ever have seen with bar codes not being read properly.
-
Stephen- I don’t know remote app very well, but are the same bar code fonts installed on the server that runs the remote app as on the workstation? If you scan the barcode into Notepad, what is displayed ?
-
Hi Henrik
Try this
ShowMessage(‘Issuing certificates’ + chr(13) + chr(10) + ‘ for this PN is not allowed’);
This is a nice function that I didn’t know about. Are there any other similar user interaction functions like this? Like maybe getting user input of a number, value, yes/no, etc to use in report code?
I have used the Report Parameters to do my own filtering and logic decisions in Forms Designer, but it is kind of clunky. (On the report tree in Design View, Parameters are just below Report and above Design Layers on mine. Right click and select New). I can do a write up on what I have learned and how I use it, if that would be useful to others.
-
Henrik- how are you doing this in Forms Designer ? I tried and it doesn’t recognize the ShowMessage function. Can you show some of your code here ?
-
We will continue to manually populate the WO# in a UDF (UDF_005) when closing and reconciling internal work orders. This field displays on a stock browse window for a master part. Using the Audit Trail on a stock line will help follow the history beyond the most recent occurrence.
-
BIll- if you want to see each line item individually, this will show what you want.
select so_number “SO#”, cmp.company_code “Customer Code”, sh.company_ref_number “Customer PO#”, sh.entry_date “Create Date”, sd.qty_ordered, sd.qty_invoiced, sd.unit_price, sd.unit_cost
from so_header sh, so_detail sd, companies cmp
where sh.entry_date = to_date(‘7/22/2017’, ‘mm-dd-yyyy’)
and sh.open_flag = ‘T’
and sh.cmp_auto_key = cmp.cmp_auto_key
and sh.soh_auto_key = sd.soh_auto_key
-
Keith- that is what we are looking for as well. How is that code set ? do you manually update it ?
-
I am not sure if this answers your question:
We just had CP done to Add stock line auto_key into the Import function for users on the Sales Order module.
If the auto_key is present it will allocate stock as part of the Import automatically.
We added this as we use Sales Orders to dispose/scrap stock.
I got a little tired of being asked to be an import every week on DIA….
It will – when the CP is released – be a user function…
** Update – this will be completed in our Nov CP which is in Quantum 10.10 – so you would need to do a 10.10 upgrade to use it.
-
Keith- how is the Cons Code field set with the WO # ? I don’t see that set for any of our stock lines.
-
I know this is an old post …
You can window Quantum and then stretch across as many screens as you wish. Then move around module windows etc. to suit what you want.
Not quite pop out windows, but might help anyone who has not tried that.
-
We are on 10.9.16 and we have had various issues with scanning over the last 2 years after upgrades. Some of them we have had fixed at the time, needed big fixes etc.
I would be wary of being told anything about compatibility, as I suspect it has become the default position to take whenever there is a scanning issue they can’t fix in 10 minutes (from experience)
-
What symptoms are you having ? I have issues with the scan function hanging up. Quantum has to be killed and then it usually creates bad image links in the most recent 2 documents, which need to be manually deleted and then rescanned.
This has happened 3 times in the last 2 months- support suggested updating device drivers from scanner mfgr (Brother MFC-7680DW). We will see if it happens again or not. We are 10.7.112 running Windows 7. Scanner is USB connected.
-
I will add to that…
CC don’t provide a decent level of documentation – both pre-sales and user documentation.
Using F1 search in the module itself is not good enough.
That Help often doesn’t cover all the aspects of a page you are looking at.
Surely when anything is added to Quantum they would do a full documentation update that serves both their internal requirements and their customers.
I don’t mind paying for services, but not providing good quality documentation is either incompetent or done on purpose to extract more money via professional services because you can’t answer a few simple questions yourself. Possibly both!
A good example, when you pay for a new module they insist on an installation/training fee of $1,600 a day for which no documentation is provided at all in the process. Just someone’s time.
So for $7,000 of expense the only document I would likely receive is one with an invoice number on it….
-
We are looking at this too, so would be interested to find one.
We can print to anything with a mobile app, but we need a printer that is not Direct Thermal, as the print on those only lasts an unknown amount of time, which is no good for us.
So it depends on how long you need the label to last.
The only mobile Thermal Transfer model I know of is the Zebra P4T but I have not tried one yet, would be interested to know if anyone has one of those?
-
Would be curious to know your setup? Maybe what the user thinks is slow? 1 second, 3, 5 or more?
Our image server(s) are very quick, almost instant.
They are virtual so easy move around and change h/w config.
I have 3 at the moment, 2 read only and 1 live.
I only allow them to get to 800GB, then roll over to another virtual machine. That spreads the load and then I only have to keep up to date backups of the read/write current server.
I keep Adobe Reader as default, as most full PDF programs are just slow to start up. Nuance for example on a PDF can take an extra second or two which most users find annoying.
The other times I see speed issues are with remote desktop access users.
I.e. any time you are not running/accessing images directly on your LAN connection.
In that scenario, it really only comes down large image files over a WAN connection which can be very slow and there is no way around that other than managing file sizes that are saved.
We are also developing our own mobile app for the iPhone and images are instant on that too, so it shows the underlying speed of the image server is not an issue (generally).
-
Thank you Andre !
-
GG- I have this happen often as well. Easiest way that I know to get the dialogue box back in front is to click the Quantum icon in the taskbar, which brings the current window / dialogue box to the front (at least for me it does).
I have a similar, frustrating behavior with windows. I use 2 monitors and sometimes a pop up dialogue box will appear on the other monitor. Seems to happen all the time when doing any kind of receiving.
-
Thanks Keith-
We don’t void the receiving, just undo the stock issue, so that we can reserve the SL again and link a new repair to it.
It seems to work and collect costs properly doing both techniques (send the same BOM item out multiple times vs create a new BOM item for each repair). I was just trying to find out how other shops are doing this and if there is a best-practice technique for this scenario.
-
Hi Stephen
The UDF fields are not part of the datastream for PN labels, so you will need to pull them from the database on the fly. If you look in the Members Only section, QueSources, Forms Designer, there is a Forms Designer Cheat Sheet with many great examples of how to do this with SQL inside of the event handler for a form field.
The part number label form is set up differently than the barcode form, in terms of the event handler procedures- not sure which you are printing. Basically you add a text object on the form, name it what you want. Then create an event handler and add the code to pull that field from the table and put it in the text object.
If that doesn’t help you get started, let me know and I can send you a customized label we use here.
-
Update : 10.9.10
10.9.10 build done for the bugs we found and we upgraded to this last night.
All points above have now been fixed.
I am still not 100% sure about the client update being smooth.
But you can at least work around that if you do get it.
Image temp files are now named:
(image_ID) + (original_file_name)
For example: 401765_scannedcert.pdf
This means the temp file is always unique, as it needed to be.
10.9.10 seems fine for the modules we use now.
-
This isn’t strictly voice recognition, but something very cool that Google Glass Enterprise Edition can do – voice activated commands to view drawings, etc. No reason that it could not be extended to record and translate findings, etc.
-
A simple fast way is to use the interactive SQL window in Quantum (User menu, Interactive SQL). Type in this SQL-
select * from companies
Click the yellow slash icon (Execute) to execute the query. Then click the save icon (a diskette) to save to a CSV file on your computer. Open that CSV file and delete all the columns that you don’t want, then save as Excel file or CSV as needed.
-
Thanks James
To sum up:
1. Client upgrade is not straight forward – on this build expect problems/time wasted. It is just a bit painful.
2. Changes on Repair Order for someone else’s tracker has stopped us raising some charges, a new rule/logic has been added.
3. Images – big problems on this due to a tracker which attempted to keep file name intact for export I am guessing. Despite Cole D discussing this at QueGroup and pointing out it would cause major issues with temp files with duplicate file names – changes were made anyway. A big problem if you use ISIS scanning as we do in stores as it always names the file temp.pdf.
The idea was good but the execution was poor …
4. In Repair Orders there is a cache issue with Find/Loading RO’s whereby when you find and open a 2nd RO, the window in the bottom left of Window keeps the previous RO number in it, the title of the RO Window also has the previous RO number on it – so it is very mixed up!
Overall I am guessing that cache issue might show itself up in other places if the fundamental design/usage has been played with.
5. Custom Barcode label stopped working. Not 100% an upgrade issue but the upgrade certainly made it fail 100% when transferring parts.
We had to check the latest Std Barcode label to see why the custom label did not work Fairly easy fix in house, but a pain when 300 boxes had the wrong label on within 5 hours. Only affected new parts booked in.
The above issues will be fixed in an urgent build revision being done today/tomorrow.
Not sure if the client install will be fixed that quickly as it may need a bit of thought and testing outside of what CC can do in house.
I would certainly advise caution with this upgrade as some of the issues are not apparent when testing initially.
This build is certainly not as well tested as previous builds/upgrades.
We had Konstantin onsite this week anyway which meant we could investigate and apply fixes.as we found them Which is why I was wiling to do the production this week.
-
Marty- the program is part of Quantum control. It is a stand alone executable, just like genericbc.exe.
-
Timothy.. These are stand alone programs that are used in the shop for workers to clock in and out for the day for payroll, as well as clock on and off jobs / tasks to charge labor, issue parts, check out tools, update WO / task status and some other functions.
It allows them to work with Quantum in a simpler, basic interface for these functions, using bar code scanners and touch screens. Plus the license to use these is a less expensive license than the full workstation license.
-
We ran into this a few months back. These are my notes on how to correct this. Hopefully this will help !
Scenario- wrong job closed and invoiced. Or any time a posted invoice needs to be deleted.
1. Open the AR account for the invoice (go to invoice, then Global / Go to AR)
2. Add item to AR details- make it the negative amount of the total due. Set Distribution to Sales, add comment describing reason deleting this.
3. Before posting the batch that this creates, you must edit the batch and change the Sales GL account to match the GL account being cancelled. Inspect the batch for 1st line item (cursor on Batch Number column, click the inspect. Note the GL account. Then do same for new negative line item, inspect the batch and edit the GL account to match.
-
Andre- this looks great. I tweaked it to add STM.PN in the COALESCE statement and corrected the WO left outer join to IML.Source_PK = WOO.WOO_Auto_key.
Apparently the userid is not saved with images, so no way to determine who uploaded the image ?
When images are scanned using Twain, the file name becomes “temp_USERID.pdf” (USERID is the Quantum Userid). Any way to modify this file name or specify a default for scanned images ?
I noticed an image pointing to a Parts_Master autokey that does not exist. The PN was created, image attached, then PN deleted. Looks like a bug to not delete the associated image.
-
Do you have other outside of Quantum applications, tools, etc accessing the Quantum Oracle databases? From what I understand, these count in the total users. Maybe your Prod connections from these are being copied to the Test system
-
Are you using username sys@cctl ?
That would be the default filtered view on that username.
If you use qctl@cctl you will get:
AC_BAY
AC_CATEGORIES
Different view again on dia@cctl etc.
It goes without saying but I will say it anyway … exercise caution in this area…
-
When you access the Maintain User Security Profiles (User, System Setup, Security, Maintain User Security Profiles… or press Ctrl+F9), do you see the users with status Active ? Have you tried to kill those users one by one ?
-
We use both terminal server and Citrix Xendesktop (which still uses roaming profiles).
Provided best practice is followed regarding redirected-folders and roaming profiles the speed issues should be limited.
It requires fine tuning to make sure you get the speed you need.
It will always be slower to startup, maybe 20 seconds, but after that you should not notice much difference.
If you get very slow loading times then best practice is not being followed, a good example is redirected folder(s) not being used.
Would also advise using something to keep profiles clean/lean, for example CCleaner or the equivalent.
The other issue is of course hardware setup, the terminal server needs to be high spec. as you get the performance you pay for …
-
You set the default image code in the Global Settings (User, System Setup, Global Settings. CLick on the Document Images tab and you will see the Default Image Code entry.
-
Depending on your model, this should be the steps:
Scan the code to “start setup”
then scan code to change the “terminator character”
then scan the code for a “2” in the barpad table (to choose tab character)
then scan “end setup” code.
-
Do you have the tnsnames.ora file in your Oracle client folder (mine is in c:oracleproduct11.2.0client_1network) ?
It should be a copy of d:QuantumDBproduct11.2.0db_1networkadmintnsnames.ora
-
Hi Krissy
Here is what mine looks like.
Connection Name: Quantum Live
Username: QCTL
Password (hidden, but it’s quantum)
on Oracle tab,
Role: default
Connection Type: TNS
Network Alias: MAXQPROD
-
This is our procedure, which I believe runs every night to reset every user’s fetch size, if you wanted to automate it:
create or replace procedure avtrade_fetch_reset is
sysuq number;
begin
for r in (
select sysuq_auto_key from sys_user_queries
) loop
begin
update sys_user_queries set max_rows = 50 where sysuq_auto_key = (r.sysuq_auto_key);
commit;
exception when others then
rollback;
end;
end loop;
end;
-
This works on my test system to reset by sysur key:
update sys_user_queries
set max_rows = ’50’
where max_rows = -1 and sysur_auto_key=20
-
Looking into this further- We cannot add the part number to the manuals from the part owners (like Delta, Southwest, etc), because this would cause the Delta and Southwest manuals to always be added when ever this part is on a WO.
It looks like a PN MUST be on a manual, in order to attach it to a WO or Task- has anybody found a way around this ?
I can either use SQL to attach a specific manuals to a WO / Task or put the PN on ALL versions of the manual and then delete off the ones we don’t want. Both are kind of messy and not acceptable.
-
Hi Stephen.. This is done in the Forms Designer module. You will first need to add the signature in the global settings, then add code to the form to load the signature from the system images and display it if the check value is less than your threshold.
Let me know if you need more help with this.
-
Here is what I came up with to use Purchase Management on a subset of all open, released Work Orders.
I created a fictitious tail number to use for a specific group of Work Orders (used the Model as actual model code, owner was us, serial, tail and reg number identify the group (i.e. “10c Ground Carts – Batch #1”)).
Then added this tail number to all the Work Orders in the project, and set as the only filter in Purchase Management. I now only see the part requirements for these flagged Work Orders.
-
Hello Henrik- would you be able to send this report to me as well ? many thank !!
-
I’m a huge fan of doing pics/scans via a mobile app, especially OneDrive & Lens.
All options have their own strengths etc. We run 2 different ones, just to provide a backup option when the main one doesn’t work, which does happen no matter what product you choose.
Off topic slightly, but you can use Lens direct from Onedrive and it will save the image to the location you are in (on the app), giving a little more flexibility for filing options. Although it is quicker just to use Lens if you just want to use the one default location.
-
great- would you be able to post some screen shots of QuantumMechanic.exe program tabs? Would love to see how it works vs the Genericbc.exe for labor collection and time & attendance.