Mike
Forum Replies Created
-
Did you figure out how to do this (Set a default printer by document) ?
-
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 ?
-
Keith- how is the Cons Code field set with the WO # ? I don’t see that set for any of our stock lines.
-
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.
-
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.
-
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.
-
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
-
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 ?
-
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 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 !!
-
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.
-
Is anybody using this in 10.8 yet ?
-
This is great stuff, thank you for sharing.
Have you used this to do things like send an email when an SQL returns some value (like notify when WO created with Warranty check box checked), email a crystal report only when a SQL finds certain conditions) ? What does that code look like ?
What is the code to call a Quantum DLL ?
-
Great- this is exactly what I was looking for ! I can think of several other uses for this type of functionality. Thank you !!
-
Hi David- this is very helpful, but I am looking for fields that are used in the code which are part of SQL statements. These would be pulling fields that are not in the data source provided to the report. I don’t see any way to search all of the code for a given field name.
-
Did you find out more about how the Freight Forwarder is used ? We don’t use the shipping module, but it is on the Sales Order header Additional tab. I could not find anything in help about this either.
-
Henrik- i am interested in doing this as well- i tried several of the download versions but could not find the right one. Which one do I pick from that page (https://www.digital-metaphors.com/download/) ?
I want to be able to search the code for field usage (ie- does this form reference a UDF? )
I have seen old references to a program called RAP2TEXT, but cannot locate it or it’s developer.
-
Here is how I add the Work Order number to the report. This is added to a variable in the detail section for each item on the RO. Hope this helps…
var
qc : TOracleDataset;
begin
qc := TOracleDataset.Create(nil);
qc.SetSession;
if RO_DETAIL[‘WOO_AUTO_KEY’] = 0 then
qc.Sql.text :=’select SI_NUMBER from WO_OPERATION where woo_auto_key = (select woo_auto_key from WO_BOM where ‘ + RO_DETAIL[‘WOB_AUTO_KEY’] + ‘ = WOB_AUTO_KEY)’
else
qc.Sql.text :=’select SI_NUMBER from WO_OPERATION where woo_auto_key = ‘ + RO_DETAIL[‘WOO_AUTO_KEY’];
qc.Open;
Text := qc.FieldByName[‘SI_NUMBER’].AsString;
qc.Free;
end;
-
Great, thank you for this- I was totally stuck and now am moving forward !
So i take it that you cannot add SQL statements to fields like in Forms Designer ?
-
Could I get a copy of the report(s) as well ? Just getting started with Crystal and trying to come up speed as quickly as possible.
-
Ryan- That would make the printed invoice correct, but the data (ie Invoice header) would still have the wrong address. I’m still exploring ideas how to do this.
-
Ryan- thanks for pointing me in the right direction. Sending signature image to the back didn’t work with the other elements (signature name text, lines and background shape color), but turning off the background color and then bringing the lines and signature text to front made it work in the PDF.
-
Ryan- you are right, this would work. However, it is a timing issue- Work order and quote are created by operations, billing and invoicing by front office when job is complete. Customer notifies operations of the change in shipping while job is in progress, which could be days or weeks before the billing.
-
What I mean by the overhead is this- when we add a labor hours to vacation job, either by directly adding, or using the Labor or Vacation entry from Shop Control drop down, it adds dollars at the burden rate and the overhead rate. We specify these on the worker, not the skill.
When Time and Attendance adds to the admin work order for the in between job time, it knows not to add the overhead.
I think what we are going to do is create a modified Employee Performance report to just show a daily summary of all hours in the various buckets and then show what the GL entries need to be for any vacation, sick, holiday dollars. We can then use this to create GL entries for those dollars.
-
Opening an old thread in hopes that someone could send their shelf life report, possibly that has been updated with the “open days” data as well.
Many thanks from a Crystal/Quantum Newbie !