[Henrik Ekenberg]

Hi Lydia,

I think I figured it out. I guess that the “Edit”-button is not visible for the user in question right?

If so, what you need to do is to grant the user permission to [Quantum ControlReport Print Settings], that should do the trick.

Best regards,

Henrik

[Henrik Ekenberg]

Hello Lydia,

When you say “Invoice Settings” what exactly do you mean?

Is it the Invoice Header or is it the Global Invoice Settings reached via the menu ‘UserSystem SetupInvoice’?

If it is the the first, make sure you grant the user permission to [Quantum ControlInvoice ManagementGlobalEdit Invoice Header].

If it is the latter, you need to grant the user permission to [Quantum ControlUser SettingsSettings System].

Bear in mind that this gives the user access to change the Invoice Settings (and others e.g. Company Module Settings) for the whole company, so be careful.

If this isn’t what you mean, please elaborate.

I hope this helps.

Best regards,

Henrik

[Henrik Ekenberg]

Paul,

While my statement actually work in my system, I can see that your statement is much more usable as it does not matter how the system is set up, you can specify exactly how you are used to format dates.

Thank you for sharing.

Regards,

Henrik

[Henrik Ekenberg]

Hi Courtney,

As I am situated in Europe, the date syntax might be different from yours but this statement works in my setup:

SELECT SHIP_NAME, SHIP_DATE FROM SM_HEADER WHERE SHIP_DATE > ’31-DEC-2013′ ORDER BY SHIP_DATE

I added the SHIP_DATE and also sorted the list by the date, that way you can quickly verify if the result is correct.

Best regards,

Henrik

[Henrik Ekenberg]

Hello Dave,

The Audit Trail table is a little different that most of the tables in QC. You need to use the field SOURCE_AK as this is the connection between the audit trail and any table that is audited.

In your case you’d want to start with the COMPANIES table and link CMP_AUTO_KEY to SOURCE_AK in the AUDIT_TRAIL table. Then link SYSUR_AUTO_KEY from AUDIT_TRAIL to SYS_UR_AUTO_KEY in SYS_USERS all links should be ‘Left Outer Join’. Now you have the connections needed to show the audit trail for the COMPANIES table.

In order to limit the data collected, you might want to set a selection criteria.

To get a list of all changes to credit limits for all companies insert the following into the Record Select Expert:

{AUDIT_TRAIL.SOURCE_FIELD} in [“CREDIT_LIMIT”, “MAX_CREDIT”]

It’s all about finding out what QC writes in the SOURCE_FIELD, then filtering it out is easy.

We do not have the lot module here, but I believe above method can be used for that as well, with some modifications to the tables and links.

Try it out, and feel free to contact me if you run into difficulties.

Best regards,

Henrik

[Henrik Ekenberg]

Andrew Sheldon wrote:

We have developed a number of stored procedures and packages in Oracle and use SQL Developer to schedule them instead of using event manager. I find there are more options available. In the past we have had a number of failed jobs using event manager as it doesnt force a retry. Scheduling via SQL Developer gives you more options on when you want the job to run and also allows you to specify the number of retries if it fails the first time. Now we have no failed jobs. I have a crystal report that runs every day that shows any failed oracle jobs i can send you a copy if your interested?

Andrew,

I would like a copy of that report… pretty please.

Best regards,

Henrik

[Henrik Ekenberg]

Cameron Price wrote: One thing to be aware of is storing your stored procs inside of the qctl schema is a big nono. On upgrade or applying to your test db etc, these will all be wiped out.

Cameron,

I have not worked with stored procedures yet so forgive me if I’m being ignorant.

You say that the stored procedures will get wiped when upgrading, but since the stored procedures start with “CREATE or REPLACE” wouldn’t it just get created automatically next time the event runs?

Regards,

Henrik Ekenberg

[Henrik Ekenberg]

Hi Anthony,

I don’t know why it is the System32 folder that is being archived, but

the reason why it does not work is you miss one important parameter in your command. You only state what the name of the compressed file should be, you do not specify what you actually want to compress.

Your commandline should look something like this:

