[Jason Cordoba]

Hi, this SQL statement will give you an idea of how the structure works.

select sys.sysur_auto_key,

sys.user_name,

CAL.CLS_PARENT,

cal.cls_auto_key,

CAL.SORT_SEQUENCE,

cal.description,

CAL.CALL_NAME,

SYS.EMAIL_ADDRESS

from sys_users sys,

call_users cau,

call_list cal

where

cau.sysur_auto_key = sys.sysur_auto_key

and cal.cls_auto_key = cau.cls_auto_key

and CAL.CLS_PARENT=31310 —aircraft table

—and cal.cls_auto_key=31311 add

and CAL.DESCRIPTION=’Add’

and archived = ‘F’

[Jason Cordoba]

Hi Jim

export the ro detail table so you get the ROD_AUTO_KEY in excel.

with the ROD_AUTO_KEY in excel you can put the tracking number in the same row in excel as the rod_auto_key and then write a statement like this in excel, to copy and paste into SQL

You would have the statement written below , repeated 16 times, the only change would be the rod_auto_key:

update ro_detail set thefieldhere=’trackingnumber’, closed_update=’T’ where rod_auto_key=xxxxx;

[Jason Cordoba]

I recommend using the ‘Hold’ feature that is on the stock line.

When you edit the stock line, on the bottom right side it says “Hold line” which is a checkbox. You can also select the reason (radio button option)

Placing a stock line on Hold means it will not be visible in the browse grids, or the reservation windows.

When you are ready to use it, then uncheck the box.

You can control who has access to this feature in security by making it a read only field, however I doubt anyone would uncheck something that is on hold as they will appear in the audit trail.

[Jason Cordoba]

In Quantum version 10.10 there is a new enhancement in Inventory Control called “View Moving Average Cost Configuration”

Click on any Master PN and select Global, it is the very last one on the list.

when you open this it appears to have all the columns to capture moving costs.

I cannot find any information from the help files but it might be worth asking CC for more information about it, or pushing them to document this new moving cost functionality.

[Jason Cordoba]

use the company merge feature

Global -> company merge

[Jason Cordoba]

Hi Sally,

AJW Aviation in England is scheduled to upgrade to 10.10.5 the first week of August.

AJW Technique in Montreal is scheduled to do the same

We are still testing and have not found any show stoppers.

We use the following modules:

AJW Aviation: Core modules plus Accounting, Lot, RMI

AJW Technique: Core Modules plus Accounting and Shop Control

Please keep us posted and we will do the same.

[Jason Cordoba]

We’ve had these same issues with event manager but on a much larger scale. EM was sending out over 200+ duplicated emails to our customers and vendors. The EM GUI interface would not reflect what was actually happening either.

I had to get Todd involved to get what I considered critical attention to this mess. CC Development first did a patch (didn’t work) then they gave us a new java file and event manager is now behaving. But it has only been a week.

I would contact them and ask for the same event manager updates that AJW received from Daniel and Dominic

[Jason Cordoba]

A user would still need to see the ‘contact management icon’ if they have access to another contact master.

example, on the company header or SO header, there are two contacts. One confidential, one not confidential.

In this case, they need to see the icon, but when selecting the icon, they only see one of the two contacts.

[Jason Cordoba]

I just tested this in version 10.10.2.0 and it is a bug in this latest version as well.

I am going to email component control as this is a security issue for us, we get audited on things like this.

An example would be our legal or commercial department would have confidential documents in their contacts, we don’t want people in other departments to have access to this information.

or another example would be accounting contacts, where we get banking details from our customers, we don’t want anyone to see these contacts that are not in the finance dept.

emailing now…will let everyone know the reply.

[Jason Cordoba]

Hi Tim

Wouldn’t this just be the keyword or alias that you would put in event manager, so it knows to use it from the header? see attached

[Jason Cordoba]

Hi Lisa,

Another area of Quantum that might be helpful for you when managing consignments is to use the Consignment View feature.

Select the drop down menu from Inventory Control -> Consignment View

Select the consignment code

Here you will have a dashboard of all the transactions specific to the consignment code that you selected.

You can configure the browse grids like you do in inventory control.

[Jason Cordoba]

Hi Lisa

I have a report that will show you the various stages of where the consignment stock is, for example, the first column shows all 3 statuses.

1. Stock (consignment stock lines in available qty)

2. Stock Reserved (consignment stock lines reserved to Sales orders, RMI module, or out on a Repair Order)

3. On Exchange (consignment stock out on exchange)

I’ve attached the sql used in the report, but I am unable to attach the Crystal Report, it gives me an invalid extension error during upload. If you want the crystal, email me direct at jason.cordoba@ajw-group.com

[Jason Cordoba]

