[Henrik Ekenberg]

+1 for the copy template procedure.

We have also restricted access to “Modify Template” except for a few people who knows the “danger”.

[Henrik Ekenberg]

Eric,

That is a great report, thanks for sharing

Henrik

[Henrik Ekenberg]

Bob,

If it is a Custom Crystal Report (a report that is not associated with a menu-item) be sure to select “RPT_CUSTOM_CRYSTAL – Custom Crystal Reports” in Settings Group when you add the report. Otherwise the report will not show up when you select “Print Custom Crystal Report”.

Henrik

[Henrik Ekenberg]

Hello Sue, As far as I know, Billing Groups can only be used in conjunction with a Work Package or Work Order. Best regards, Henrik

[Henrik Ekenberg]

Hi Ken,

If I understand correctly, you want to enter the date using the “US-way” but show it the “International-way” on the documents?

If so, it is the documents that needs to be changed to show the dates in a different format.

//Henrik

[Henrik Ekenberg]

Thanks Paul,

With some minor changes I got it to work.

I tried Text := FormatDateTime(‘dd/mm/yyyy’, WO_OPERATION.FieldObjects[‘CLOSE_DATE’].AsString);

but that returned an error (incompatible types).

I then changed the code to

Text := FormatDateTime(‘dd/mm/yyyy’, WO_OPERATION[‘CLOSE_DATE’]);

and that did the trick.

Thanks for pointing me in the right direction.

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Hello Leo,

I might be out on a limb here, as I have not used RMA. I believe that CM_NUMBER stands for Credit Memo Number which should be the same as the Invoice Number (pulling from the same table). In that case you should be able to pull the CM_NUMBER by linking INH_AUTO_KEY from RMA_LOG to INH_AUTO_KEY in the INVC_HEADER table and then place the field ‘INVC_NUMBER’ in your report.

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

When I make reports, I turn the background on every other item grey.

That is done by right clicking the Details section in Design view and select “Section Expert”. Click the “Color” tab in the right part of the window and click on the formula button to the right of the combobox.

In the formula editor insert this code:

if RecordNumber Mod 2 =0 then

Color(222,222,222)

else

CrWhite

Save and close the editor and click OK to close the Section Expert.

Now the first item is on white background, the second on grey and so on.

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Hi Paul,

I am interested in that report to.

Thanks.

Henrik

[Henrik Ekenberg]

Hi Paul,

The .dll-files are also mentioned in the VersionCheck.dat.

It is not the VersionCheck.dat that gets updated, it is any of the files listed in it.

If I for example delete a file on the client that is mentioned in that list, or if I change the date on one (or more) of the files, so it is older, the Quantum Updater is launched the next time I launch QC.

I remember at one point I needed a patch from CC and they advised me to test it first on my own Workstation just by copying the .dll-file it into my Quantum Control folder. So I am unsure if it needs to be registered.

However if it was possible to run the QCreg.exe in “silent-mode” that would be sweet.

My script seems to run fine, I tried to manually delete and change some file dates, and the logfile shows that the script copied the files in as intended and QC ran fine, but I will keep on testing some more.

BR,

Henrik

[Henrik Ekenberg]

That’s great Nick, looking forward to CC’s reply.

BR,

Henrik

[Henrik Ekenberg]

Hello André (and others),

I am having the same problem.

Was this issue reported to CC? If yes what did they say?

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Paul,

Just got off the phone with Stephen Sullivan. What causes this behaviour is a pause command left in a couple of batch files by mistake. Stephen fixed the problem in a couple of minutes via screen share.

This “bug” has been corrected in version 10.2.

Best regards,

Henrik

[Henrik Ekenberg]

Hi Paul,

I’m “glad” I’m not alone on this.

I just reported the issue to Nicola. He’s out of the office until the 22nd.

I will post whatever response I get.

Henrik

[Henrik Ekenberg]

Hi Paul,

Thank you for your reply.

I am not sure if I got an issue either (except for the issues I always got with poor programming 🙂 ). I can understand that orphaned processes are left if an application craches, but when you close the application correct it “should” clean up after itself IMO.

The processes doesn’t take up much CPU time, but they do consume 1.5-3 MB each.

The thing is that some of my users experience that QC hangs/crashes (not responding), and at one point I tried to kill the cmd.exe processees one by one, and suddenly QC reponded again. It might have been a coincidence, I need to do some more testing.

I will try and address this issue with Nicola, maybe CC are aware of it already and working on it.

BR,

Henrik

[Henrik Ekenberg]

Hello Cory,

We just upgraded from version 9.5.20 to 10.1.13, and all in all it went fine. There are some issues though.

After upgrading we can’t print a preview of a Certificate, so we have to sign-off the certificate and hope it is correct, otherwise we have to revise it and try again.

The Purchase Management is also messed up. The filtering function have changed, and some items doesn’t show up as it should, so atm. we cannot trust it. We also have problems running the AR Aging Report, it just crashes the client for some reason. It worked in 9.5.20.

