0 Archived
Forum Replies Created
-
Yes. If you have the security to do this…
User -> System Setup -> Maintain System Tables -> Shipping Management Browses -> Shipping Status
For each status you can click Users and specifiy who has access to each status.
-
If I manually add an entry, when I go open that record in the module they do have a links which shows it. Just seems like a lot of work to pregenerate specific links for specific records in the modules?
-
Sad tos ay it sounds like an enhancement request to Component Control.
I would think one could write a translator to take what Qauntum generates and create the correct file. We do ACH via US banks here, no real access to a bank with those requirements.
Would be a fun project if you would like to have a section on our website to do this until CC releases an update that incorporates these requirements.
numeral.io
SEPA Messages: a Complete XML Format and ISO 20022 Guide
What kind of SEPA messages exists? What are their syntax and format? How ISO 20022 sets the standards of messages used by SEPA direct and indirect participants?
-
If you are on an older Quantum like V10, their email sender doesn’t support current security protocals Microsoft requires for O365 STMP. Componet Control will need to update it for you.
-
In Office 365 we have MFA turned on, so for the user account you want to send mail from we added an application password (that doesn’t require MFA)
On the system that is running your event manager. Go into the Task Scheduler and look at the QuantumEMGRMailer task. My is running e:\emgr\mail\emgrmailv2.bat
In e:\emgr\mail there is an smtp.properties file, update it like so:
# Sample ResourceBundle properties file
#Smtp Server
mail.user=testing365@northbayaviation.com
mail.password=application password generated above
mail.from=testing365@northbayaviation.com
mail.to=testing365@northbayaviation.com
mail.replyTo=testing365@northbayaviation.com
mail.subject=Quantum Control Event Manager
mail.smtp.host=smtp.office365.com
mail.smtp.port=587
mail.smtp.starttls.enable=true
mail.smtp.auth=true
db.host=<your oracle db IP here>
db.port=1521
db.user=qctl
db.password=quantum password here
db.sid=CCTL
-
Perhaps WindowManager is an alternate way. https://www.desksoft.com/WindowManager.htm
urldefense.proofpoint.com
DeskSoft - WindowManager - Window position and size manager
DeskSoft - WindowManager - Window position and size manager
-
Not sure about the report, SQL something like:
SELECT STM.PNM_AUTO_KEY, STM.PN, STM.DESCRIPTION, STM.SERIAL_NUMBER, STM.STOCK_LINE, POH.PO_NUMBER, POD.EXCHANGE_RATE, POD.RECEIVED_EXCHANGE_RATE
FROM STOCK STM
INNER JOIN PO_DETAIL POD ON POD.POD_AUTO_KEY = STM.POD_AUTO_KEY
INNER JOIN PO_HEADER POH ON POH.POH_AUTO_KEY = POD.POH_AUTO_KEY
WHERE STM.PN = ’11-5589′ AND STM.STOCK_LINE = 1.0
-
Is there any different between an RFID and a barcode scanner?
looks like the reader just acts as a HID (keyboard) and would feed the PC just like a barcode scanner.
you would still have to read the squawk barcode with a barcode scanner?
this seems really interesting
-
For those AR PENDING is their associated GL Batch not posted?
-
Looking at the screen AR Balance is CURRENT_BALANCE and MAX_CREDIT would be the AR Credit Limit
-
You may need to reference the view: VIEW_SPR_AR_AGING
-
Have you tried to setup a price line with a 100% discount? That way on the PO you would set price line to that (by part) and it would know you want a $0 price?
-
Ah! They are there… as CM Change Alert and CM Reminder under Custom instead of Contact Manager. Thanks, I didn’t see them.
-
We are on Quantum 10 (if that matters). I only see one Contact Manager Report in the Library. I do see a Project Audit Log Export Email alert.
I do see a Custom SQL STatement and Template, don’t see any documentation in the help file or CCI’s zend desk about how to use that feature.
-
I didn’t see anyway to do this currently, but it’s perfect timing to build this into a feature request.
Color set by:
Unassign Customer
Unassigned Vendor
Assigned Customer
Assigned VendorAssign color based on discount code? Or raw adjustment ased on discount?
Or totally overthinking how this could work? We are looking into using price lines in the future and I can see where it would be very helpful to identify the rows based on colors.
-
For me the grid portion is super small, and I get an OLE error 800A03EC with “One of the fields or rows is mapped to an invalid reference. Please go to the Mapping meun, delete mapping and map fieds again. Or go to Inser menu, names, define and delete the entery with invalid refrence.
-
On the RDP Server, opening Excel that DPI setting is greyed out. Not sure how to work around that.
-
If you use ENTER that cancels the search (it doesn’t say that but that is what the result is). If you search form the main forum search you may need to click view all to see forum results.
Not idea for sure. Will see what search options are. Thanks for bringing this to our attention.
-
Thanks for the feedback and checklist. We have been on Quantum for 7 years, and every upgrade (even small) as you say requires months to iron out the ‘enhancements’ to make our lives better. We froze on 10 but it seems time to make the leap.
Thank you Jason and Jae.
-
Assuming you are on a recent OS, GoDaddy and others have tutorials on doing this.
https://www.godaddy.com/help/manually-install-an-ssl-certificate-on-my-iis-10-server-27349
-
When doing the sql to update the list_price in parts_master do you also update the LIST_PRICE_DATE field? Or not really?
-
There are a number of issues with the SQL, not all tables/views are joined, some no doubt have duplicate information so some data if summarized later will be over stated.
When I do complex reports like this I start with the core (GL side) so that the totals match a Quantum report, then as I add things like the WO_OPERATION or other transactional files I can very it didn’t impact the GL totals.
Adding in the various views drastically slows down the SQL as they typically include data overload that is not required.
I would recommend you take a couple of steps back and build it up.
-
If you don’t have SMA with CC for sure that’ll work.
-
Some emails go through some cannot connect. O365 phased out less secure SSL protocols and when the mailer tries to connect it gets refused.
Contact Component Control and get your jar files updated to the sender that supports current protocols and all emails will go through.
-
I did try that and it controls the main quantum window but not any windows Quantum opens. Some windows Quantum opens, it opens in the exact same place every time, others it doesn’t.
Guess that would be a feature requiest and be unavailable via Quantum for users not on the latest version.
urldefense.proofpoint.com
DeskSoft - WindowManager - Window position and size manager
DeskSoft - WindowManager - Window position and size manager
-
This was a server issue and when it happened Quantum did crash everywhere as Oracle was offline.
Individual workstations randomly, when it happens you can check the TNS Listener Alert log for entries (should have workstations IP) that could lead you to too many processes/sessions/threads running on Oracle for it to respond. Are they all on the same network switch (maybe the switch is the cause – I’ve had that happen a few times over the years). DHCP server conflict – I’ve had that take out random workstations.
Very interesting topic.
-
For me I just need a computer to run, the Microsoft signed drivers for this install (3 servers running Windows 2019 Server) clearly killed them. I guess your milage will vary… LOL
-
Just a bad driver. I din’t install the Intel driver but used what Windows itself installed. So far no non-paged entires are there in the poolman utility. Smooth sailing today, should be able to confirm tomorrow that we survived more than 73 hours of up time
-
Task Manager was not all that helpful but you can see Non-Paged Pool was higher pre-reboot.
-
I think you nailed it. I switched to the other NIC manufacturer.
In Pool Monitor there was Irp in non-paged eating up 98 GB and Mdl taking up a little more pre-reboot. now neither of those tags are shown.
-
There seeems to be 2 thoughts on this:
Bad NIC / Driver
Desktop Application HeapWill use the other NIC after reboot today @ 3 to see if the issue goes away.
-
Thanks for the ideas!
-
Here’s a breakdown of what I think could work, hopefully someone has done this that can confirm:
Looks like badges are ~ $3.50 each + setup for your layout (logo) ($49)
https://www.atlasrfidstore.com/search-results-page?q=badgesSoftware to program them $250
https://www.atlasrfidstore.com/vulcan-rfid-uhf-tag-read-write-software/
Reader (USB) ~ $250 each
https://www.atlasrfidstore.com/rf-ideas-wave-id-plus-mini-keystroke-lf-hf-rfid-reader/ -
It looks like you would configure the badge to output the employee ID. So it would be more secure as you say you couldn’t easily just photo copy it. Just have to lock down the configuration tool.
Buddy punches are just a bad practice but it does happen no doubt.
-
grant select on user_a to user_b -
You can do: GRANT SELECT ON R1.OWNER.SYS_USER_DB_SESSION TO R3
-
If you have the consolidate checked, does it just put multiples in the subjet line?
-
Gotcha, based on Stack Exchange
It looks like you could delete it and recreate it, add in the goDaddy cert, and your cert.
-
Ah, I see. For us we use goDaddy and have the intermediate key, looking at Tomcat it uses the keytool. Did you do the list command to verify everything is correct?
keytool -list -keystore domain.jks
-
Are you using Apache? If so does the enabled site conf have the host name you are using? Does DNS have an entry for that exact host name that points to the correct IP?
-
Do you have shell access to the system (SSH)?
-
Were you able to resolve this? Do you have SSH access to the linux box? Shouldn’t be too difficult assuming Apache or Nginx is the front services listinging to the port?
-
Do you mean like a custom event in event manager that would look for ro_detail records and grab the unit cost from the price line if it exists?
-
Yes, we are on an older windows version. main thing is to get DNS to resolve to the correct IP so that the SSL cert can be validated.
-
What I did (I don’t have a public IP Address) but I self hosted the DNS for the domain name the SSL certificate is going to be applied to. So there is the public DNS servers that the outside world uses, and my internal DNS server that folks inside the company access. The only real difference is the portal’s name is there pointing to it’s IP.
It’s been a few years and so far so good with this extra setup work.
-
So in the Edit Site Binding you set the host name to your FQDN?
-
No problem, and I assume you already looked at: https://quegroup.org/forms-designer/
-
I referenced: https://www.digital-metaphors.com/download/documentation/#LearningReportBuilder
And just looked at the other forms to see where I have to go when I need data that is outside the current data in the form.
-
Hi James,
Was there any details for the error? Looking at TI_PO_HEADER is the company you are trying to create the PO for ALLOW_PO in the companies table allowed to have PO’s?
-
Ah! Screen scaling is an issue for us as we have started to transition to 4K larger monitors and set it to 150% or higher…. depending on user requirements. I think I’m stuck with the restarting Quantum to resolve it for me.