Hi Rainier, Do you use Quantum Accounting as well? just curious. thanks

[Jason Cordoba]

Hi Jennifer, we are on 10.9.10 and we don’t have this issue.

[Jason Cordoba]

Hi Kristen – I’ve emailed it to you.

[Jason Cordoba]

I believe sharing is caring as well. I’ve just emailed you both. 🙂

[Jason Cordoba]

HI Kevin,

The reporting server is an oracle database. We had the Network Services department at CC set this up for us.

You can use them or you can contact one of the 3rd party consultants such as Pietro or Nadim. They are listed on the consultant’s page on this Que Group website

[Jason Cordoba]

Hi Kevin – We are using Microsoft PowerBI and it is not using any licenses because we have it connected to a Reporting Server. The Reporting server gets a copy of the live database every hour. Might considering setting up a ‘read only’ reporting server.

[Jason Cordoba]

Hi Terri,

The table is SM_EMPL_STATUS.

You will need the employees sysur_auto_key and the status_code which is the SMS_AUTO_KEY

Example;

Jim’s sysur_auto_key is 222 and the shipping status for AWAIT SHIP is sms_auto_key=4

So the insert statement would be:

INSERT INTO SM_EMPL_STATUS VALUES (G_SES_AUTO_KEY.NEXTVAL,222,4,null,null,null,null,null,null,null,null,null,null);

you can put this in excel so you have rows, and replace the sysur_auto_key and sms_auto_key with the relevant users/status.

then you can copy and paste all the rows (each insert statement is one row) and update in mass.

after you do this, use this sql statement to see the all the users in each shipping status:

SELECT

SMS.STATUS_CODE,

SES.SES_AUTO_KEY,

SES.SYSUR_AUTO_KEY,

SES.SMS_AUTO_KEY,

SYSUR.USER_NAME,

SYSUR.ARCHIVED

FROM

SM_EMPL_STATUS SES,

SYS_USERS SYSUR,

SM_STATUS SMS

WHERE

SYSUR.SYSUR_AUTO_KEY (+) = SES.SYSUR_AUTO_KEY

AND SES.SMS_AUTO_KEY =SMS.SMS_AUTO_KEY

AND SYSUR.ARCHIVED=’F’

[Jason Cordoba]

Hi Duane, it uses the STM_LOT from the stock line.

[Jason Cordoba]

Hi Tony, you need to be logged in a sysdba and you need to do it in a theme. Otherwise it will revert.

[Jason Cordoba]

Hello Ruth,

Any chance you are attending the AP&M in May that will be in London? If so, i would like to welcome you to our facility here in England. We are about 500 employees. We are not an MRO. Our MRO facility is in Canada, (AJW Technique) but you are more than welcome to come to our HQ office in England were I will personally take you through our parts trading & exchange processes.

Kind Regards,

Jason Cordoba

jason.cordoba@ajw-aviation.com

[Jason Cordoba]

I believe this was custom programming designed by Avtrade. (however I could be wrong)

If the information isn’t in the help files by June, then we can ask John Schneider. John is the head of IT at Avtrade and will be at the QueGroup conference.

[Jason Cordoba]

I recommend skipping Aeroxchange and all third party companies and go direct with Quantum to Quantum EDI connection.

At AJW, we have a direct EDI connection between our Quantum database and our sister company AJW Technique in montreal.

We will soon have another direct EDI connection with another shop that uses Quantum and does a large volume of repairs for us.

I will be giving a demonstration on how you can setup and configure your quantum to have a direct EDI link between your customers/repair shops.

I will also show everyone the ‘Auto Approval’ feature I designed that auto approves the quote based on fixed pricing that is setup in your database/workscope.

[Jason Cordoba]

Hi Brian – sometimes it is not ‘True’ it can be ‘T’ and vice versa

[Jason Cordoba]

I came across this topic today because I was looking to see if anyone had the sql for this.

Looks like no one placed this info on this thread.

I figured out the SQL and made the report that I needed.

I am placing the SQL here for anyone that searches for this topic in the future and comes across this thread.

select

SYSUR.USER_NAME AS MOD_BY_USER,

ADT.STAMPTIME,

DECODE(ADT.SOURCE_FIELD,’CLS_AUTO_KEY’,

DECODE(nvl(ADT.orig_value,’NULL’),’NULL’,’grant’,’revoke’),ADT.ACTIVITY) ACTIVITY,

decode(adt.source_field,’CLS_AUTO_KEY’,qc_sc_pkg.get_call_tree(nvl(replace(adt.orig_value,’NULL’),adt.new_value)),ADT.DESCR) DESCR,

ADT.DESCR as details,

decode(adt.source_field,’CLS_AUTO_KEY’,null,adt.orig_value) orig_value,

