john.schneider
Forum Replies Created
-
I am guessing the earliest would be a 12.X.X version.
Maybe a few users maybe allowed to access the function to properly test it.
The suggestion has been that for this, a registry entry can be set on the local machine to enable or disable the feature. That would allow controlled testing.
When I hear more will update.
-
Had a demo on this today in development.
Test went well and we will spend some time on this feature this week.
-
This has been discussed at CC with developers last year and to their credit a proof of concept has been done for this.
There maybe some news on this in the future… but keep in mind it would be a 12.X + release and late next year if it does reach production.
-
The built in Quantum feature should be ok for this?
User / System Setup / Security / View User Security Profiles
You can view and export to excel as required.
-
I have seen the issue in x64 – would need to check the x86.
As soon as the update was applied none of the workstations with that new version could email out of Quantum.
It comes up with some sort of component licensing issue – exact message I will need to find and provide.
Rollback fixes issue.
Now waiting for CC to investigate further and advise.
I am hoping it is not Microsoft attempting to get us to move up a tier on 365 by removing a component and saying we need the more expensive version….
-
I’m not sure much is standard, it very often relies on customers coming up with the idea and paying for the programming … 🙂
The issue now with this feature, is it takes one or two days to add the feature to the module, then 3 times longer intergating that change into related modules, so it becomes very expensive to do.
-
We asked for a CP quote for this feature to be added about a month ago.
Unfortunately it was quoted at approximately $20k.
Which puts it beyond out budget for the requirement.
So it is on the wish list … 🙂
-
John Schneider
Member05/08/2019 at 2:43 AM in reply to: ABILITY TO COPY ADDRESS FROM INVOICE TO COMPANYIf that is the free text on the Invoice header, I can’t see that being possible, as the address format is different.
I believe you can populate that free text address from the company site etc. but not the other way around.
From memory, those free text addresses throughout Quantum are from pre-Quantum days and required for compatability now.
We lock down all free text addresses in Quantum on header windows etc. and the user must select an existing company address/site etc., using the appropriate feature(s).
Is it just that you want to make sure the company sites etc. are updated when users create addresses for orders & invoices ?
If it is, then lock down free text entry and make them use company info…
But to answer you main question, I don’t believe it is possible due to address format differences, if I understood you question correctly …
-
Hmmm, I believe we paid for custom programming on this years ago – adding security and to do exactly what you are seeing here.
The reason was to create workflows for staff, so that they see what work is assigned to to them and then work on that – without the distraction of other ship orders etc. that are not for them to work on.
An improvement maybe to have a module setting/user setting to allow them to see the items but not to be open or assign them from that screen.
You could suggest this to CC and it could go into a wish list…
We could add to our CP, it does cause us the occasional problem, but not sure I can justify the approx $2000 for the amendment …. yet.
-
What is your server system memory size? What is the SGA/PGA size in Oracle set to? Is it Oracle 11g?
If you are running out of Oracle cache, Quantum performance will drop sharply in certain areas – can be very hit and miss, which is what I would expect with a cache issue.
As a guess you might want at least 100GB server memory with an SGA set to 40GB. I think we run at least 120GB with 52GB SGA set.
SGA/PGA sizes have been overlooked by Component Control in the past from what I have seen.
There are various different methods of setting memory, but the 2 installs done by CC for us were set manually – so increasing memory in server itself made no difference because these settings were overlooked/missed.
Over the years we have changed this a few times for similar issues and the SGA/GGA changes fixed odd performance issues immediately.
We are now on Oracle 12c and I don’t see the issues on there (so far !)
It might not be your issue, but worth mentioning for others too 🙂
-
Possibly login to create your views as Crystal – you will then be limited to schema Crystal.
You are missing out without crystal reports though, $495 to be able to get so much more reporting productivity and options …
-
We have not lost any custom views we created, on upgrades.
It would be worth checking with the person assigned to do your upgrade though.
-
Do you mean personal settings/views for each user?
We lost that on Firebird to Oracle database migration/upgrade.
Since that, all upgrades have kept the user settings, as far as I know.
-
It should not matter, if you can select the install directory, then the program should support it. Although that does depend on who programmed it and them keeping that in mind – especially in future releases.
I would also steer clear of the cheaper mini PC’s if possible.
Overall performance has always disappointed – unless they are being used for RDP – even then they still frustrating!
The Dell Optiplex Micro series is what we use everywhere in the company as a standard user PC. Of course they do cost a bit more but performance is outstanding in comparison. The small size makes them very versatile.
14cm sq vs 20cm sq – there is not a lot in it and there is just no comparison in performance. In 3 years the Minix will be in a bin and the Dell will still be in use… 😉
-
Our Citrix VMs use to run on 30GB as an entire machine – with office without any probems. Although higher now due to windows updates.
Quantum client can’t be much more than than 2GB with Oracle included.
Overall, the ongoing issue will be Windows OS and updates eating up disk space.
-
We use Citrix which just works 100% all the time.
I did have a play with remote desktop services a few months ago.
had the same issues but ran out of time.
Main thing I found with our Citrix, from memory, was that the BC module was quite fussy about COM ports and even when redirected it must be a particular port, was is COM2 – that is a guess.
Also, would just urge caution to anyone opening up site to site VPN link to general servers from end points – that is generally a security risk that you should not take unless it is managed very well. It might be in your case but it is worth mentioning in case anyone else reads that and just does that without considering the consequences.
Your network/firewall/VPN is only ever as secure as your worst end point…
-
Have not seen this exact issue but …
Quantum does not as a general rule have record locking, there are some exceptions.
A simple example would be Ship Orders, which we see all the time on various fields, if two staff have the same elements open, the last one to close writes over – even if that is the original data. This is the workstation caching you mentioned.
Luckily we can see it in the audit trail – because those actions are part of the audit trail on those screens.
However, if where those changes are being made in the code it is not part of an audit trail you won’t see why it changed, which is why we keep adding items on audit trail to CP.
Also any large updates to tables, we never do in normal working hours as it risks either locking up on record updates or doing what you just mentioned – messing up the data.
May not be directly related to what you see though.
-
We have a customer and an internal company web/app.
Focus has been on Customer app – they can browse inventory, create RFQs, place orders, request invoices and statements, browse their history, check their quality stats etc.
Then in the warehouse, receive, photos, relocate, process orders, dispatch.
Ultimately to replace the PCs and Barcodes guns used wherever possible.
To use a mobile app wherever possible as an alternative anywhere in Quantum.
-
Yes both mobile and web, a very open question though…
Provided the developer understands Oracle well, Quantum database design/coding, has access to a test database environment anything can be tried.
We use Xamarin for the mobile environment, which works very well.
Its a fairly big project though, I wouldn’t recommend any company going into production with their own app unless it is properly supported internally.
You also need to be careful with licensing, both with Oracle and with Quantum.
We also purchased the Quantum API license, although that hasn’t been quite as useful as we had hoped – for the money we paid and still pay for it.
-
You could try this as a test…
On the report you could create a formula field as your HTTP link:
‘http://’ + {IMAGE_SERVER.SERVER_IP} + ‘:85/Select?Key=’ + cstr({IMAGE_LIST.IMAGE_KEY},0,””)
I have added Server Port Manually as all of ours are the same, but you could use the SERVER_PORT if needed – this is just easier to read.
An example report:
SELECT “IMAGE_LIST”.”DATE_CREATED”, “IMAGE_LIST”.”FILE_NAME”, “IMAGE_LIST”.”SOURCE_TABLE”, “IMAGE_SERVER”.”SERVER_IP”, “IMAGE_LIST”.”FILE_EXT”, “IMAGE_LIST”.”IMAGE_KEY”, “IMAGE_LIST”.”SOURCE_PK”, “IMAGE_SERVER”.”SERVER_PORT”, “IMAGE_SERVER”.”SERVER_TYPE”
FROM “QCTL”.”IMAGE_LIST” “IMAGE_LIST” INNER JOIN “QCTL”.”IMAGE_SERVER” “IMAGE_SERVER” ON “IMAGE_LIST”.”IMS_AUTO_KEY”=”IMAGE_SERVER”.”IMS_AUTO_KEY”
WHERE (“IMAGE_LIST”.”DATE_CREATED”>=TO_DATE (’01-10-2018 00:00:00′, ‘DD-MM-YYYY HH24:MI:SS’) AND “IMAGE_LIST”.”DATE_CREATED”
ORDER BY “IMAGE_LIST”.”DATE_CREATED”Filter the results on SOURCE_TABLE as needed.
The added detail line formula field on the report, format as Hyperlink using the same formula field data.
There might be a method to bring back the filename with the extension – on the URL link to work with the browser. But I don’t know what that is …at the moment… so if anyone else knows that would be helpful 🙂
Pics and PDFs are fine – but .msg or other file formats, the browser can’t determine the how to open the file.
-
A programmer can automate the import of images into document and imaging in Quantum – fairly easy to do – into any part of Quantum.
Please note that is not the same as using an external document & imaging product to be your storage instead of Quantum Document and Imaging.
So it depends what you are trying to achieve.
If you are trying to ‘replace’ the Quantum document and imaging servers the answer is no. Unless you have $50k to pay for some CP.
Although I would steer away from that idea because it could in theory break at any time if the external product changes.
Everything above is custom though, so be aware of the potential consequences/costs of supporting that ‘ongoing’. So maybe easy to implement some things but also easy to get in to trouble at some point too…
-
Definitely a 10.10 build unless there is a specific reason not to.
We are on 10.10.5 which needed a bug fix. Which I assume is in 10.10.6.
-
VPNs will have an option to Keep Alive and you can set that to something that practically keeps its open.
You definitely do not want the VPN dropping by design.
Every VPN / firewall has different settings but they generally do refer to it as keep alive.
We use Citrix, so it is the serial connection to the base station that runs over the VPN – which is likely more tolerant of VPN dropping than running the BC program over it.
Whoever setup the VPN – just ask them to setup the VPN so it doesn’t drop the connection, that should fix it.
-
We don’t use the cloud product so its a guess, but the network error would indicate a network issue. Have you monitored the VPN connection to see if it is stable and not coneccting/disconnecting/connecting/disconnecting?
The module might have an issue with unstable connections.
Most RDP clients will tolerate a drop or lag, so you may not see the issue on terminals, but anything running directly, possibly isn’t coded as well.
This is assuming this cloud setup gets you to run the BC module from a local PC across a VPN. Would be interested to know how CC have designed this. Do you run the BC module locally?
-
We are doing an EDI to Direct ship from Quantum to Fedex API/Cloud services. UPS is next on the list …
Ship addresses/ Sites and formats was an issue.
We had Konstantin here at the time so he showed us the logic and code used. Field mappings can be an issue otherwise.
We lock down the ability to manually type in Ship To Address and force users to select sites at all times.
That may not help you much – but please contact james.verdon@avtrade.com and he may be able to help if it is something we fixed for our Fedex – which I suspect it would be.
-
We don’t use it here, but I know someone that has had to roll back to Windows 10 1703 for MSTSC, for RemoteApp hidden window issues for other programs, on all their Windows 10 machines/clients.
-
For a Replica Test environment restore:
1. Domain controller
2. Oracle server/Quantum installed
3. Workstation
4. Imaging servers (any large(ish) install keep imaging seperate as much faster DR)
Once restored fix any VM issues with regards to networking and get them up and running – keep all the same network settings on the VMs.
Do NOT allow the Oracle server to have internet access – remove or put in an incorrect Gateway
You do not want your test server communicating with anything other than your test environment – Do not miss this.
In general – be careful with any RDP apps on any restored VM’s if they are cloud managed as you will be duplicating connections to the internet.
We uninstall any RDP/monitoring apps before allowing internet access.
Event Manager can usually be disabled – although if you have made sure you don’t have internet connectivity on the Quantum Server it doesn’t really matter.
It will build up failed events, e.g. emails – but short term that is not a problem.
You do ideally need internet access on at least one VM so that CC can login and do your upgrade easily. I.e. RDP from Workstation to Oracle server.
We have a separate internet connection /firewall for our test environment.
You should really have all this in place and tested as part of your Disaster Recovery plans anyway.
With that in mind write down what you plan to do – follow the list.
Make notes on anything that didnt work as intended and what improvements are needed for the next time.
As a guide our Quantum server restores in around 30 minutes / 700GB – this will vary alot depending on your setup.
Plan everything before you start and make sure you keep your test environment separate from your production at all times.
Thats about it for general overview … we do this at least once a month so we know our DR works, even if we don’t need it for a Quantum test upgrade.
Network services likely won’t provide support directly – that assumes responsibility – they will just want to be re-assured your Replica/Test environment is not your production one, everything is separated production/test and that your Quantum server is not connected directly to the internet.
-
Installed and working,
You would not believe how many staff have complained they can’t see the CM’s in Company Management – which they clearly did not have the established right to see anyway…
-
I believe that is how it works. It is only related / filtered to the user ID being used.
If there are contacts, but the user is not a member of any of those contact masters, then that is when they don’t see the hands/icon.
They will always be able to see the contacts they have specific rights to and hence the contact icon in company management.
-
I only noticed this post today, agree with you this is a security issue.
I have Konstantin with us for 2 weeks, I have just had him fix this issue.
Will be available in 10.10.X + upgrades from next week.
Please note: as security is now applied, if a user does not have any security for ANY contact masters, they will not see the Contact symbol – so won’t know if there are any at all, in the Company Management.
I believe this addresses the issue for you all, of course this only fixes it for 10.10.X + from next week and not previous versions. That may be an issue for you on earlier versions …
Konstantin will have updated the Tracker you provided so if you do need to get fix for earlier versions, I suggest you use the same tracker reference.
It only took a few minutes to fix, or was it 5 + years …
-
We only use the more expensive Thermal Transfer – options GX420 etc.
My guess is that your print speed maybe too high – which you can adjust on the printer settings.
The speed maybe so high the print head is not heating sufficiently.
Quality of labels could make this worse of course.
Regardless of Thermal Transfer or Direct Thermal – if your print speed or density settings are not quite right – your print quality will suffer.
If you have 5 of them – you won’t have 5 faulty printers.
The good thing about the Zebra printers is that they are very configurable – that bad side of that is that if the setting is not right you will get fading, bleed on the print or labels that appear to be blank sometimes.
-
John Schneider
Member03/28/2018 at 12:38 AM in reply to: A QUICK WAY TO ADD IN MULTIPLE STOCK TO A REPAIR ORDERFYI… Sales Order Import function does have have the ability to attach STOCK_LINE via Import file. Older versions of Quantum may not have this. I added that last year.
Other than than it is that manual import process. We have a rule here which is anything less than 100 then its a manual process…
The scripts/planning/testing/risk vs. just manually doing it with a nice cup of coffee …
-
Seems to be quick – the main reason for using PDF Reader.
Will definitely consider it.
-
John Schneider
Member03/01/2018 at 1:54 PM in reply to: AUTOMATING ADDING NEW USERS AND DISABLE LEAVERSThanks James will try that and confirm if that works for us.
-
The official CC answer is :
Adobe Reader DC should be compatible with Quantum, the only issue that we found is with workstations that have Windows 10. To fix any issues with the default PDF viewer in any windows environment there is a new setting that will open the PDF document outside of quantum.
The advantage of this feature is that you can open multiple documents at the same time and in quantum just one at a time.
You can find the setting in the global settings for quantum
User> System setup> Global settings> Document images tab> Flag “Display PDF in External Application is available.
Sounds like there are a few options, but the use of the word ‘should’, should concern you…
If there are issues with Windows 10 then I would say it is not fixed…
The workaround is passing the image outside of Quantum to be opened. That should in theory prevent the error on the builtin viewer.
-
John Schneider
Member02/17/2018 at 2:18 PM in reply to: SHIPPING STATUS – FINAL ACTION – POST INVOICEWe used it for many years . Stopped using it at some point, so that we could control posting of invoices, i.e do it at the end of the day after midnight for the previous day and email all invoices directly at the same time, using event manager.
This change was for operational reasons, to provide time to check the invoicing was correct.
Posting the invoice is so final, due to the occasional problem, it made sense to add a delay and automate the posting to later on.
So we achieve the automation, but allow some time for mistakes/amendments to be made.
Some customers simply will not accept a second invoice for a mistake in AOG freight/done in a rush etc. For that reason I believe we don’t post invoices on a weekend, it is left for Monday to make sure the day teams can double check the weekend shipments for errors or to account for additional AOG charges, which often are not fully known at the point of dispatch anyway.
The function in itself worked fine for years, it just became a problem for us occasionally $$$$$, so now is not used…
-
John Schneider
Member02/16/2018 at 1:32 AM in reply to: PURCHASE PART NUMBER AND THEN REASSIGN TO ANOTHER PART NUMBERWhy would you not just delete the line and add the correct part number? Is this before, during or after the receive process?
-
I think this will be programming one way or another.
To say it is hard to get CP time for 2018 is an understatement.
If it gets done I will post back whats been done and how it works
Thanks all!
-
Normally yes that is correct.
However, due to significant cost savings, we also arrange collections ( when appropriate) for items being returned to us, SO Cores, Repair Orders and Purchase Orders.
A good PO example would be a Teardown where we might be shipping in on our PO over 1,500 items. That needs to be tracked in the workflow within Quantum for us.
We might have a contract agreement with certain customers to collect their cores for an exchange.
There are lots of examples, currently done outside of Quantum, in our day to day business.
I realize it is not something everyone does. But doing all that outside Quantum and just using notes in Quantum is not efficient for us.
-
I suspect the feature does not exist – I was wondering how anyone else does do it, inside the system.
As soon as you create the shipping on an RO item as an example, the line item is no longer available. It is out of the system.
I haven’t seen an option on the Receiver to create shipping on an RO item to bring it back in later. Then allowing it to show the Ship Order in Shipment screen / manage it etc.
For a PO item, Global , Create shipping but have it easily identify it is incoming – not being sent to the Vendor. I can’t see that is easily done?
I discussed it with Konstantin and he suggested some CP to get this done. Possibly an enhancement on Warehouse Transfers. But this is not simple for CP. Anything linked to receiving items is expensive as it means we have to fix all the quick receivers as well as anything else. So it is 10x the work (cost!). It is a minefield for programming …
We can do this fairly easily outside Quantum on our web system and link it in, but before I embark on doing that in the next month, I just wondered what others do to achieve this? ( especially if it is in Quantum and I cannot see it… )
-
10.10 has an improved Sales Order import feature
This allows you to specify on the import which stock lines you wish to attach to each line of import.
The import feature above was added for some staff to be able to manipulate stock (to be scrapped) on spreadsheets, then just create a Sales order with maybe 500 lines and all the stock allocated on the import in one go.
We use API’s to achieve full automation. I suspect the API for Sales Orders had the feature added to allocate stock to an SO – if it did not already have it.
I am not sure I have been much help though as I suspect you want Quantum to do it for you? I am not sure where you are getting web orders from for example? how you process them now etc.
Component Control support should be able to advise if the function is in Quantum for you to use now.
-
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.
-
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.
-
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.
-
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.
-
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)
-
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).