tonyr
Forum Replies Created
-
Hi Susan,
Attached are my steps with screen shots. I hope this helps!
-
I think you can do it in SQL pretty easily. Someone correct me if I’m wrong here. To get a 5% increase this should do it.
update parts_master set list_price = (list_price*1.05)
-
We have had several issues (on both sides). I know CC is trying to man this system, but I don’t know if they have an EDI guru on staff anymore since Cole left years ago. I think the system needs a bit of an overhaul. Not related to your issue specifically, but would be nice to see they system be able to shipping acks via EDI automatically! Good luck and keep us posted with what CC comes back with.
-
So will there be workshops again like the last few years the day before? The SQL workshops, etc were pretty helpful. Just trying to make plans. Thanks!
-
Tim – is this the new Que Group conference now? I’m assuming these summits are replacing the old format? Thanks!
-
Nevermind – found the option under the Member Only drop down. 🙂
-
Thank you Warren for the help as well. I’ll look into that as soon as I can!
-
Hey Tim – thanks for getting back to me and taking time out your schedule for this! Appreciate the suggestions for sure! So I took a look at all of what you said and ran the SQL statement. The issue is that the SO detail line is never deleted, it’s only the stock reserved to that SO detail that is deleted. Unfortunately, the version we have does not track that (who added the stock or deleted the stock) – only what happens to the main detail item itself. I’m not sure if a newer version does or not. I looked around at some settings and saw a promising option in the SO setup window where there is a box you can check that says “Lock SO Detail on Created Shipping”. I tried that out in our test environment and it didn’t seem to do anything. There is no reference to it in the help file so I’m not sure what it really does. I’ll keep plugging away on my end – I appreciate your help for sure!
-
Hey Tim – 10.10.32 . Appreciate the help!
-
Hey Warren – yep – that was it. I didn’t even think about it since when we did this whole project in the beginning I had to combine everything into one contact. AR doesn’t remember adding another contact for this. At least now they know where to look going forward if it happens again. Thanks so much for your help!
-
I felt like this was discussed somewhere before, but can’t find it in the search. We want to have a default term for the Customer, and another for Vendor when adding a new company. Currently it seems that the record default populates both fields in the company header. Was there a way to do it, and I just forgot? Or am I just crazy? 🙂
-
I second the Company Approval event. We use it here. We have 3 events. One that notifies us 60 days out so we can get the process moving, then another reminder at 30 and finally at 0 days it locks the company. There was supposed to be a way to have event manager send out a vendor survey to the company automatically as well but we always had issues with it.
-
Andrew – I’m sorry I never replied – had some issues with our test DB. But all is fixed and this looks like it’ll do exactly what I need. Thank you for the help!
Edit – While it does work – if you don’t completely closed out of the parts master screen the value will never change. If you are in a part and select find to go to another part it will not change. If you go to parts drop down and search master parts it’ll update.
-
Thanks Mike! We’re not to 10.11 yet unfortunately, but I’ll keep this in mind for our future upgrade whenever that happens.
-
Thanks guys – will look into this more when I have some time. Hopefully this helps anyone else who might have this same problem!
-
Hey Jake – no even copying your script in directly still shows the same error. I’m doing this all in interactive SQL within Quantum. If I change that to 2018 works again. It’s weird, ONLY 2018 works. Funny thing, even though while 2018 worked, if I try to drag the scroll slider down in results window the the error will pop up.
If I run this in SQL developer it will run with a different date, but then will throw the ORA-01427 if I try to scroll there also. If I load the script into a Crystal report I also get the error just clicking OK after pasting the script.
We have 2 companies in our DB – maybe that’s screwing something up here?
-
Hi Jason,
That report looks interesting. I’m not sure if it was something wrong on my end but if I change the date from 2018 to anything else it gives me an ORA-01427: single-row subquery returns more than one row. Runs fine if it’s still 2018. Thought that was odd.
-
Thanks Andrew,
I was thinking something along that line – but once I get that in using the control+F8 method I’m assuming, I do I add the field to the screen? That’s the piece of the puzzle I’m missing for sure. Thank you for the help so far though I appreciate it greatly!
-
Sorry to resurrect this thread again! I’m trying to add a new field to the parts_master header screen. I want to add the class_flag from the class flags table. We’re going to use this as the drawing revision for the parts we make to make it easier to identify this when working with vendors, etc. This field is not in my selection when try to add. Is there a way to add code to pull it?
Thanks!
Tony
-
Hey Mike – I had also tried that before and it hadn’t worked, but when I repasted everything and cleaned it up, boom worked. I must have missed something… grrrr. Thank you so much for helping!
-
Hi Mike,
Thanks! I did try that already and it was a no go. Normally, group by doesn’t include any calculated fields though if I remember correct. Thanks though!
-
Check the warnings on the company and see if that shows checked as never for allow customer quotes. In the company module go to Global -> Set Warnings and Messages and see if the top warning is set to Never.
-
Cyndy,
I’m sure you have already seen these, but if not, maybe these will help.
https://www.youtube.com/playlist?list=PLtD5MK_tZ9xwGRf6sKSmF82W8yL8Oqt-K
-
Very strange that the control number and ID would be in the stock history window, but not the stock summary window. There does seem to be several empty fields you could apply John’s idea to for sure. Assuming you’re not already using all the UDF, etc fields.
-
Thanks Mike – I have grown to love the in statement for sure – very useful!
-
Hey Jake – yep – did that query already. I have the parts and their PNM_AUTO_KEYS based on the date entered and mfg code I used. There’s a group of them all pretty much sequential order. No stock was added. I’ll give it a whirl in Test tomorrow probably.
Thanks and hope all is well!
-
Brandon – I just forwarded you the email Jason sent to me.
-
The WO_BOM table has a field called LOT_REQ_INSPECTION. Anything marked True is what requires inspection. You can link this to the WO_OPERATION table to pull out the lot number (SI_NUMBER). I haven’t written this in SQL yet because we haven’t used the require inspection option for a while when we receive in lot parts – but here is my old Access query I used if it helps.
SELECT QCTL_WO_BOM.LOT_REQ_INSPECTION, QCTL_VIEW_PARTS_MASTER_TONY_CUSTOM.PN, QCTL_VIEW_PARTS_MASTER_TONY_CUSTOM.DESCRIPTION, QCTL_WO_BOM.QTY_NEEDED, QCTL_WO_BOM.WOO_AUTO_KEY, QCTL_CONSIGNMENT_CODES.CONSIGNMENT_CODE, QCTL_VIEW_WO_OPERATION_CUSTOM.SI_NUMBER
FROM ((QCTL_WO_BOM LEFT JOIN QCTL_VIEW_PARTS_MASTER_TONY_CUSTOM ON QCTL_WO_BOM.PNM_AUTO_KEY = QCTL_VIEW_PARTS_MASTER_TONY_CUSTOM.PNM_AUTO_KEY) INNER JOIN QCTL_CONSIGNMENT_CODES ON QCTL_WO_BOM.CNC_AUTO_KEY = QCTL_CONSIGNMENT_CODES.CNC_AUTO_KEY) LEFT JOIN QCTL_VIEW_WO_OPERATION_CUSTOM ON QCTL_WO_BOM.WOO_AUTO_KEY = QCTL_VIEW_WO_OPERATION_CUSTOM.WOO_AUTO_KEY
WHERE (((QCTL_WO_BOM.LOT_REQ_INSPECTION)=”T”));
-
Thanks Mike. I might have to look at the workspace. The shortcut is the same for either schema I’m logging into. Quantum just knows somehow based on the schema (test or live) what icon to use. I was hoping to find the way to use that for our other live schema. I’ll try the workspace or just keep poking around. Thanks!
-
Hey Pietro – right, but how can I have it specify a different gear.ico for a different schema?
-
Thanks Fabiola! That’s what I feared I would have to do do. I was just hoping for less work. Thanks again for the response!
-
Thanks Pietro – figured it wasn’t possible – but would be a nice addition someday maybe. Hope all is well out there!
-
Hi Vanessa,
This may or may not help. My warehouse manager wanted a report to see the quantity that each clerk brought in for a week for a specific lot we had. The report attached should get you started at least. You can adjust the time frame and select a specific consignment code, remove the group by names, etc.
You’ll have to change the extension back to rpt because the system wouldn’t let me upload an rpt file for some reason.
Hope it helps!
-
Also interested in this. We’ve considered using the dashboard module and having a screen setup (McDonald’s method). Our company also wants a hard copy that we’ve tossed the idea of using a dedicated stock printer which helps them remember it when picking.
-
Would love to see an option for this as well. When we scrap items we put them on hold with the scrap radio button checked – but it still shows in the stock qty totals window. Would be nice to have an option similar to the Rolodex where it operates like a historical record. Have a check box where those parts can be searched for when needed., but no longer shows up in a regular search.
-
Hi John – don’t know how I missed this. Are you referring to a form (in forms designer) or a screen? I’m looking for doing this on the parts master edit screen in screen scripter.
Thanks! Tony
-
Thanks Jesse! This is a good example of what makes this group so useful!
-
Hi Brandon – you’ll have to link the ro_detail table to the stock_reservations table and then to the stock table. That should get you to where you need to be if I’m thinking straight this morning. You link the rod_auto_key to the stock_reservations table and then the stm_auto_key to the stock table.
I hope this helps.
-
I was just working on this same report yesterday. Link the cmp_auto_key to the image_list.source_pk then same as Mike.
-
Thanks Sally! Saw the other post too. Hope this all helps! Have a good day!
-
Would be nice to have the current integration work correctly – or at least for them to have communication with Aero. We’ve had this for a few years and it’s never worked correctly. Not necessarily CCs fault most of the time. For Example – FedEx requires the warranty fields to be completed on quotes – but those fields aren’t part of the EDI file. This makes no sense why Aero would have fields on their site that can’t be populated through the EDI file. CC told us once they can map a field on their end – but there’s nothing to map it to that Aero can import. Also annoying that you can only have one part per order. When you’re selling a part that has a quantity where some are in a lot, and some not you have two lines now on the order and can no longer use the automation for the EDI Aero integration now.
Not to steal your thread and gripe – it’s just been frustrating with this integration and since Cole left it’s been harder to get someone who has a good handle on this.
-
That would sound like a great thing to have happen – but how would the system know where an empty location is and whether the item could physically fit there? If all your products are relatively the same size and the same quantity can fit per location maybe there would be a way the system could identify a location that way. Location A can hold 10 units and has 8 allocated to that location so it would assign the next receive in unit to location A. Not sure at all how to do that behind the scenes though…
-
Hi Mike – not sure if it helps, but if I go to the history button in a stock line window and go to the Print custom Crystal report it takes me to the Crystal Report Manager window where I can select whichever report I need. We’re on 10.9.26 though.
-
I know Quantum used to push Geo Codes a lot. Maybe you can put all your raw material part numbers into a specific Geo Code (or even consignment?) and use that as the restriction – to only allow that geo code to be entered for that company. You might need to write a little script to make it work if you have screen scripter. Not sure if you can do that in screen designer.
Just a thought – I’d have to play with it more to see how that would work.
Tony
-
Sorry to bring up an old thread…
If I have an attribute set up as a memo – how do I pull what’s in that memo field?
-
Great to see you back Andre! Missed ya at the last conference.
-
Hey Jason – sorry to dig up a really old thread, but if you still have this DIA script I’d love a copy!
-
Hi Kevin,
Thanks for the help. We do have screen scriptor – is that what you used? I couldn’t figure out the script to set it on open or on button click.
-
Thanks Jake,
But will they be doing this Wednesday during the day, or just break outs from the conference? Trying to figure out flights as we’re pretty close to the conference already. Thanks!
-
Thanks Tim! We’re due to get a test system setup to run 12 for a while. When we get that setup I’ll run this and see if it works out. Appreciate all the effort!