decode(adt.source_field,’CLS_AUTO_KEY’,null,adt.new_value) new_value

from audit_trail ADT, SYS_USERS SYSUR

where ADT.source_table = ‘SYSUR’

AND SYSUR.SYSUR_AUTO_KEY = ADT.SYSUR_AUTO_KEY

AND ADT.SOURCE_AK <> SYSUR.SYSUR_AUTO_KEY

and Adt.STAMPTIME> =(sysdate-10)

[Jason Cordoba]

Drag and drop won’t work if Microsoft office is 64 bit. It needs to be 32 bit. Quantum is 32 bit.

If you uninstall your 64 bit and install 32 bit the drag and drop should work again.

[Jason Cordoba]

Hi Jesse, are you familiar with the DÍA import tool? If you are, I can send you the script.

[Jason Cordoba]

Agreed with everyone else. I’ve known Nadim for over 15 years and can validate the quality of his work and his skillset is of developer level.

Kind Regards,

Jason Cordoba

[Jason Cordoba]

Hi Ian,

Using the StockMarket services from within the customer quote will automate the process. You can RFQ all parts in one click, and the vendors info auto populates.

On the flip side, receiving incoming RFQs or quotes will auto populate quantum when you use the .qcc file.

At AJW we are finding more vendors on the StockMarket that do not exist on ILS

[Jason Cordoba]

If you use the RMI – Remote Managed Inventory module, you will need to keep the woo lines.

[Jason Cordoba]

Hi David – We upgraded from 10.7.35.0 to 10.8.8.0 and yes, every machine needed the crystal report files loaded in order for it to work.

[Jason Cordoba]

Is it the little icon image that disappears, or is it the actual image/documents that were scanned in?

[Jason Cordoba]

Update on the Crystal Report Issue – The reason why we would get the crystal report error (message to update crystal report when trying to print, and nothing would happen) was due to a windows security issue.

Users don’t have ‘full admin’ rights in their windows environment, there is a crystal report software update that is needed to run/install with the latest version of quantum 10.8.8. By giving the user the rights, the files automatically get updated and it works.

[Jason Cordoba]

I have a feeling that you might not be in ‘the public community’. If your not in the ‘public community’ then these errors would happen in your quantum.

To find out, log in as sysdba, then User-> System Setup -> The StockMarket then select ‘Control’

In the Default Community, do you have ‘public community’ selected?

I am going to send you a screen shot of what ours looks like so you can compare. Match everything that we have on ours.

If this doesn’t work, the best person to talk to at Component Control is Cole Davission cdavission@componentcontrol.com

[Jason Cordoba]

Hi Terri –

You can get this data in one report by using the series_number and the woo_auto_key as a match to link them all, starting with the Received items.

I can’t think of a way to do this without using SQL, and then using the SQL statement in the crystal report. Otherwise you will have subreports and it gets overly complicated.

I recreated the data in these three tabs into three SQL statements and then joined them to make one big SQL statement

Received Items:

To get these stock lines you need to use the STI_AUTO_KEY from the STOCK_TI table. You cannot use the STM_LOT as not all the stock lines will have a STM_LOT value in them.

In Stock Items:

The STM_LOT is the best field to use to get these

Sold items:

The STM_LOT is the best field to use to get these and a union to make sure you get any credit memo items.

—-

I will email you the SQL statement and report.

[Jason Cordoba]

Hi Marcelo, I thought the IP address was 209.242.146.200 ?

Also, what if you go directly to the website StockMarket.aero on the same computer, are you able to use the website?

How about enabling port 443? That needs to be open.

[Jason Cordoba]

Pam – Looks like 10.8.8.0 does have the Receiver Reconciliation enhancements. Click here to see a screen shot of it.

—

Sally – The WO Header in 10.8.8.0 did not place any symbols on the WO Header section when I added a contact or header note. There is a new document imaging little symbol on the header but it is on every WO regardless of an image attached. When I attached an image, the icon worked. With no image attached, it brings up the document imaging window. Click here to see my screen shot of it.

—

John – I added a contact to a line item on a RO, it worked fine. Adding a contact to the RO header worked just fine as well. AJW uses Twain for scanning. We don’t use ISIS scanning, or anything ISIS related including religious beliefs. LMAO

—

**BUG ALERT**

We cannot run any Crystal Reports. This is preventing us from testing out the accounting package as we cannot ‘print’ to post, or just in general use any reports from Quantum.

The error is one we have seen before, its a pop up that says ‘Crystal Reports requires a version upgrade which will take several min’

When you click ‘OK’ nothing happens other than the pop up disappearing and you are back on the previous screen. Repeating this does nothing, and selecting cancel has the same behaviour.

TS has had multiple screen shares, downloaded various version files of crystal and it is still not resolved.