%ZIP_BACKUP_FOLDER%7za.exe a -t7z %SECOND_BACKUP_FOLDER%%ARCHIVE_FILE_NAME%.7z %SECOND_BACKUP_FOLDER%%ARCHIVE_FILE_NAME%.dmp -mx9

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

I think it’s “trial and error”. You can however get an idea of what to look for in the looooong list of field names. If you hit Ctrl+F10 while you’re in the screen with the field you want to hide, you get a list of all the field names on that screen. You might then be able to deduce the field name of the field you want to hide.

I am not aware of any data dictionary that shows the information you need, but if one exist I sure am interested in a copy.

Regards,

Henrik

[Henrik Ekenberg]

Hi Bennett,

You need to go to User/System Setup/Security/Security Settings and specify which fields you want to be able to restrict. Once that is done, the fields should show up in the windows you mention. At least it does in my system.

Be aware that the window will be empty until you click on a user name.

Regards,

Henrik Ekenberg

[Henrik Ekenberg]

Mark,

First of all, in my opinion, access to the forms designer should be kept to an absolute minimal number of users . It takes so little to mess up a form, and Forms Designer, although improved significantly since the one in version 9.5, still is not an easy tool use.

I am using the same naming convention as Nick, that way it is easy to tell which forms has been altered.

When I edit a form, I always make a copy by saving it as another name. I usually add the ticket number from my help desk system at the end of the name.

Once the form has been tested, I save it as the original form name, overwriting the existing form, that way the users do not need to make any changes to their setup/Styles etc.

Next time the users run the form it is the edited one they use.

I have an archive with all the forms we use, and every time a form is changed I record the changes in a change log I have for each form. The edited form is then exported from QC and saved in my archive with a version number added to the filename. That way I can go back to a previous form if ever needed.

Keeping a PDF version is actually a great idea, I will adopt that.

Just my two cents.

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Hello Ryan,

I have done some research in my system, at it seems that the value in the USER_ROLE field ends with a “=” on the users that are administrators.

I tried changing a normal user to administrator and the value changed to a new value ending with “=”. Changing the user back changed the value back to the previous value.

If the “=” is indeed what distinguish the administrators from the herd, a list can easily be retrieved in Interactive SQL with:

SELECT SYSUR_AUTO_KEY, USER_NAME, USER_ROLE FROM SYS_USERS WHERE USER_ROLE LIKE ‘%=’

Try it out 🙂

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Hello Lydia,

You are indeed able to set individual permissions directly on a user, I would however advise against it.

I have done this in the past but I experienced that for some reason the users permissions sometimes defaults back to the templates assigned to them. Resulting in “angry” users asking why I revoked their permissions.

I would create two seperate templates and apply them to the users in question, this makes future administration much easier.

For example, if another employee needs the same permissions its easier to just apply the template(s) on top of the others than to go through every permission of that user and set that on the new employee.

The new function called “View User Security Profiles” you’ve got an exceptional tool to give you an overview of who can do what. You can even filter on modules, departments, individual users, and more.

I have created two Crystal Reports that shows the members of each template and what template a user is a member of. If you are interested I can email them to you.

I hope this makes sense.

Bottom line… in my opion creating new templates is the path to choose.

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Hi Paul,

This looks like a great way to handle this, I think I will try an implement this process here, I just have a few questions though.

Under the fake PN, are you just adding a bunch of stock lines at one time, or do you add them “ad hoc”?

Also is the PN serialized? If no do you add one stock line with muliple qty or several stock lines with qty 1?

Thanks,

Henrik

[Henrik Ekenberg]

Paul is right.

You need to grant access to “Quantum ControlUser SettingsUser Configuration” for this to work.

I don’t know why the path is not included in the error message as it is with most other access denied warnings.

Best regards,

Henrik

[Henrik Ekenberg]

Hi Irina

In my opinion the functionality of the shelf-life function is working as it should, because a part with an expiry date is a part with shelf-life 🙂

I still believe that it is your process that needs changing. Logistics says that it creates more work, that is true… but how much more work is it really? Correct me if I’m wrong, but all that is required from the logistics to make this work, is that they have the cursor in the Exp. Date field press “F4” and “Enter”. Taken into consideration that all functionality, reports, and warnings in regards to expired stock lines can be utilized, I think it is worth the extra work.

