[Henrik Ekenberg]

I really like the new look, I just wish that the subscriptions to forums and posts was transferred to the new profile.

I realize that the subscriptions to the vast amount of forum threads are lost but is there an easy way to subscribe to the forums again or do I have to go to each of them and click on “Subscribe”?

Thanks.

[Henrik Ekenberg]

Hi Craig,

From my experience the CLOSED_UPDATE is always F.

When you need to update a record that is closed you include CLOSED_UPDATE = ‘T’ in your UPDATE statement.

The CLOSED_UPDATE value is set to F automatically after the update.

BTW… I think you can update the QA_REQUIRED field without the need to set the CLOSED_UPDATE to T.

//Henrik

[Henrik Ekenberg]

Good morning Jim,

Thank you for your response.

Please see my replies below.

1) Am I correct the user is able to login to Quantum and is able see data from within Modules in the Quantum app?

Correct, she can see everything. She can also run all other queries through iSQL, but for some reason sometimes when a view is involved there is just no data. She can then change the user to sysdba and run it again with success.

2) And the user (when logged into your PC with his/her credentials) is not able to see the data within Interactive SQL – correct?

Correct. She can not see the data for this particular query.

I failed to mention that we are operation in a Windows Virtual Desktop environment (WVD), so basically everything is done on the same “computer”.

3) And yet you (when logged into your PC with your credentials) are able to see the data within Interactive SQL – correct?

Correct, I have no issues what so ever.

4) And if you create a new account for the user (User #2B) (when logged into your PC with the new User #2B account) you are able to see the data within Interactive SQL – correct?

Correct.

5) And if you (when logged into the USER’s PC with your credentials) are able to see the data within Interactive SQL – correct?

Correct.