Other than that we have only experienced minor issues like reports that have lost the pipeline and users losing some rights due to added security features.

We had a CC Consultant on site for the upgrade which made my stomac a hole lot calmer. Expensive, yes but great for damage control the day after the upgrade 🙂

Best regards,

Henrik Ekenberg

Edit: After upgrading to version 10.1.17 and installing a patch, the printing of the certificate-preview now works.

[Henrik Ekenberg]

Hello Paul,

Thank you for your answer. The latter sugestion sounds “attractive” or maybe even a combination of both. Since I am still in the beginning of my 10-year learning phase, would you share a snippet of code for me to get started?

Thanks.

BR,

Henrik

[Henrik Ekenberg]

Hello guys,

Finally I got the time to try it out, and it worked like a charm.

I just ran the SQL command provided by Paul and after that I could convert the WO to an internal. I found no need to bill the customer a $0, but I may be wrong.

Paul – thank you for the CLOSED_UPDATE tip, I am sure that will come in handy in the future.

Thank you both for your help and input.

BR,

Henrik

[Henrik Ekenberg]

Hello Billy and Paul,

Thank you both for your answers.

I was hoping there was a method that ‘normal’ users could use since I’m not happy about giving users access to execute SQL commands.

On the other hand this is the first time it has happened since we went live last February so I guess that I could do it when these particular situations occur.

Billy – the method you mention will that take the cost from the work order and put on the stock line?

Paul – yes I don’t remember the exact words but it said that I could not convert to an internal WO when the stock line is customer owned.

I will try out the method you mention in our test system and see if it turns out ok.

Thanks again.

Best regards,

Henrik

[Henrik Ekenberg]

Hello Andrew,

Thanks for sharing the code. Do you know what size the .bmp-file should be?

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Hi James,

I don’t think Quantum will be able to compare the user’s password with the network password since that password is not stored “in clear text”anywhere. The user is granted access/rights to the network ressources based on an “Access Token” which the user receives at log-in. Basically the login-server checks Active Directory for the current permissions for the user and creates the token that is then used every time the user tries to access a ressource.

I guess if Quantum/Oracle had the ability to interact with Active Directory it would be possible to use the access token to grant access to Quantum. But I don’t think it has.

Best regards,

Henrik

[Henrik Ekenberg]

Hello,

I’m with Nic on this one, I believe that Pietro mentioned that he has a report that showed the security settings per user. That’s how I heard it anyway.

Br,

Henrik Ekenberg

[Henrik Ekenberg]

Hello Bill,

I’ve got the same problem. Mine shows 15 times. I have tried to have CC to take a look at it, but they couldn’t remove it.

They did assure me that it did not occupy 15 licenses though.

If you run below sql sentence in Interactive Sql in Quantum, you will see how many licenses you are currently using, and by what user (OS user).

SELECT sid, serial#, osuser, machine, program FROM v$session where program in (‘QCSYSMOD.EXE’,’RF.EXE’,’crw32.exe’) order by osuser

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Hello Felix,

You can change the pass-setting in the Report-menu when you are on the Design-tab.

Best regards,

Henrik

[Henrik Ekenberg]

Hello Sandy,

What trial version did you download?

Thanks,

Henrik Ekenberg

[Henrik Ekenberg]

Hello,

This code is brilliant!

Thanks a bunch.

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

I am no expert, and we just went live on February 1st, but I believe deleting the user settings are resetting the users settings and layouts to default (correct me if I’m wrong).

So I would say, try to clear the cache first. And use the delete settings-function as a last resort since users tend to get upset when the have to setup their user settings again. 🙂

BR,

Henrik Ekenberg

[Henrik Ekenberg]

Hello Anonymous,

Did you ever succeed in making that report?

If so, would you mind sharing it with me? 🙂

Thanks,

Henrik Ekenberg

DAO Aviation A/S

[Henrik Ekenberg]

Hello again,

I got in touch with CC, and though I would share the solution to the problem.

For once, it didn’t relate to UAC or folder rights.

It has something to do with old user queries. CC told me to do the following:

Find the SYSUR_AUTO_KEY value for the user experiencing the problem by higlighting the user in “Browsing Quantum Users” and press Ctrl+F10

In “Interactive SQL” (Ctrl+Shift+S) execute the following command:

DELETE FROM SYS_USER_QUERIES WHERE SYSUR_AUTO_KEY = X

Replace X with the value found earlier. It may be neccessary to be logged in as sysdba, I am not sure.

Best regards,

Henrik Ekenberg

DAO Aviation A/S

[Henrik Ekenberg]

This is awesome! Thank you very much for sharing.

Best regards,

Henrik Ekenberg

[Henrik Ekenberg]

Thank you very much, I’ll bet this will help me with my next installation.

BR,

Henrik