With that said, there is another option, though it creates some other inconveniences.

On the stock line you are able to set a “Hold”-flag which makes the stock line invisible. So when you try to reserve a stock line, the stock lines with that flag will not show in the list of stock lines.

If you have Event Manager you can have it run a SQL command every night that sets the “Hold”-flag on all stock lines that have an expiry date that is before current date like this:

UPDATE STOCK SET HOLD_LINE = ‘T’ AND REASON_FOR_HOLD = ‘Hold’ WHERE EXP_DATE < CURRENT_DATE The downside to this is that even though the stock line is on hold it still counts towards your Qty Available which could cause some scenarios where a sales person thinks there is stock where there’s none. The stock lines will appear as available until they are adjusted out of the system. That’s just my two cents, next step would be paying CC for some custom programming. Best regards, Henrik

[Henrik Ekenberg]

Hi Irina,

I am glad i worked.

Let me see if I understand this correctly. You are receiving the parts in QC before having the parts physically and therefore do not know the expiration date?

If that is so I guess that you are doing an inspection of the parts once they actually arrive at your facility? If so, maybe you could change your process so the Logistics team enter the current date when receiving the parts in QC, and then when the parts arrive and are being inspected, the correct expiration date could be entered at that point.

I might be out on a limb here, and I do not know if this violates any regulations company wise, or if it prevents the preparation of the export documents. This is just my suggestion and how I might solve it if we ran into this situation.

Best regards,

Henrik

[Henrik Ekenberg]

Hello Irina,

It works in my system. It is correct you need to check the Shelf Life box,

but you do not need to put in Shelf Life Days.

I have tested it in my system, with Shelf Life checked on the Master Part, and no value in Shelf Life Days.

On the Stock Line, the Shelf Life field is left empty and expiry date entered. I was not allowed to reserve that Stock Line to a Work Order nor a Sales Order.

I have made a pdf-file with some screen shots, you can get it here.

I hope this helps.

Best regards,

Henrik

[Henrik Ekenberg]

Hello Irina,

You can restrict the use of expired stock by going into Inventory Module Settings and

set “Reserving/Issuing of Expired Material” to “Block”.

That should prevent expired stock to be used.

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Thanks.

It pretty much sums up the average it-skill level in my organisation 🙂

[Henrik Ekenberg]

SELECT * FROM users WHERE clue > 0

0 rows returned

[Henrik Ekenberg]

Hi Anthony,

What you describe is a perfectly normal Outlook behaviour, as Outlook is not capable of inserting the signature automatically when using MAPI.

Please see the following link to the explanation from Microsoft.

http://support.microsoft.com/kb/2544665

So this time, and just this time Quantum (CC) is not to blame 🙂

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Andrius Cechavicius wrote:Dear Henrik,

Thank you for the script but I have one question is it works every time when user logs on to Windows or is it works on computer startup?

Thank you

With best regards,

Andrius Cechavicius

Hello Andrius,

I run it when the user logs on, I guess it could be run at computer startup also, but I have not tried it. One “big” difference between running the script at startup vs. log in as I see it , is that it is faster to do a log out and then a log in, than to reboot the computer. So if a file gets updated during the day, all the user has to do is close QC, log off and log on.

Best regards,

Henrik

[Henrik Ekenberg]

Nick Chambers wrote:we were running into the same issue and we finally resolved on this last update. We actually run a software called Labtech for our network administration. It allows us to continually monitor all computers and run batch scripts. We ran two scripts. Script one was to Wake on Lan while Script two was to simply launch Quantum…..AS ADMINISTRATOR. This actually loads the .dlls and updates the registry with admin permission. You can alternatively simply run Quantum on each machine as administrator and achieve the same results.

It worked like a charm for us this time.

Hi Nick,

That sounds interresting, does the program exit QC and shut down the workstations after the update?

Best regards,

Henrik

[Henrik Ekenberg]

Ryan Corbean wrote:One of the reasons I went to all RDP. One update everyone done.

Yeah, I would like to do that too, but we are using some applications that I believe would cause some problems both in regards to ressources and licenses (AutoCad and Adobe Acrobat).

