[0 Archived User Content]

Contact CC. They have an API that is required to utilize for accessing Docs & Images in V12.

[0 Archived User Content]

Thank you Tim & Craig. I’ll do a test and verify. We use the professional version to do the OCR work (granted you can’t trust it, just helps gets most of the data so you can copy and paste (with verification).

[0 Archived User Content]

To me it does link, it would have to be through the Purchase Management system. Have price lines assigned to the Vendor for that specific part / condition code.

In the help it has under Inventory Settings -> Options Tab: Automatically set price lines for PO. With this setting enabled, the vendor price line that matches the condition of the part on the PO automatically populates the cost field.

Record Pricing for One Vendor

Once you receive a response from the Vendor, you need to record the pricing into the system.

Click Global.

Double-click Vendor Utilities.

Double-click Record Pricing for One Vendor.

Double-click the specific vendor that you want. A window appears listing the items from the quote that you requested pricing for from the selected vendor.

5. Highlight the item number and click Edit. The Add Vendor Quote window appears.

NOTE: Refer to Chapter 26 – Vendor Quote Window – Adding a Vendor Quote for a description of the fields on this screen.

6. Enter the vendor’s price to you in the cost field, number available, condition available and delivery time as well as any other pertinent information.

7. You may also add Notes to the vendor quote for each part at this time.

8. You may Copy a vendor quote if you need to record pricing for different conditions or quantity price breaks. Once the vendor quote is copied, you may edit and change the specifics.

8. Click OK to save the pricing information.

9. Click the X to close the window.

If the cost of the line item has changed, a confirming message appears asking if you wish to recalculate the cost on the customer quote.

10. Click Yes to use the selected vendor’s cost or No to cancel.

[0 Archived User Content]

If you want to see what’s in the Audit Log Currently:

SELECT SYSUR.USER_NAME,

WOO.SI_NUMBER,

ADT.SOURCE_FIELD,

ADT.ORIG_VALUE,

ADT.NEW_VALUE,

TO_CHAR (ADT.STAMPTIME, ‘YYYY-MM-DD HH24:MI:SS’)

FROM AUDIT_TRAIL ADT

INNER JOIN WO_OPERATION WOO ON WOO.WOO_AUTO_KEY = ADT.SOURCE_AK

INNER JOIN SYS_USERS SYSUR ON SYSUR.SYSUR_AUTO_KEY = ADT.SYSUR_AUTO_KEY

WHERE SOURCE_TABLE = ‘WOO’

AND WOO.SI_NUMBER = ‘W12345’;

[0 Archived User Content]

I am not on Q12, but in Q10 there is a Insert/Update Trigger on WO_OPERATION that adds records to the audit log:

TIUD_WO_OPERATION BEFORE EACH ROW QCTL INSERT OR UPDATE OR DELETE ENABLED WO_OPERATION

IF INSERTING THEN

FOR r IN (SELECT audit_trail FROM QUANTUM) LOOP IF ((r.audit_trail = ‘Always’) or ((r.audit_trail = ‘By Record’) and (:NEW.TRACK_CHANGES=’T’))) THEN

V_ADT := QC_SYS_PKG.INSERT_AUDIT_TRAIL_STR(‘WOO’, :NEW.WOO_AUTO_KEY, ‘DUE_DATE’, ‘insert’, :old.due_date, :new.due_date);

V_ADT := QC_SYS_PKG.INSERT_AUDIT_TRAIL_str(‘WOO’, :new.woo_auto_key, ‘KIT_QTY’, ‘insert’, :old.KIT_QTY, :new.KIT_QTY);

V_ADT := QC_SYS_PKG.INSERT_AUDIT_TRAIL_str(‘WOO’, :new.woo_auto_key, ‘QTY_SPARE’, ‘insert’, :old.QTY_SPARE, :new.QTY_SPARE); END IF; END LOOP; END IF;

It would be easy enough to add your own line that would add the field you wish to track. You just have to note the change to the package so in the future when you update you re-add your specific code.

[0 Archived User Content]

When you do the unknown receipt, could Quantum generate a label that you could stick on the item (so you can visually see it) and make it easier to ship out?

That way it would be a stock line and get into stock line history so 3 months or 4 years later when they call asking “Hey, we sent you this by mistake” you can still find it in the Inventory Control Model without much fuss.

[0 Archived User Content]

Two guys who could do this correctly for you:

Pietro Race pietrorace@framici.com

Nadim Ghazzaoui nadim@forward.aero

Both do Quantum consulting and no how to bullet proof it for future upgrades or at least help you understand post-upgrade requirements

[0 Archived User Content]

Why not fix the Oracle trigger so it logs the fields you want to keep track of in the audit log?

Granted if you are not comfortable doing database admin, CC I’m sure could do it for you or Pietro could no doubt. It really isn’t that hard, you have to track your changes so when CC upgrades you you can re introduce your changes.

[0 Archived User Content]

I did a fresh Quantum 10 install on Windows 2019 and see that error message. 32-bit ODBC driver is installed. Works via Crystal Reports.

So you want the 64-bit ODBC driver for 64-bit office?

I ended up uninstalling 64-bit office and put 32-bit in it’s place to get other issues resolved.

[0 Archived User Content]

If you like AirPartsNow.com they would love to help you. They seemed eager to add AeroXchange integration to their platform.

I bet they could do it. Granted they are a subscription service so may not be practical for you to consolidate RFQs into their system.

[0 Archived User Content]

I did register those and got other error messages, so moved on by back tracking to 32-bit.

Did the reboot (a few times after registering) and no not terminal server for this user.

[0 Archived User Content]

I just install InstantClient 12.2 and it works like a champ.

Granted it consumes a Quantum User License per connection. If you are doing a web interface you have to get the correct Oracle License (which is super expensive) on top of Quantum licenses.

[0 Archived User Content]

I’ll be honest, I try to do DevOps with incremental improvements. I often times do giant leaps… sometimes I stick the landing… other times it requires a quick trip to the ER.

Hopefully you guys can pull it off without a trip to the ER.

[0 Archived User Content]

Why not create a master part: “RETURN CUSTOM PART” and then receive that part into a stock line and then ship that part back out via $0 sales order / invoice?

And ahve some pretty labels made up: CUSTOMER PART DO NOT TOUCH or something on it… so people don’t take it apart on their bench just in case?

And make sure it’s a $0 stock line?

[0 Archived User Content]

I have: File Version 7.1.5.3. Size 3.36MB dated 4/30/2016 12:55 AM and 8.26 MB for the 64-bit version (Same version and date)

[0 Archived User Content]

Why not sub out the work (MRO services) and process it that way?

Sorry, not trying to micromanage…. just asking a question…

[0 Archived User Content]

It looks like you could easily make an Accounts Payable Import file and use the Import AP process in the help manual.

So create the SQL to build the commissions, review the output and correct, then import it into AP and you are “done”?

Or did you want to use Authorize.Net or some 3rd party to push payments to the commissions?

[0 Archived User Content]

I uninstalled Office 365 64-bit and installed 32-bit, reran the /regserver and no more issues. Quantum can email without delays or error messages.

[0 Archived User Content]

I do have the April 2016 edition of RwEasyMAIP32.exe and 64.exe

[0 Archived User Content]

So each AGENT in the AGENTS table is assigned to the COMPANY_AGENTS table (Company -> Global -> Agents)?

Grab the company from invoice header make a list based on the master AGENTS table on the commission?

Not sure why that is a problem. Seems simple enough.

I would say create an SQL that would build the commissions and verify it’s as expected.

Then make an AP record per entry that links to the Invoice Header … then allow the normal AP process to work?

Or is there something difficult here?

[0 Archived User Content]

I’m a fan of the User Defined Attributes as you can name them and they show up with out having to edit the screen vs. UDF fields.

If you edit a WO header, you will see an Attributes tab. In the system setup you can define USer Defined Attributes for WO Header.

You could easily make one: Monthly Labor Tracker as a checkbox

Then on any work order you can go to that tab and check it.

In SQL Developer or Event Manager, scan for any UDA that is checked and WO entry_date month / year is not current and set the WO status to the block activity.

[0 Archived User Content]

What WO Status do you have for these kinds of Work ORders where the Block Activity is true?

Seems like it would be pretty easy to check the year/month WO was created and if it’s not current change the work order status to one that has block activity??

[0 Archived User Content]

I would be tempted if the WO series is not special to use a UDF in the header of the “monthly” wo and schedule a job to auto close it and create a new one?

[0 Archived User Content]

Or you could update the trigger and throw an error if the sysur_auto_key is blah and the total is over X. That way Oracle will prevent it from happening.

[0 Archived User Content]

I would think you would have to create separate quotes. One for each kind of price group. We are also looking into this.

It looks like if you established “Price Lines” on the Parts Master side you could build up an “OEM” price line and a “PMA” price line for each part.

Granted I have not tested this. Then the Quote total would be off, which I have seen from multiple vendors when I ask them questions like this.

[0 Archived User Content]

True!

Barcode app auto-reconnects if you kill it’s session. You have to run it on the local system’s task scheduler to actually kill the EXE that is running…. which is a the way it is. You use to be able to kill sessions but Component Control realized a disconnected session is not cause for alarm but did the right thing and auto-reconnects.

[0 Archived User Content]

Yes, Mike it does not take into account any of the extra sessions created by crystal reports. Any ideas on enhancing the where clause to grab all non-crystal report sessions??

God bless you Mike. I went into SQL Developer and clicked on my schema. expanded the scheduler, right clicked on Job and then clicked NEW.

Mind blown! You no doubt are the man!

[0 Archived User Content]

I’m on a Mac so I cannot verify which keys to press to move “hidden” windows around. Sad to say. It’s pretty easy. Maybe even Alt-Tab or Windows Key-Tab to see all the windows and then drag Quantum to the monitor that is actually there.

We typically have 2 or 3 monitor stations and from time to time Quantum or other programs are running but “missing”.

Component Control tech support knows the exact key strokes to move the missing window back to a working monitor. I just didn’t take notes.

Mark Twain said: The dullest pencil is better than the sharpest mind.

[0 Archived User Content]

***** WARNING IF YOU USE CRYSTAL REPORTS THIS WILL KILL THOSE SESSIONS AS WELL ******

This will create a stored procedure (Quantum upgrades do not remove procedures in your schema). You can place in Event Manager that will kill any session > 1 per machine, user.

CREATE OR REPLACE PROCEDURE killmultisessions IS

CURSOR killthemall IS

with sessionstokill as (

select activesessions.*, row_number () over (

partition by machine, osuser

order by machine, osuser

) rn

from (

select v.machine, v.osuser, sid, serial#

from v$session v, sys_user_db_session s

where v.username = user and v.audsid = s.audsid

and v.program =’QCSYSMOD.EXE’

) activesessions

)

select sid, serial# from sessionstokill

where rn >1

order by machine, osuser;

BEGIN

OPEN killthemall;

FOR sessiontokill in killthemall

LOOP

execute immediate ‘Alter System Kill Session ”’|| sessiontokill.sid

|| ‘,’ || sessiontokill.serial# || ”’ IMMEDIATE’;

END LOOP;

END;

[0 Archived User Content]

That’s even better than fighting with windows. Could you export that regedit edit so that you could make it a desktop icon and it auto delete that entry to make it safer?

Granted I don’t allow users to edit the registry.

here’s a YouTube video on using the keyboard only to move windows back to a real monitor, you don’t even have to restart Quantum:

https://www.youtube.com/watch?v=s4OPX6Isl-U

[0 Archived User Content]

Do you want to change the WO #? Or is a work packet different?

[0 Archived User Content]

You can move the Quantum from the phantom monitor onto your real monitor via keyboard. We have that happen all the time.

https://www.howtogeek.com/661597/how-to-move-a-window-to-another-monitor-on-windows-10/#:~:text=Windows%2010%20includes%20a%20convenient,Windows%20%2B%20Shift%20%2B%20Left%20Arrow.

[0 Archived User Content]

I am not an expert in Quantum. I would think if you had a differnt GL account for expensed inventory, you could “zero” out the cost in your primary GL account by moving it to expensed inventory, and do an override on the GL for the parts master, then in the work order when it closes it would move it out of expensed inventory account and into the normal cost account. You could see what is expensed vs. regular inventory that would just show you how much is available. And it would record correctly when you post the work order.

Could be wrong, but I often am.

[0 Archived User Content]

We are on 10.11 for the moment and looking at 12 in our test environment. Is it possibly a security issue? Did CC add more protection and you now need to grant specific edit rights?

The release notes could perhaps shed some light if that is even a possibility?

[0 Archived User Content]

That’s what we did at my last company with Total-FBO. Just make sure on the Quote Header you fill in manually the company/contact info so when you do a search for quote you can see that field in the list.

Shouldn’t be too painful that way and alot simpler than creating a company record for random quotes.

Much cleaner than what I suggested.

[0 Archived User Content]

What states are you looking to have pre-populated? It’s by Zip code, so should be easy in Quantum to get the right one per Sales Order or Work Order Quote..

[0 Archived User Content]

https://www.avalara.com/ offers ‘free tax tables’. not sure if it’s really free, but you could script a job to go download them and auto import them into Quantum. That way if they change once a month or once a week in Texas you would be current.

So no need for a paid subscription if it contains the tax rates.

[0 Archived User Content]

I bet it would take less than 4 hours to write the program to do what you need. Pretty straight forward to do.

[0 Archived User Content]

I do understand. Quantum has: TAX_MATRIX, TAX_RATES, and TAX_TABLE which allows you to import from a source the various rates and summarize them. Here in California you have state, county, and city taxes that must be applied based on where you ship to as an example.

So it’s not just 1 number but a summer of 3 different rates. the summary would be assigned to the sales order detail or WO Quote detail.

Pretty straight forward. Granted a lot of details to get right to get it from a CSV into Quantum into a usable form for Sales Orders and WO Quotes.

[0 Archived User Content]

For us we would create a company record and then in contact manager log all the stuff and in Customer Quotes create all the various quotes for them.

Not sure if you bought the contact manager module or not.

You really don’t need contact manager, you could use User Defined Attributes for the Company and log all that stuff directly in that tab of the company editor and use Customer Quotes to track the quote process.

[0 Archived User Content]

I think as long as you have a CSV file you could easily import it directly into Quantum.

Yes, I know it’s Quantum…. but really? How hard could it possibly be?

https://www.vertexinc.com/

Looks like you could google “Sales and Use Tax subscription”, get some sample data from the provider you want to use and then write a simple script to import that sample data into Quantum. Once it works, go ahead and get a full subscription and script the job to run on a scheduled time and make sure you place the updated information where the script can grab it.

If you need any help, I can help you pretty basic stuff (all jokes aside).

[0 Archived User Content]

I think it would be fairly straight forward to bump the items you want to ship on the SO to a specific status.

Event manager or a trigger would print the pick ticket and bump the status to SHipping then you could ship it easily after you process the pick ticket?

[0 Archived User Content]

To me it looks like you would need to have a status that is Print Pick Ticket and then have a job that would auto print the pick ticket and change it to the next status code automatically (Event Manager or Trigger).

That way you would have an entry created in. SO_STATUS_HISTORY and know if it had been printed.

[0 Archived User Content]

So that field is use to flag if a pick ticket is needed, not to tell you if one has been printed or not.

[0 Archived User Content]

That field is used with WO Bill Of Material:

update WO_BOM set PRINT_PICKTICKET_FLAG = ‘F’ where WOB_AUTO_KEY = :OLD.WOB_AUTO_KEY;

and WO_BOM:

IF INSERTING OR UPDATING THEN :NEW.REQUISITION := NVL(:NEW.REQUISITION,’T’); :NEW.QUOTE_ITEM := NVL(:NEW.QUOTE_ITEM,’T’); :NEW.EXTRA_PART := NVL(:NEW.EXTRA_PART,’F’); :NEW.REWORK_FLAG := NVL(:NEW.REWORK_FLAG,’F’); :NEW.ACCUMULATION := NVL(:NEW.ACCUMULATION,’F’); :NEW.PRINT_PICKTICKET_FLAG := NVL(:NEW.PRINT_PICKTICKET_FLAG,’F’); :NEW.PRINT_ATA106_FLAG := NVL(:NEW.PRINT_ATA106_FLAG,’F’); :NEW.PRINT_TEARDOWN_FLAG := NVL(:NEW.PRINT_TEARDOWN_FLAG,’F’); :NEW.VALIDATE_ISSUE := NVL(:NEW.VALIDATE_ISSUE,’T’); :NEW.MANUAL_QTY := NVL(:NEW.MANUAL_QTY,’F’); :NEW.REQ_VERIFICATION := NVL(:NEW.REQ_VERIFICATION,’F’); :NEW.SCRAP_PERC := NVL(:NEW.SCRAP_PERC,0); :NEW.QTY_NEEDED := NVL(:NEW.QTY_NEEDED, 0); :NEW.QTY_PER_ASSY := NVL(:NEW.QTY_PER_ASSY, 0); :NEW.QTY_PURCHASE := NVL(:NEW.QTY_PURCHASE,0); :NEW.QTY_OSV_SUPPLIED := NVL(:NEW.QTY_OSV_SUPPLIED,0); IF :NEW.ACTIVITY = ‘System Exchange’ AND :NEW.QTY_NEEDED > 1 THEN QC_E_PKG.ERROR(‘Exchange must be a Qty of 1’); END IF; END IF;

[0 Archived User Content]

If I wanted to duplicate your kit, can you give some examples so I can do that in my training environment? It should be easy to figure out once the steps are understood. I don’t think we use Kits here.

Do I just put some 327 lamps and other components into a kit and some how get labor to build the kit? Then issue it to a work order or something?

[0 Archived User Content]

If you know the SQL to generate what you are looking for, you could add to the description (HISTORICAL) and do a NOT LIKE ‘%(HISTORICAL)’ to the SQL and it would exclude them from the report.

How are you generating your balance sheet? I bet it is fairly simple to figure out the SQL. I just don’t have access to that module but I know it has to be simple. It’s just oracle at the end of the day.

[0 Archived User Content]

We currently do not have the Quantum Aircraft Maintenance Module. At my previous job we used CAMPS exclusively to manage aircraft maintenance on our 125 fleet. It was great at generating the camp cards so the mechanic and inspector could sign off the work and return the aircraft to service.

We used Total-FBO for invoicing of all work done (our aircraft or managed aircraft).

I would stick with CAMPs, you cannot go wrong. If you are not dealing with 125, I would use Quantum for aircraft maintenance tracking (but would get a detailed presentation to ensure it tracks how you want to track things)

[0 Archived User Content]

Quantum is a ‘Chatty Cathy’ and if looses connection it throws an error instantly, I doubt it’s a connection issue.

[0 Archived User Content]

We use the basic email in Office 365 for multiple devices (scanners) and Event manager. Offfice doesn’t care….