ggreenwade
Forum Replies Created
-
Very nice website! I like the updated search function 😀
-
We would be interested in this too. Also like to be able to place warnings on the stock lines. Something that pops up is always helpful in grabbing the users attention.
-
I am interested in this too! That would be very helpful.
-
Thank you so much! It works perfectly. 😀
-
I don’t know why I cannot wrap my mind around dates and sql statements… I need help again, not too sure what is wrong. We have a custom sql report that runs in EMGR the last day of every month. We want it to show all work orders that closed 5 yrs ago during that month. When this runs in EMGR it misses the last day of the month. Any advice? We have had this report run both the last day of the month and the first day of the next month with no luck.
SELECT SI_NUMBER, TO_DATE(CLOSE_DATE) DATE_CLOSED FROM WO_OPERATION WHERE CLOSE_DATE BETWEEN ADD_MONTHS(TRUNC(SYSDATE,’MM’),-60) AND LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE,’MM’),-60))
Thank you!
-
Thank you Jason! That was the setting I kept missing.
-
Sorry to piggyback on this discussion. We are looking into the approved vendors, does Quantum stop an RO from being created for a p/n if the company is not on the approved vendors list? Or would the forms designer option be the best one?
Thank you!
-GG
-
Awesome! Thank you so much.
-
Batches have been posted and bank rec is closed.
I’m hoping its as easy as going into the check and clicking reconcile to open or clear…
-
This is something we would be interested in as well. I was thinking about using charges to show two different kinds of options…
-
Thank you everyone for the advice!
-
We were able to figure out what was causing the issue.
Under the settings in Customer Quotes Module the “Disable stock avg cost” was unchecked.
Sorry I did not post this earlier.
Thank you!
-
I would be really interested in learning more about that!
-
Thank you everyone for the responses!
This is what I have done in the past few days. Optimized the drives, windows updates, restarted the server. Unfortunately, we notice the highest delay in our quote module. Last night I was the only one on the database and it took 30seconds to add a line item to a 78 line quote. This morning our staff has noticed only a slight improvement, nothing to really get excited about. I looked at our settings and I do not see anything that has changed to cause a delay issue. I submitted a ticket to CC for them to look around. Very frustrating. 🙁
-
Hi Warren – That’s what I thought but I am not noticing anything eating it up, I have been looking at the performance in Task Manager. Is there another place I should be looking?
Hi Pietro – I do monthly windows upgrades at the end of month. I will try running the optimizations.
Thank you for the responses!
-
Thank you!
-
We have the same issue here as well. Not all the time but has been happening more frequently.
-
Hi Siying,
That is unfortunate Quantum did not design a view user and edit user.
Thank you for the feedback! I apologize for taking so long to reply.
Thank you – GG
-
Hi Mike,
We do not have screen scripter only screen editor. From what I am told CC does not have that module for sale either.
Thank you
-
Hi Abigail,
I am looking for a report that will show the stock line information, including cost, qty on hand, qty reserved, consignment, location, condition, pn, description. That can go back into the past and pull the correct information of what was in stock on a selected day.
Thank you!!
-
Thank you All for the feedback!
Ian – That default location field is something we just ‘discovered’ and have started using. Its a good start but our receiving department is wanting something more advanced.
Abigail – Thank you for the thoughts. I will put it as a recommendation to Component Control. Not too sure how to get over some of the hurdles you have mentioned.
Thank you again! 🙂
-
I wasn’t too sure either. It would be a great if the program could identify dims of a part and automatically select a location that would be free based upon the part dims and the dims of the bin.
-
Thank you John!
-
Hi Dave,
I figured that would be the case. In this instance the user was only logged in once but showed twice. We are running out of licenses and have to be very careful since buying more licenses is not an option for us right now. 🙁
Thank you!
-
Thank you Mike! I am relieved to hear that the user only uses one license if showing logged in 2. 🙂
-
Hi Paul,
We go through the PO or RO to receive. The issue occurs with both standard and custom barcode labels. Barcode printer is the default printer for our labels. We are using Zebra ZT220. Not too sure how to purge the temp files and restart the print spooler. It happens on all workstations with different users and different Network users. Component Control set a style that fixes the blank label on the PO side but then the RO side the label does not print. They just created a tracker.
-
Hi All,
We upgraded to 10.9.23 back in Jan. Ever since the upgrade our receiving time has increased drastically because Quantum is not printing out all the labels from a multi part PO. We have to continually go back in and either delete the receiver number or enter the po number in PO Module > Forms & Reports > Barcode Receiving Label. Deleting the receiver number allows us to do a few more PO’s without a problem but then stops when we leave the module. Has anyone else come across this issue? I have contacted CC and they set up printing styles. This does not seem to work either.
Thank you
-GG
-
Hi All,
This is sort of along the same lines… I cannot get the columns from my sql statement to appear in excel. I show I am connected and my sql statement is good but its not reading my command text when I change it. Any thoughts?
Thanks -GG
-
Thank you Henrik! I didn’t think about it that way. 🙂
-
Thank you Paul. I was hoping not to grab that key since I have multiple warehouse codes and stock lines that need to be updated. However, looks like the best way would be to grab it. Thank you again!
-GG
-
Hi Jake,
This is the code we use to show the consignment code on our labels.
begin
qc := TOracleDataset.Create(nil);
qc.SetSession;
qc.Sql.text :=’Select consignment_code from consignment_codes where CNC_AUTO_KEY IN (SELECT CNC_AUTO_KEY FROM STOCK WHERE stm_auto_key = ‘+PN[‘STM_AUTO_KEY’]+’)’;
qc.Open;
Text := qc.FieldByName[‘consignment_code’].AsString;
qc.Free;
end;
-
Hi Ian,
Thank you for your response. We do have it set up that the invoice needs to be posted before the core is returned. We just ran across two invoices where cost was taken out higher than the pricing on the exchange. One invoice took half the stockline cost and expensed it, the other did the full stockline cost. I still cannot figure out why it is doing this.
-GG
-
Hi Abigail,
Thank you for the response, I will test out the sql today and see if I can get any further in figuring this out. 🙂
-GG
-
Hi Pietro,
I would be interested in that report too, please.
Thank you
-GG
-
Hi Pam,
I thought that might have been the problem too but everything is checked in the companies for deferred receiver. There was only one instance where the PO header didn’t have the deferred receiver checked, that was because it was opened before we had the accounting module and the last item came in a year later.
I’m stumped…
-
Hi Abigail,
Were you able to create a report that connects the attributes list to the primary data? If so I would be very interested. :))
Thank you!
-
Thank you Andre. This script will come in handy for our accounting department.
Thank you Pam. I thought we were doing something wrong but seeing the issues that your company runs into it makes more sense now.
I appreciate the responses. =D
-GG
-
Thank you Abigail.
Sorry for the delayed response.
Do you know if Component Control might (in the future) have a feature added to delete the reserved stock line on a quote?
-
We just started exploring the attributes section for Companies, too. I noticed that I can only view 8 fields per column. Is this normal? It also has a mind of its own when I add additional columns. Any insight is greatly appreciated.
Thank you,
-GG 🙂
-
Hello All,
I am curious..
Is there a way to expense the cost of the piece part if it is already in stock and reserved to the RO? I haven’t found a way to do this yet except to adjust the cost on the stock line and/or using vendor quote wizard. I run into this issue mainly when we need all cost to be expensed and by not issuing it to the RO the piece part just sits in stock as reserved (unless I missed something).
Thank you!!
-GG 🙂
-
I never knew about the marketing blasts!
Very handy tool, finally had a chance to play with it. 🙂
How did you connect it to the Event Manager?
Thank you!!
-GG
-
I have still not found a way to export or save as .pbi option to the desktop.
-
Thank you Gary! I brought it up with our Sales dept. and they liked the change of the master P/N.
-
Yes, I can do that. Thank you again. I hope your move goes smoothly this week.
-
We have forms designer, how would we set it up where it adds a charge to the s/o?
-
Hi Mike,
Thank you for the response! I saw the execute stored procedures script in event manager. Is this the event you are referring to?
-
Thank you! That worked. 😊
-
Hey All
Sorry for the delayed response. It works!! Thank you so much!
What I ended up doing was in my qctl schema, grant select on ro_header to qctlhas.
Then I signed into qctlhas and ran
select aroh.ro_number, hwoo.si_number
from qctl.ro_header aroh join qctlhas.wo_operation hwoo on aroh.ro_number = hwoo.company_ref_number
Thank you again!
-
Thank you!
I tried to query across the schemas in oc runner and it states insufficient privileges. How do I change privileges? Or is this something I would need to reach out to Component Control for?
-
I did not see that functionality on the custom crystal report too. I have used the XSL on the custom sql event. I am hoping there is a way and I am just blind to seeing it…