I am planning to have some of our users move to RDS/TS, but that project is still sitting in the queue.

Best regards,

Henrik

[Henrik Ekenberg]

Hello Andrius,

I have been using the script (vbscript) mentioned in my earlier post for almost a year now. I can count on one hand how many times I have run qcreg.exe on a computer.

I only use it if a client starts acting weird, and only to rule out that it could be the cause of the error.

I use a Windows Server domain here, so via a Group Policy Object I configured the script to run when a user logs on to the computer. Depending on the workload and specs. of the computer the

script is done in max. 30 seconds. My typical run time is about 1-10 seconds.

You can download the script via the link below, please make sure to edit the “System specific variables”-section before use.

I also suggest that you try the script on at computer that is not vital, just to make sure everything is working the way it should.

The script obviously needs administrator rights on the computer to be allowed to replace files in the Quantum folder, that is why I execute it during user log on.

https://dl.dropboxusercontent.com/u/8648872/QUE/QuantumControlUpdate%20Script.zip

Best regards,

Henrik

[Henrik Ekenberg]

Hi Paul,

Thank you for your reply. I suspected it much that that is the only way to do it.

I have done this before with Part Condition Codes and it is not difficult, just tedious work. 🙂

Well… better get to it then.

Thanks,

Henrik

[Henrik Ekenberg]

Update…

I don’t know in which version it was fixed, but in version 10.4.5 the “Empty Trashcan”-function is working.

//Henrik

[Henrik Ekenberg]

Thank you Paul, that did the trick.

[Henrik Ekenberg]

Hello Ken,

I am not sure, but I believe what you are looking for is set in the Work Order Control Setup.

Go to the menu “User/System Setup/Work Order” press the “Work Order Module Setup” button and select “Control”.

On the “BOM” tab there are two tick marks named

“Update template BOM price when list price changes” and

“Update BOM price on open tasks when list price changes”.

The following is taken from the QC Help File:

Update template BOM price when list price changes

Enable this flag if you wish to update templates and bill of materials items when the list prices changes on a

part that is in either of the aforementioned options.

Update BOM price on open tasks when list price changes

Used only if the setting above is checked. Updates open tasks with new list price.

I hope this is what you need.

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Hi Paul,

How can I change my password?

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Hello Bill,

I would also like copy of those instructions please.

Thanks.

//Henrik

[Henrik Ekenberg]

Hi Dave,

I don’t think you need the PARTS_MASTER table at all. Since the STOCK table already has the PNM_AUTO_KEY you can just make a left outer join from STOCK.PNM_AUTO_KEY to PRICES.PNM_AUTO_KEY.

If you need information from the PARTS_MASTER table you can just add the table and create a left outer join from STOCK.PNM_AUTO_KEY to PARTS_MASTER.PNM_AUTO_KEY and pull in any field you need.

Best regards,

Henrik

[Henrik Ekenberg]

Ok… I have now deleted some of the records in RB_ITEM that had RBF_AUTO_KEY=’-2′.

So far no problems. And it actually solved a problem I had.

The problem was that if a technician added a certificate to a work order and forgot to select a document, for some reason the system threw out an error and grabbed an old (read: deleted) dokument and allowed the user to print out an obsolete form.

Now, QC throw out the standard “Record not found: 283” error and the user is not able to print the certificate without selecting a document.

I wonder how many places in QC a deleted document is still used, maybe a version number printed on the document is in order 🙂

[Henrik Ekenberg]

Yeah I thought I would have to use DIA. Not so keen on using it because it can seriously mess up our data.

I was looking for a method were “normal” users could do the import somewhat easy and nearly failure proof 🙂

Thanks,

Henrik

[Henrik Ekenberg]

You are most welcome, glad I could help.

Best regards,

Henrik

[Henrik Ekenberg]

Hello Karen,

We do not use User Input. Our technicians enter the contents of block 13 (block 12 on an EASA Form One as we use) into Corrective Actions instead.

Best regards,

Henrik

[Henrik Ekenberg]

I have found out that the reports are stored (only listed?) in the table RB_ITEM, and the reports that are in the trash can has RBF_AUTO_KEY = -2.