If i switch back into our production Quantum 10.7.35.0 all reports work fine (same environment)

I am waiting to hear back from CC today, will update everyone on this if anything should change.

—

**Nice Enhancement(s)**

One thing we do like about this version is having QCScheduler inside of Quantum. There are various tabs to make it easy to see what reports are scheduled, Styles, Templates and there is a new Calendar Tab with a calendar view. Selecting a day will show you all the reports scheduled to run on that day.

Customs / Bonded Warehouse. The customs/bonded warehouse feature was not fully available in previous 10.8 versions. I was told it is complete in this version. Unfortunately I cannot find any documentation in the help file for it yet. I also don’t see release notes for 10.8(?) either.

[Jason Cordoba]

AJ Walter was using SalesForce, and then Microsoft Dynamics back when I joined the company 2 years ago. They had a one-way API connection to it. Quantum -> Salesforce/Dynamics.

It was my recommendation to bin the product/setup.

Below are the top 5 reasons:

1. Quantum’s Contact Manager (CRM) could do everything they were doing in salesforce and dynamics. Everyone is much happier using one program. To get a web interface for users on the road, use Quantum Dashboard. This displays sales activity and you can enter contact data into the dashboard from the web, will update the quantum database.

2. Data integrity. Users would add data into these 3rd party programs but not update Quantum. Data such as rolodex entries, trip report visits, companies and so on. But then Quantum wouldn’t have the most current data.

3. License issues. Not everyone had a license to log into these products, the expense to have all the employees with a login wasn’t practical. But the issue came about when someone needed information that was not in quantum, they couldn’t get it.

4. Reporting – Users were making reports from these products, and others were making the same type of report from Quantum and the data was incorrect. Or worse, someone would need a report but the data they needed was in both Quantum and salesforce or Dynamics. We were not able to achieve real time reporting with the data in various places.

5. We saved an annual 50-100k USD a year. The data wasn’t hosted with us so we had storage/server fees, license fee’s, support fee’s and upgrade fee’s and monthly subscription costs.

[Jason Cordoba]

Hi Nicholas – when you edit any of the users profiles, consider using the ‘Start Date’ (START_DATE) to record when the employee starts. When the employee leaves, we populate the ‘end_date’ as well.

Then you can pull a report based on this field.

We currently do this a AJW.

[Jason Cordoba]

You might not need to disable triggers, just add in the SQL update statement: closed_update=’T’

Example:

Update consignment_codes set cnc_auto_key=’1234′, closed_update=’T’ where cnc_auto_key=4321

That should get everything out of the consignment and into the new one you want, then you could delete the old, empty one like john suggested.

[Jason Cordoba]

Hi Paul, would you be able to send me this document as well if you still have it?

Thanks!

Jason.cordoba@ajw-aviation.com

[Jason Cordoba]

Hi Anthony

There is no merge feature. I asked CC for a ‘historical’ option, just like there is one in warehouses. Received tracker

[Jason Cordoba]

Thanks for your help on this.

I could set 100% discount on the accounts but it is risky for when we do need to charge them and we cannot rely on the user to take off the 100% discount in those situations.

Setting the FOREIGN_LIST_PRICE =0 seems to be the answer. it keeps the Price on the master part, and does not bring it over and pre-populate the sales order with it.

This is a ‘work-around’ and until we can put in a custom programming request. I believe this should be controlled with a global flag in the SO or Inventory setup to have it do this.

Thanks

JAson Cordoba

[Jason Cordoba]

Hi Henrick, yes. I get a foreign key violation error. Integrity constraint (QCTL.FK.ACT.AMR) violated – child record found.

The child record it is referring to is the AC_METER but we don’t put any data in any of the fields that belong to that table.

The other child records are the companies table link and the model table that is linked.

it will not let me delete the company or model that is linked to the aircraft.

I cannot delete the links, if I can’t delete the links I can’t delete the aircraft. And the one I am trying to delete has no transaction history attached to it.

—

To recreate this, just add a new aircraft and link a company, a model (B727) put in a tail, serial number, reg and that’s it. now you won’t be able to delete it using the delete button in the browsing aircraft window.

[Jason Cordoba]

Hi Abigail,

I use this website:

http://www.w3schools.com/xsl/tryxslt.asp?xmlfile=cdcatalog&xsltfile=cdcatalog

In event manager, i export the two files, and then copy and paste the data into this website.

Here i can make my edits and see the results.

i then copy/paste the info back into the two files and load back into event manager.

In order for the colours in your template to change, or your logo to appear, you need to add the color and logo into event manager by editing the template and selecting the XML Settings button.

https://drive.google.com/file/d/0B8siQOdZqkMmTjhxb3pRdnhOaEU/view?usp=sharing