dhope
Forum Replies Created
-
My Event Manager frequently gets stuck. I have to manually kill the java process on my server and then restart the 3 scheduled tasks: QuantumEMGRCrystalRunner, QuantumEMGRMailer, QuantumEMGRRunner
-
Rob, I know that you will run into an error if you try edit a parts master and set a non-serialized part as serialized if there are any stocklines of that part with QTY > 1, since a stockline can only have one SN.
-
Duane, I’m guessing that if you look in your WO billings at the lines that pull blank PCC’s with the above method, you’ll find that they were manually added to the billing (or quote that was converted to a billing) instead of being pulled from Add/Items from WO. That would cause the WOO_Ref to be null
-
Likewise, AEX is our customer’s requirement, not ours. If anybody knows of a Quantum – TRAX bridge I’d be interested.
-
Mike,
It sounds like you are trying to get more information on the data source itself as well as the code to structure the forms. The data sources are hard-coded and pull from oracle packages. You can view them using OCRunner and copy/paste into a text file and use something like notepad++ to read later. For instance, to see exactly what fields are pulled into the WO Quote/Billing form you have to look in Package Body RPT_WO_PKG
The header info is pulled in: FUNCTION GET_WO_BILLING_HEADER
-
Brian, the customer that we use AeroRepair for requires daily updates of units received and shipped (Wheels and Brakes, so 50+ each way per day). In order to avoid having to make every entry manually using the AEX website interface we use the bulk update feature that allows us to download an excel listing of all open orders. I made a couple custom Crystal Reports to pull the data on Work Orders and Shipping Orders created for that specific customer which are run by the responsible clerk daily and exported to Excel. I wrote a vbscript macro to parse the file downloaded from AEX with the Received and Shipped sheets added from my crystal exports and update the relevant fields so that it can then be re-uploaded to AEX.
This has the disadvantage that when AEX makes changes (like earlier this year) I have to change my reports and macro.
Quotes and receiving discrepancies still need to be entered manually.
-
WO_BOM contains the bill of materials for all work orders, linked to given work orders in WO_Operation by WOO_Auto_Key, SpecificTasks on Work Orders in WO_Task by WOT_Auto_Key and part numbers by PNM_Auto_Key
-
There is another table called Company_Rolodex that links Rolodex entries to Companies by listing RDX_Auto_Key and CMP_Auto_Key
It looks like this is to allow there to be a single Rolodex entry for any given person and then they can be attached to multiple companies.
-
Nice to hear, thanks.
I just turned it on for myself to start with and it is certainly convenient.
-
I have one user that has this happen, the window bar disappears and not only has to be re-enabled but then reset as well. She is also our prime user of Sales Orders and CQ’s. I’ve actually swapped out her physical PC and had the problem re-occur for her.
-
Jason, what version were you upgrading from? I had a similar issue when upgrading to a late 10.7 build where I had to run an update on Crystal on every machine.
-
There is an enhancement in (I believe) 10.8 that allows you to flag customers as PMA Parts Disallowed and flag your parts as PMA or not that would deal with that specific concern.
-
Assuming you mean for the US:
https://hts.usitc.gov/?query=aircraft
Highlights would be (for civil aircraft):
New Tires: 4011.30.0010
Retreaded Tires: 4012.13.10
Propellers: 8803.10.0030
Undercarriage and parts thereof: 8803.20.0030
Other Parts: 8803.30.0030
-
We use AeroRepair for one of our airline customers as well; I would love for an EDI solution instead of the pair of Crystal Reports and set of Excel macros that I have to maintain for the daily status updates.