But I am not sure if deleting the records in that table will do the trick.

[Henrik Ekenberg]

Oh, I misunderstood. Thanks, for clearing it up, and for posting your findings.

Best regards,

Henrik

[Henrik Ekenberg]

Hi,

I can edit mine. Are you getting an error message?

If you are trying to edit the documents starting with STD, you cannot save the document as the same name because it is classified as a system report. You wil have to use another name.

Best regard,

Henrik Ekenberg

[Henrik Ekenberg]

Hello Ken,

I don’t believe that it has anything to do with your tasks. The task names are stored in WO_TASK_MASTER.

I think you either 1. Have a charge called “Labor” or 2. Have an inactive part called “Labor”.

When deleting a Master Part in QC, the record still exist, it’s just the flag ACTIVE_PART that is set to False, making creating a part with the same part number impossible.

If you run this command in Interactive Sql it will show if you have any charges or inactive parts called “Labor”.

SELECT PN, DESCRIPTION, CHARGE, ACTIVE_PART FROM PARTS_MASTER WHERE (ACTIVE_PART =’F’ AND PN=’Labor’) or (CHARGE = ‘T’ AND PN=’Labor’)

Be advised that your search criteria is case sensitive so “Labor” is not the same as “LABOR”.

Best regards,

Henrik

[Henrik Ekenberg]

Hello Leo,

The exchange information for each SO Item is stored in the table EXCHANGE.

The Exchange Type is stored in EXCHANGE_TYPE_CODE in that table.

If you know your SOD_AUTO_KEY, you can run this to show the exchange type for that line (substitute X with your SOD_AUTO_KEY):

SELECT SOD_AUTO_KEY, EXCHANGE_TYPE_CODE FROM EXCHANGE WHERE SOD_AUTO_KEY=X

It might be possible to create a SQL-command that shows all items from a SO at once, but I am not so adept with SQL yet.

Best regards,

Henrik

Edit:

Just realized that this was posted in the Crystal Reports forum, so i guess my answer is not quite satisfactory 🙂

In CR you should link SOH_AUTO_KEY from SO_HEADER to SOH_AUTO_KEY in SO_DETAIL, and SOD_AUTO_KEY from SO_DETAIL to SOD_AUTO_KEY in EXCHANGE. All links shoud be “Left Outer Join”s.

You can now pull in the fields you need and make a parameter field to be able to easily select a certain Sales Order.

[Henrik Ekenberg]

Will most certainly do. How do I go about that? Is there a nomination form?

Henrik

[Henrik Ekenberg]

I am so fortunate that I am situated 9 hours from CC (time zone wise). That makes my points of contact in regards to tech support very few. So I deal with the same two supporters most of the time. It is my experience that when I am reporting an issue I am having, they always test it in their own system in the latest version (even on the version in development).

That way they can tell if the issue still exist in later versions.

Kudos to my “techies”.

So my advice is to ask the supporter to check in their own systems instead of guessing 🙂

[Henrik Ekenberg]

Hello Bill,

Where are you pasting your part number? Is it when you add a line to an RFQ?

In that case it works in my version 10.2.20.

BR,

Henrik

[Henrik Ekenberg]

Hello Billy,

CC has actually introduced this feature. We are using version 10.2.20, and I am able to view

the header on a closed Work Order by clicking Global/View Header.

Screen shot

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Hello Lydia,

Have you tried seperating your entries by a semicolon?

Semicolon is used to seperate recipients in the email fields, so maybe that goes for the P Exclude Mask as well.

Best regards,

Henrik

[Henrik Ekenberg]

Update: Upgraded to 10.2.20 last night, and the problem still exist.

Talked to CC again, and unfortunately it won’t be fixed until version 10.3 which I believe is still at least a month away + inhouse testing.

[Henrik Ekenberg]

According to Adam at CC, there is no patch available, but the problem is corrected in the latest build (10.2.19).

[Henrik Ekenberg]

Thanks Nick.

Maybe it just a 10.2.16 error then. I’ll approach CC and hear if they have an idea.

Edit: Just found out that there is a Tracker Event for this issue (T707), and it should be solved in version 10.3.