6) And if you (when logged into the USER’s PC with the User #2B credentials) are able to see the data within Interactive SQL – correct?

Correct.

Thank you for your help.

//Henrik

[Henrik Ekenberg]

Mike Carey wrote:

Hi Henrik … If you remove the sys companies column and join, does he see data? What if he runs the query in isql on his quantum login?

Hi Mike,

This is what I have tried so far:

– I have created a new report from scratch adding only the view. Same result.

– Running the SQL in isql on the users login does not produce any data.

– I have tried creating a new Windows User Account and a new QC User, the reports and SQL runs fine.

– I have created a report adding a command with the SQL from the view itself – same result.

– I have had the user who cannot run the report login to QC on my Windows login, no dice – the report is empty.

Especially the last thing leads me to suspect that the problem is with the QC User/Environment rather than a Windows User/Environment issue.

//Henrik

[Henrik Ekenberg]

John Schneider wrote:

Our Office on the RDS server is 365 MSO 16.0.13628.20128 32-Bit.

Do CC officially fully support 64 bit Office?

Hi John,

I asked CC that question in September 2020:

Q: “We want to utilize a 64-bit version of Microsoft Office – are there any compatibility issues with Quantum Control?”

A: “It will not be an issue to utilize a 64bit version of Microsoft office”

I must point out that the answer was from a sales guy, so I guess it should be taken with a grain of salt.

//Henrik

[Henrik Ekenberg]

Thank you Vicky, I will definitely look into that when I get back to work tomorrow.

[Henrik Ekenberg]

Hi Nadim,

My test report with the PARTS_MASTER only contains the PN field.

I am unsure what standard date is in our world 🙂

Our test server is set up with American settings and our production server is using Danish settings.

I have tried to change the test server so the setting are identical but that does not solve the issue.

Also, since a report works in schema A but not in schema B in the same database I do not suspect that the server settings is the culprit.

I actually get another error message the first time I run a non-working report. If I run the report again I get the External Exception error.

//Henrik

[Henrik Ekenberg]

Hi Guys,

FYI if you zip the rtm-file you will be able to upload it.

//Henrik

[Henrik Ekenberg]

This is an issue that goes waaaay back. The issue has been reported several times and I even brought it up at a conference a few years ago (2016).

So CC HAS heard of it before.

There is another thread regarding this issue here:

https://quegroup.org/f_system_admin/3884364#3884364

//Henrik

[Henrik Ekenberg]

The Core Returns would be “Sales Order Exchange Core” security ID 20150.

I probably would turn off security ID 20110 as well.

//Henrik

[Henrik Ekenberg]

Hi Anna,

You can create the Shipping Order from the PO, but you can not add the SL as it was removed when the “Return Parts to Vendor” function was used.

I believe the “Return Parts to Vendor” function is to be used only if you do not have the Shipping Module, as a way to get parts/cores out of QC and leave a trace on the SL as to what happened.

We have had a few issues (before I disabled the function in Security) where users accidentally returned the part/core without using the Shipping Module. In those cases we put a note on the PO lines that the parts/cores were shipped manually outside of QC.

//Henrik

[Henrik Ekenberg]

Update:

Had to add some logic to the code as it turned out that preceeding zeros were removed from the decimal.

Eg. 2214,08 became 2214:8.

The code now checks if the decimal. If it is < 10 a "0" is added after the colon. My code now looks like this: begin If (WP_MODELS[‘METER_HOURS’]- Trunc(WP_MODELS[‘METER_HOURS’]) + 0.005)*100 < 10 then Text := IntToStr(Trunc(WP_MODELS[‘METER_HOURS’])) + ‘:0’ + IntToStr((WP_MODELS[‘METER_HOURS’]- Trunc(WP_MODELS[‘METER_HOURS’]) + 0.005)*100)else Text := IntToStr(Trunc(WP_MODELS[‘METER_HOURS’])) + ‘:’ + IntToStr((WP_MODELS[‘METER_HOURS’]- Trunc(WP_MODELS[‘METER_HOURS’]) + 0.005)*100); end;

[Henrik Ekenberg]

BRILLIANT!

Thank you.

//Henrik

[Henrik Ekenberg]

Thanks guys for all your help.

Mike, the code you provided worked like a charm!

John, thank you for the link. I’ve already got the Developers Guide and although it’s pretty comprehensive, I was thinking more in the line of a reference manual where the commands and their parameters are explained.

//Henrik

[Henrik Ekenberg]

Hi Mike,

Thanks, but I have tried that already. It resulted in the decimal to round down to an even 14.

I am sure there is a way to get it to round up instead, by I have no documentation on Forms Designer/Report Builder and faild to locate anything on the internet.

If anyone have any reference guides of some sort I am really interrested.

Thanks.

//Henrik

[Henrik Ekenberg]

Hi Nadim,

Thank you, it almost brought me the result I want.

It shows the result as 8171:14,9999999999636 instead of 8171:15

How can I get the decimal part to round up to 15?

//Henrik

[Henrik Ekenberg]

Hi Mike,

Thank you, I am glad you liked it.

And thank you for the hint about MC’s out for repair. This was not part of the original scope when I was asked to make the report, but it sure makes sense.

I have added the link as suggested, but to a separate WO_OPERATION table (I called it WO_OPERATION_MC). Otherwise the link from the BOM to the WO will break.

I have made is so if the RO Detail is a MC it will say “MC on XXX”. This is to differentiate between BOM and MC’s.

//Henrik

New version attached.

[Henrik Ekenberg]

I logged a ticket with CC yesterday, and got added to the Tracker T673.

I suggest that anybody who agrees this is a security issue, contact CC and do the same. The more heat they get on this the better.

Right now it seems like it’s a “fight” against the developers who says that it’s designed this way.

//Henrik

[Henrik Ekenberg]

Hi Kevin,

I was able to reproduce the issue on my system this morning, it must be a bug.

If this is by design, why bother having security settings on a Contact Master at all?

Did CC explain why it is designed this way? I can’t think of a single plausible reason.

//Henrik

[Henrik Ekenberg]

Hi Lisa,

A while back I made a report to show open RO’s along with the Stock Lines.

Feel free to dissect and take anything you can use.

//Henrik Ekenberg

Edit: Attachment removed, see new version in a later post.

[Henrik Ekenberg]

Hi Jesse,

Take a look at the table CALL_LIST, it contains the security codes.

//Henrik Ekenberg

[Henrik Ekenberg]

@Abigail

To the best of my knowledge there is not.

The AD Account/Windows credentials are only used to authenticate with the Quantum user. No part of the information stored with the Windows account is used when logging into Quantum.

Quantum only checks what user is logged into windows and if a there is a link to a Quantum user that user will be logged in.

Quantum still uses the Quantum user’s credentials to log in, which is why users are prompted to change their Quantum password when they expire.

@James

I agree that using this may present a security risk if users do not lock their screens when leaving the computer, which is why I only enable the feature for users I know locks their screens when they are away.

//Henrik

[Henrik Ekenberg]

Hi James,

Have you updated Java lately? I have experienced similar behavior when Java was updated because the Java installation folder is changed.

The path to the Java in emgrmail.bat located in X:emgrmail has to be changed to reflect the new folder.

If the path in the JAVA_HOME variable is not correct the script will not run and the emails get stuck in the queue. Changing the path and then run the batch file will process the emails in the queue.

This might not be your issue, but worth looking into.

//Henrik

[Henrik Ekenberg]

@James

It is possible (from v10.7 on I believe) to link a Quantum User to an AD User so a user doesn’t have to enter Quantum credentials. This can be set up individually per user.

If you are interested in utilizing it take a look at the guide found here:

http://quegroup.org/QUES_SysAdmin

//Henrik

[Henrik Ekenberg]

Hello Gabrielle,

If you want to change ALL stock lines in multiple warehouses to another warehouse, that can be done quite easily.

Let’s say you want to move all stock lines from the warehouses with whs_auto_key 1 and 2 to a warehouse with whs_auto_key 3. You can do that by putting the “from” warehouses in an array like this:

update STOCK set WHS_AUTO_KEY = 3 where WHS_AUTO_KEY in (1,2)

Be warned that this will change ALL stock lines in WHS 1 and 2 to 3.

Henrik

[Henrik Ekenberg]

Hi Duane,

You are actually correct. ARCHIVED = ‘T’ indicates that the user is set as Inactive/Disabled.

When ARCHIVED = ‘T’ it should throw an “Invalid Username and password”-error.

//Henrik E.

[Henrik Ekenberg]

Thanks Nadim, I’ll give that a try.

Next hurdle is that the report is used on multiple printers depending on the user 🙂

//Henrik

[Henrik Ekenberg]

@Mike: Nope

@Pietro:

It is not a report scheduled in an event. It is a report we open from WO/Global/Print/Custom Crystal.

//Henrik

[Henrik Ekenberg]

Jesse,

I have only installed it on one workstation which has Adobe Acrobat DC installed also.

We experienced that this particular workstation had trouble viewing the documents in Acrobat DC, and forcing it to use Adobe Reader did not solve the issue. The document was not updating in the window and Quantum sometimes just froze.

So reading Paul Stewart’s suggestion I decided to install FoxIt Enterprise on the machine, and was surprised to see it showed the document in the window instead of opening a separate instance.

The user has not had any issues since, and he says it operates pretty quick.

If I get complaints from other users I wouldn’t hesitate to install on their workstations as well.

//Henrik

[Henrik Ekenberg]

Paul Stewart wrote:

“Many of our machines now use FoxIt Reader. The only down side (although some like it this way) is that FoxIt will open the PDFs outside of the viewer.”

Hi Paul,

I just installed Foxit Reader (Enterprise) version 8.3.2.25013 and the documents are actually showing in the Quantum window. Maybe they changed it to work in a browser.

//Henrik

[Henrik Ekenberg]

I couldn’t agree more. 🙂

[Henrik Ekenberg]

With a little delay, the files are now posted in the QUEsources section http://quegroup.org/QUES_SysAdmin

//Henrik E.

[Henrik Ekenberg]

Thanks Mike!

I actually tried the chr method, but forgot to put a “+” between them. Now it is working.

I don’t know of any similar functions, although an input box could come in handy.

I am very interested in a write-up on Forms Designer, thanks.

//Henrik

[Henrik Ekenberg]

Hi Mike,

This is just a snippet from our EASA Form 1. The code is located in the Report Object in the “BeforePrint” event.

I use ShowMessage several times in this document.

{This section determines if the the PN is missing}

if STOCK[‘PN’] = ” then varPNBlank := ‘T’ else

varPNBlank := ‘F’;

if varPNBlank = ‘T’ then

ShowMessage(‘Issuing certificates for this PN is not allowed’);

[Henrik Ekenberg]

There is no native way to see it in the Stockline window, as far as I know. But you can look it up if you access Stock Audit or Audit Trail.

//Henrik E.

[Henrik Ekenberg]

Jens-Uwe Suess wrote:

Hello,

how can multiple part numbers be imported into a open sales order?

Kind regards

Jens

Hi Jens,

You can import from an excel-file by right-clicking the browse window on a sales order and select Import. Now you can select a file and afterwards you can map your columns to the different fields in the sales order. You’ll need at least PN, Qty Ordered, UOM, and Condition Code in order to complete the import.

As Abigail mention, you would have to make the stock reservations manually afterwards.

//Henrik E.

[Henrik Ekenberg]

Hi Gabrielle,

We experience the issue too from time to time.

When it happens I switch to another Windows task by pressing Alt+Tab release and then press Alt+Tab again to go back to Quantum.

//Henrik E.

[Henrik Ekenberg]

Hi John,

They were caught in our email filter. But I got them now.

I will get this uploaded to the website asap.

//Henrik

[Henrik Ekenberg]

Hi John,

I will be happy to “throw” these tools on the website for QUE Group members to download.

We can display whatever disclaimer you want 🙂

Thanks for sharing.

//Henrik Ekenberg

[Henrik Ekenberg]

Hi Vanessa,

I assume you are using the Company browse to do the export?

If so you need to check the “Export Hidden Fields” box when you export.

You also need to set the fetch size (Alt-M) to “-1” otherwise you won’t retrieve all the companies.

Mike’s suggestion will work, but you would need to have been granted access to Interactive SQL to do it.

//Henrik Ekenberg

[Henrik Ekenberg]

Hi Sally,

I realize this is an old thread by just in case you are still looking.

I believe Pietro Race from FAST would be a good bet.

He has vast knowledge of both Quantum and Oracle.

You can contact him via e-mail pietrorace@framici.com

//Henrik E.

[Henrik Ekenberg]

We’ve been using this for about six months now, without any issues.

I have only rolled it out to users I know lock their terminal when leaving it as it could present a security risk.

I have uploaded a guide on how to set it up.

You can find it in the Members-Only area under QUEsources/System Administration.

//Henrik

[Henrik Ekenberg]

Hey Ab’s

I am printing via Global/Print/Custom Crystal from within the Work Order Module.

The report I am printing needs to go to a specific printer because of the size of the document (labels). When I print, it selects the user’s default printer, and the user has to select the correct printer every time.

I am looking for a way to specify that when this user is printing this report, the correct printer is selected by default.

I have tried to save the settings to a Style, but the printer settings are not saved.

Thanks.

//Henrik

[Henrik Ekenberg]

Hello Ian,

Try to revoke permission to Open Work Order (Security ID: 227950).

I am not sure if it will work, but it’s worth a try.

//Henrik

[Henrik Ekenberg]

Hi Vanessa,

When you have created the billing for the first Work Order, you can add the other Work Orders to that billing by clicking “Add” and select “Work Order”.

This brings up a list of Work Orders for the same customer you can select from.

//Henrik

[Henrik Ekenberg]

Hi Rolando,

You can use

SELECT * FROM AUDIT_TRAIL WHERE SYSUR_AUTO_KEY IN (SELECT SYSUR_AUTO_KEY FROM SYS_USERS WHERE USER_NAME = ‘HEK’)

to show everything for a specific user in the audit trail. Just replace HEK with the username of your choice.

You can also narrow it down to only show the last month:

SELECT * FROM AUDIT_TRAIL WHERE SYSUR_AUTO_KEY IN (SELECT SYSUR_AUTO_KEY FROM SYS_USERS WHERE USER_NAME = ‘HEK’) AND STAMPTIME > ADD_MONTHS(CURRENT_TIMESTAMP, -1)

//Henrik

[Henrik Ekenberg]

Tony,

I got that error too, but I found out that in my case it was because I couldn’t drag it high enough because there was objects in the way. Once I moved the objects it worked.

See you in July!

//Henrik

[Henrik Ekenberg]

Hi Tony,

I just tried, and I did succeed :).

I had to adjust the Detail section manually as it didn’t move up automatically.

I needed to adjust the print settings on the printer also.

//Henrik

[Henrik Ekenberg]

Hi guys,

Thank you for your suggestions.

Quantum is running through a remote desktop environment, so I can’t really “mess around” with the installation e.g. delete any files and such.
Also, this user is the only one in the company that has reported this issue, and it is present regardless of which remote desktop host is running his session.

I tried the Ctrl-Alt-End but that did not solve it.

I also tried Pietro’s suggestion and deleted the Quantum Control key in the registry, but to no avail.

I believe it must be something in the user’s profile since it follows him on every host and not on all users.

[Henrik Ekenberg]

Hey Timmeeeeeey! 😀

Thank you for the response, looking forward it.

Another thing… on the Recent Forum Activity page, is it possible to show which forum the post is posted in?

Thanks.

//Henrik