nadim
Forum Replies Created
-
When the WO is created the Warranty flag is checked.
The reported defect is entered in a task labelled Customer Requirement which will always have sequence 5 (for report trapping purposes).
The Check/Test (or sometimes just a visual inspection) is done. Based on the result, an SDF combo box in the WO Header is updated to either “Approved†or “Deniedâ€.
Warranty decision reason is entered in Corrective Action.
Denied Warranty either:
Unit is repaired and the customer is billed.
Unit is BER and scrapped on-site. Customer is charged a scrap fee / if replacement is required then SO Exchange
Unit is BER. It is shipped back to the customer. Customer is billed an inspection fee
Approved Warranty either:
Unit is repaired and the customer is billed at zero.
Unit is under warranty from the OEM then a Main Component RO is created. Customer billed at zero.
Unit is BER but under warranty from the OEM then a Main Component Exchange is created. Customer billed at zero.
These last two scenarios were implemented at an OEM shop which initially sold the warranty unit as new. So it may or may not apply to you. But whether it is a sale warranty or a repair warranty, a WO is always created so as to centralise to retrieval of reporting data and track the labor for the evaluation.
WIP Transfer is done for the approved warranty work so as to show a separate line in the P&L.
A Crystal Report will capture all of the above.
Hope this helps.
Nadim.
-
In our case the issue comes from Quantum on Citrix. After opening a pdf and then clicking on another document image record, Quantum will freeze.
I applied both Paul’s and Cameron’s suggestions and now it works like a charm.
After downgrading and opening your first pdf in v11, you may get a Adobe DC plug-in error message. Just follow Paul’s instructions on plug-ins and IE as default browser..
Thanks everyone!
Nadim.
PS: After downgrading and having the user test, she got a message informing her of an upgraded and better Adobe reader with a “Click Here to Upgrade”. So make sure to disable auto-update in the settings.
-
Tony,
Do you really need the complete resultset from the view? What should make it faster is to filter by the GLP_AUTO_KEY.
Nadim.
-
Like this:
WHERE SO_DETAIL.ENTRY_DATE BETWEEN {?DATE1} and {?DATE2}
Then using the Parameter LIst on the right, create parameters DATE1 and DATE2. with Value Type Date.
Otherwise you can have the SQL command with no WHERE statement. It will fetch everything allowing you to use the Select Expert inside Crystal Report to create parameters. In this case the report will be slower as it will be the Crystal engine that does the filtering locally and not the Oracle server.
-
Abigail,
It is simpler and much much faster to let Oracle do the math and grouping for you.
Try this in Quantum Interactive SQL:
SELECT SALESPERSON.SALESPERSON_NAME,
NVL(SUM(SO_DETAIL.UNIT_PRICE * SO_DETAIL.QTY_INVOICED),0) TOTAL_PRICE,
NVL(SUM(SO_DETAIL.UNIT_COST * SO_DETAIL.QTY_INVOICED),0) TOTAL_COST
FROM SO_DETAIL SO_DETAIL
INNER JOIN SALESPERSON SALESPERSON
ON SO_DETAIL.SPN_AUTO_KEY =SALESPERSON.SPN_AUTO_KEY
WHERE SO_DETAIL.ENTRY_DATE >= TO_DATE (’01-04-2016 00:00:00′, ‘DD-MM-YYYY HH24:MI:SS’)
GROUP BY SALESPERSON.SALESPERSON_NAME
ORDER BY SALESPERSON.SALESPERSON_NAME
Does it return what you need?
If yes then just pop it in a Crystal SQL Command and you’re good to go.
Nadim.
-
Sally,
Quantum allows you to embed Crystal Reports in the Global/Print either:
Using Crystal forms (i.e. not Forms Designer)
Using Print Custom Crystal
The advantage is that the report will automatically use the transaction number for the module record from where you launch the report. So if you launch a parameter report from the WO module, then Crystal will automatically use the WOO_AUTO_KEY of the WO you’re in as the report parameter. For the Global/Print/Custom Crystal then you would use the usual RPT_CUSTOM_CRYSTAL settings group.
In the case of a Crystal forms such as Global/Print/Print Measurement, you would user RPT_WO_MEASURE settings group to be able to launch your report form this menu item.
Concerning RPT_WO_STATUS, I don’t think it works yet for Custom Crystal. In our release, the WO Status Report is still Forms Designer.
Nadim.
-
Tony,
What finally made it work after setting the jumper (which in my case was not factory set to USB) and after changing the legacy mode to 6, was to uninstall and reinstall Worth Utilities. It then worked.
Long shot but worth trying.
Nadim.
-
It is possible but can be a slow process for a large WP as you will need to add each JC individually.
In the WP, click on the JC and then click on “Create/Update Template” on the bottom menu bar. If the JC is not linked to a template, then you will be asked to create the Template. If the JC originates from a template, then the template will be updated.
For both cases, the next screen will ask you what items to create/update i.e.: skills, BOM, etc…
Hope this helps.
-
Anthony,
Two more items to add to Paul’s suggestions:
6- Make sure Legacy Mode is set to 6. This can be found in the LCD Options setup menu.
7- If using USB, you will need to open up the base station and set jumper 9 to USB. JP9 is located in the mid-upper right side of the PCB. The jumper should be covering the right-most 2 pins.
I will send you the picture by email as I can’t seem to find an option to insert an image into this message.
Nadim.
-
The issue most probably happens after upgrades when toolbars are modified. For example after a recent upgrade, a client lost some menu items in the PO module menu bar. Reset toolbar did not work.
To fix, I had him delete the “POMain†key and subkeys located in: “HKEY_CURRENT_USERSOFTWAREComponent Control USA, LLC.Quantum Control2k.0 ToolBars”.
-
Jason,
When you create a new aircraft, Quantum will add an airframe meter by default.
Assuming that the duplicate aircraft to delete:
1- Only has the default airframe meter
2- The meter has no flight entry
Then execute this script in Interactive SQL
———————
DECLARE
ACT NUMBER := 292; — ACT_AUTO_KEY
AMR NUMBER;
BEGIN
AMR := QC_AC_PKG.GET_AC_DEFAULT_METER (ACT);
DELETE FROM AC_METER WHERE AMR_AUTO_KEY = AMR;
DELETE FROM AIRCRAFT WHERE ACT_AUTO_KEY = ACT;
END;
———————
Replace the 292 above by your ACT_AUTO_KEY. Now if you have a big list of aircraft then it would be quicker to do a DIA script linked to a csv file.
Test in your training database first and use at your own risk and perils.
Let me know how it goes.
Nadim.