[Mike Carey]

Jake- what ideas have you considered ? Can you describe your current process?

[Mike Carey]

Jesse- what is the “fix” that you use there ? I was thinking of a daily export that section of the registry using the task scheduler. Then the user could import the backup back in to fix the problem..

Our issue seems to be only the Window bar being turned off, so turning it back on is not that big of deal, just annoying.

[Mike Carey]

We see it happening every 2 or 3 weeks. We have about 12 users of Quantum. I have been attributing it to inadvertent keystroke combinations toggling them off, but maybe it is something else. I am going to figure out a way to trace and get notified when this happens, so that i can get notification and figure out what the user was doing. (or not doing)

[Mike Carey]

Jake- the Purchase_WO table is the link between WO BOM and PO_Detail. I use the following query to do just what you are looking for…

(select po_number || ‘ Due ‘ || To_Char(pod.next_delivery_date, ‘MM/DD/YY’)

from po_detail pod, po_header poh, purchase_wo pwo

where wob.wob_auto_key = pwo.wob_auto_key

and pwo.pod_auto_key = pod.pod_auto_key

and poh.poh_auto_key= pod.poh_auto_key

and pod.qty_rec < pod.qty_ordered) po_number_next_del

[Mike Carey]

i am not sure if this helps or not, but we installed Quantum on some tiny computer (Minix) that has very limited space on the C drive. We added an external F drive in the USB port and told Quantum to install there and it works fine no problem. The Oracle and Common Files still installed to the C drive.

[Mike Carey]

Brandon- we don’t use the shipping module, but i assume that you want to WO customer PO on each line item on the shipping document ? If so, the SM Detail wob_auto_key can be linked to the WO_BOM wob_auto_key, and then WO_BOM woo_auto_key links to the WO_OPERATION woo_auto_key, where you can get the customer PO.

The query looks like this:

select company_ref_number

from wo_operation woo, wo_bom wob

where wob.woo_auto_key = woo.woo_auto_key

and wob.wob_auto_key = (wob auto key from SM Detail)

[Mike Carey]

Hi Brandon… here is the SQL that is used to build the Report Order form..

For the Header:

select ROH.*, CMP.COMPANY_CODE, CMP.COMPANY_NAME, CMP.ADDRESS1, CMP.ADDRESS2,

CMP.ADDRESS3, CMP.CITY, CMP.STATE, CMP.ZIP_CODE, CMP.COUNTRY,

(select PRINT_STATEMENT from CURRENCY CUR where CUR.CUR_AUTO_KEY=ROH.CUR_AUTO_KEY) PRINT_STATEMENT,

(select DESCRIPTION from SHIP_VIA_CODES SVC where SVC.SVC_AUTO_KEY=ROH.SVC_AUTO_KEY) SHIP_VIA_CODE,

(select TERM_CODE from TERM_CODES TMC where TMC.TMC_AUTO_KEY=ROH.TMC_AUTO_KEY) TERM_CODE,

(select COMPANY_NAME from SYS_COMPANIES SYSCM where SYSCM.SYSCM_AUTO_KEY=ROH.SYSCM_AUTO_KEY) SYS_COMPANY_NAME,

(select RESALE_NUMBER from SYS_COMPANIES SYSCM where SYSCM.SYSCM_AUTO_KEY=ROH.SYSCM_AUTO_KEY) RESALE_NUMBER,

(select ACCOUNT_NUMBER from SHIP_VIA_ACCOUNTS SVA where SVA.SVA_AUTO_KEY = ROH.SVA_AUTO_KEY) ACCOUNT_NUMBER

from RO_HEADER ROH, COMPANIES CMP

where ROH.CMP_AUTO_KEY=CMP.CMP_AUTO_KEY

and ROH.ROH_AUTO_KEY = (insert ROH auto key here)

For the Detail:

select ROD.*, PNM.PN, PNM.DESCRIPTION,

(select CONDITION_CODE from PART_CONDITION_CODES PCC where PCC.PCC_AUTO_KEY=ROD.PCC_AUTO_KEY) CONDITION_CODE,

(select UOM_CODE from UOM_CODES UOM where UOM.UOM_AUTO_KEY = PNM.UOM_AUTO_KEY) UOM_CODE,

(select SO_NUMBER from SO_HEADER SOH, SO_DETAIL SOD where SOH.SOH_AUTO_KEY=SOD.SOH_AUTO_KEY and SOD.SOD_AUTO_KEY=ROD.SOD_AUTO_KEY) SO_NUMBER,

(select CORE_SERIAL_NUMBER from EXCHANGE E where E.ROD_AUTO_KEY = ROD.ROD_AUTO_KEY) CORE_SERIAL_NUMBER,

woo.si_number mo_number

from RO_DETAIL ROD, PARTS_MASTER PNM, WO_TASK WOT, WO_OPERATION WOO

where ROD.PNM_AUTO_KEY=PNM.PNM_AUTO_KEY

and ROD.ROH_AUTO_KEY = (insert ROH auto key here)

AND wot.wot_auto_key (+)= rod.wot_auto_key

and woo.woo_auto_key (+)= wot.woo_auto_key

order by ROD.ITEM_NUMBER;

[Mike Carey]

Brandon- for efficiency and performance sake, you should just select the field(s) that you need instead of all fields in the table. In this case, the Work Type table is small and only has a few fields, but with other tables, the performance impact on this report and other users will be noticeable. If you use “select *…” all the time on all your reports, over time you will put extra load on the server and network that is not needed.

So in this case, use “select description from…” instead of “select * from… If you use “select *…”

[Mike Carey]

Tim- the parameters are dynamic and different for every link.

Pietro- i need to have hyperlinks within a Crystal Report to an exe file- i don’t see how that article helps with this.

[Mike Carey]

Jim- take a look at the invc_detail table and you will it contains the sod_auto_key. So link the SO Detail sod_auto_key to the invc detail sod_auto_key and then the invc detail to the invc header to the get invoice number.

[Mike Carey]

Here is the piece of the code for the TAX_TOTAL field from the GET_WO_BILLING_HEADER function which builds that data pipeline for this report. It is pulling the tax total from the WO Quote Detail record. So maybe something is keeping it from being calculated there ?

NVL((SELECT SUM(FOREIGN_TAX_AMOUNT) FROM WO_QUOTE_DETAIL

WHERE WQH_AUTO_KEY = WQH.WQH_AUTO_KEY),0) TAX_TOTAL

I also found this in the help file in the Shop Control, Quote/Billing Option 2, Print Quote section. Maybe you need to use this document instead ?

Document

Should be STD WO Billing Group Quote/Invoice Document or STD WO/WP Quote/Bill (Taxes). If applying taxes to the billing, you will want to use the latter as this will print the tax on the invoice.

[Mike Carey]

Hi Lisa- this will pull the expiry date and image key for the image itself. Change the Vendor Approval to what ever you call your vendor approval code and the source_pk is the company cmp_auto_key

select doc_expiry_date, image_code, image_key

from image_list iml , image_codes imc

where source_table = ‘COMPANIES’

and imc.imc_auto_key = iml.imc_auto_key

and imc.image_code = ‘Vendor Approval’

and source_pk = 455

[Mike Carey]

If somebody has an old version of Quantum that includes this calculation in the report, they can post save and post that report here so that we can see the calculations in the code.

[Mike Carey]

Take a look at syntax in the last message i sent- make those 2 changes and you will be all set !

[Mike Carey]

It would be helpful if you post the actual error message.. but I think this will clear it up for you. Change the code to start like this: (you had var q:= TOracleDataset) and left off the begin statement

var q : TOracleDataset;

begin

q.SetSession;

[Mike Carey]

Jake- I see a couple of problems there. FIrst, on your SQL statetment, you need a space at the end of each line where you are continuing the SQL on the next line. Otherwise, the text is jammed together and you get SQL syntax error when you run the form. This does not show up as a compile error.

Second, it looks like you are mixing OnPrint events with OnGetText events.

if you are adding to a memo field, then you are using a OnPrint event, and the syntax to add a single line to a memo field is

memoLongDescr.Lines.Text := (some data value)

if you are adding multiple lines to the memo field, you do it like MemoManuals.Lines.Add(some data value);

Since this is a SO number, there isn’t a need for a memo field, use a plain label field. You can do this in a OnGetText event and use the Text := (some data value) syntax to add the data.

Either way, the entire routine needs to start with

var q : TOracleDataset;

begin

Hope this helps !

[Mike Carey]

We have 10.9.38. I can see the tax items in the data streams for Wo, Parts, labor, Charges, Repairs, etc, but i do not see any calculations that use them in the report. What version did you use when you saw the calculations being performed ?

[Mike Carey]

Craig- not sure if this helps but i was rooting around and found this in a Receiver Reconciliation report package ( FUNCTION RR_REPORT) as part of the RR detail data being generated.

pod.QTY_REC_UC + NVL((SELECT SUM(p.QTY_REC_UC) FROM PO_DETAIL P, stock s

WHERE p.ROUTE_CODE = ‘V’ AND p.ORIG_POD = POD.POD_AUTO_KEY and s.stm_auto_key =p.stm_returned

and ( (s.rejected_line=’T’ and s.historical_flag=’T’and s.split=’T’) or (s.rejected_line=’F’ and s.historical_flag=’T’and s.split=’T’) or s.split=’F’ ) ),0)

— and (s.rejected_line<>‘T’ or (rejected_line=’T’ and historical_flag=’T’) ) ),0)

– nvl((select SUM(QTY_REC_UC) from stock where POD_AUTO_KEY = POD.POD_AUTO_KEY and rejected_line=’T’ and historical_flag=’F’),0)

) QTY_UNRETURNED_FINAL ,

Later on in the procedure, it is used again

V_QTY := R_POD.QTY_UNRETURNED_FINAL – least (R_POD.QTY_UNRETURNED_FINAL,R_POD.QTY_RECONCILED)

[Mike Carey]

Jim- this SQL returns the warehouse code in our system. there are 2 fields in the warehouse table for each code, perhaps you want to see the DESCRIPTION column instead of the WAREHOUSE_CODE column? Or maybe you have a more complicated physical location configuration than we do (we have 1 physical location with a few warehouses in it. )

[Mike Carey]

Hey Jim- post your SQL and we can figure it out..

[Mike Carey]

Jim- by warehouse location, are you referring to the stock line reserved to the detail lines of a SO ?

[Mike Carey]

Jiim- run this SQL in the interactive SQL in Quantum (or SQL Developer or OCRunner) and you will see that it does return all detail lines for a RO. Your vba in your Excel is probably not looping through all the records being returned ? post your vba here and i can take a look.

[Mike Carey]

Jim- here is the SQL to do what you are looking for; i put my changes in lower case. the pnm_modify is a pnm_auto_key which must be matched to a parts_master using a 2nd reference to that table.

SELECT RO_HEADER.RO_NUMBER, RO_HEADER.OPEN_FLAG, PARTS_MASTER.PN, parts_master2.pn as pn_modify

FROM QCTL.PARTS_MASTER PARTS_MASTER, QCTL.RO_DETAIL RO_DETAIL, QCTL.RO_HEADER RO_HEADER, QCTL.parts_master parts_master2

WHERE PARTS_MASTER.PNM_AUTO_KEY = RO_DETAIL.PNM_AUTO_KEY

AND RO_HEADER.ROH_AUTO_KEY = RO_DETAIL.ROH_AUTO_KEY

AND ((RO_HEADER.OPEN_FLAG=’T’))

and parts_master2.pnm_auto_key = ro_detail.pnm_modify

[Mike Carey]

Jim- can you post your query in here so I can take a look at it ?

[Mike Carey]

Hi Jim- in the RO_Detail table, pnm_auto_key and pnm_modify point to the part and modify part in the parts_master table.

[Mike Carey]

What about using Screen Scripter code to only make the field required RO and WO ?

[Mike Carey]

Good input, John, thank you. The Minix devices were purchased outside of my control. They are in the APU build area to be used for displaying manuals, and reference lookup.

I did a workstation install of Quantum, here is what I found.

While you can select the install location for the Quantum modules, the other components are hard coded to install on the C drive. (Oracle, BDE, etc).

The space needed was about 2-3 gig total both drives, so that was not an issue.

Running Quantum, the performance is reasonable and not much different from other workstations around the company.

I used Winaero WEI Tool to get a benchmark performance on the Minix units and they scored in the same range as our other, mostly 3+ year older, workstations. This tool gives you the old Windows Experience Index measurements.

[Mike Carey]

Thank you for the great feedback ! Does Quantum install need to be done to the C drive (where Windows is located) or can it be on a secondary D drive ?

[Mike Carey]

Hi Pat.. perfect timing ! I am currently working on such a function with our system. We do not have Event Manager, which would do this for us. I have worked out and test a proof of concept for this and will be testing and implementing very soon.

[Mike Carey]

Updated SQL- this shows updates to templates and templates being applied to the users.

select sysur.user_name, adt.descr, adt.stamptime

from audit_trail adt, sys_users sysur

where adt.stamptime > = sysdate -30

and ((adt.source_table = ‘STP’) or (source_table = ‘SYSUR’ and source_field=’STP_AUTO_KEY’) )

and adt.sysur_auto_key = sysur.sysur_auto_key

order by stamptime desc

[Mike Carey]

Stephen

Changes to the templates and user security are logged in audit.trail table. A simple query to show all template changes in the last 30 days is:

select sysur.user_name, adt.descr, adt.stamptime

from audit_trail adt, sys_users sysur

where adt.source_table = ‘STP’

and adt.stamptime > = sysdate -30

and adt.sysur_auto_key = sysur.sysur_auto_key

[Mike Carey]

In the RPT_AP_PKG.FUNCTION GET_1099, i found this code. This function is called by the some other packages (SPR_1099) to build the data stream to print. The code below is towards the bottom, after setting up all the fields to be printed. There is some special sorting going on, and accounting for the fact there are 2 vendors per page (in the section below this one). The fields are all set up and then rows are added to cursor 3 times, hence the 3 copies.

Changing this code would not be trivial, plus altering packages is against the SMA agreement with CC. I would create your own copy of these packages and functions, modify and add them to your own version of the 1099 CR.

–TS – this will suspend each vendor 3 times and set the sort order to be

–venor1-venor2-venor1-venor2-venor1-venor2-venor3-venor4-venor3-venor4-venor3-venor4 etc.

IF I = 0 THEN I := I + 1; ELSE I := 0; V_ITEM.SORT_BY := V_ITEM.SORT_BY-4; END IF;

V_ITEM.SORT_BY := V_ITEM.SORT_BY + 1;

ADD_ITEM;

V_ITEM.SORT_BY := V_ITEM.SORT_BY + 2;

ADD_ITEM;

V_ITEM.SORT_BY := V_ITEM.SORT_BY + 2;

ADD_ITEM;

[Mike Carey]

Jesse- i wanted to make a report showing the stock line history for that stock line series. That is, showing a stock line from when it was purchased, sent out on repair, added to a work order, etc..

[Mike Carey]

I could not see how the 3 copies where being printed in the Crystal Report- where is the command or parameter that does this ?

[Mike Carey]

What kind of mobile applications are companies developing and what Quantum data / functionality are you providing in the app? I am looking for ideas for our company.

[Mike Carey]

This seems like a design flaw, i can’t believe they allow this to happen. It seems like not too difficult of a software change, since they do this correctly in all other modules.

Support said simply, working as designed, submit a feature request, which I did. They also said that this likely would be a very low priority and probably will never be changed.

[Mike Carey]

Craig- the Receiver Reconciliation / Deferred Receiver is part of the Accounting Module, which is an optional module. There is information about it in the help window, but not on the CC website. Hope that helps!

[Mike Carey]

Hi Abigail– not sure if you have found a solution to this or not, but I found this article that offered suggestions and links.. One person also indicated that the 12g driver worked for them..

https://social.msdn.microsoft.com/Forums/en-US/a274979b-33a0-4042-af4d-dff37c99bef0/64-bit-microsoft-odbc-driver-for-oracle?forum=adodotnetdataproviders

[Mike Carey]

We have had very good luck with the Brother printers like this one on Amazon. Our shipping dept uses this and it doe the duplex scanning and copying. We have several other Brother printers and scanners in use around the facility and have had no problems at all. https://www.amazon.com/Brother-MFCL2750DW-Monochrome-Wireless-Replenishment/dp/B0763X6TCW/

[Mike Carey]

Anthony- thank you.. I restarted my Quantum and it stopped giving the modal error.

[Mike Carey]

Leo- we have several exchange 365 accounts, hosted by Godaddy. They all use Outlook as their email client. Quantum emails are sent out via Outlook and there is really no difference or set up changes that we had to make for these users. Not sure if this helps you or not..

[Mike Carey]

Yes they do assuming that you set up those accounts as replaceable segments. There is a section in the help file about setting up the segments and how they work.

[Mike Carey]

Terri- we do this using replaceable segments in the account setup along with different PO number logs. Basically the number log is chosen by the user when creating the PO and each number log sets the different segment value. For example CPO number log (current PO) would set the segment to 1, FPO (future PO) would set that segment to 2. So the inventory account is set up as 1200-? where the ? is the replaceable segment. This works for inventory, WIP, Sales, etc for the various modules (PO, WO, SO, etc). We actually use 2 levels of segmentation and it works really well.

[Mike Carey]

This looks like a bug in the software. It happens on our 10.9.38 version as well. Have you reported it to Component Control ?

[Mike Carey]

What would you want it changed to ? Is it a fixed name or does it require user input ?

[Mike Carey]

Create the field on the form for the term code. Create an OnGetText event handler and use this code. It will pull the term_code for the company in the work order header

var

qc : TOracleDataset;

begin

qc := TOracleDataset.Create(nil);

qc.SetSession;

qc.Sql.text :=’select term_code from companies cmp, term_codes tmc where cmp.tmc_auto_key = tmc.tmc_auto_key and cmp.cmp_auto_key = ‘+ WO_OPERATION[‘CMP_AUTO_KEY’];

qc.Open;

Text := qc.FieldByName[‘term_code’].AsString;

qc.Free;

end;

[Mike Carey]

John- Does the form print when you select the STD form from the print settings ?

how did you create the revised form ? Did you open the STD version of the form and then do a “Save As” ? I have seen this error when I didn’t copy the STD form to a our own revised form name (we change the STD for ATS, our company abbreviation). I believe this error means either that the data pipeline in the report doesn’t match what is being sent to it, or that you have crossed up some entries in the forms designer report tables. I would suggest that you start over, open the STD form, do a Save As, then modify the Saved as form again with your changes.

[Mike Carey]

Tammy- what is the error or issue when you run the report ? what report parameters are you using ? You can post screen shots here (don’t include any sensitive data)

[Mike Carey]

Tammy- which version of Quantum did you upgrade to ? Does Component Control have an idea if this is a data or software issue?

[Mike Carey]

William- does this give you the data you are looking for ?

Select POH.PO_NUMBER,

sum((pod.qty_ordered – pod.qty_rec) * pod.Unit_cost) cost_rem

From PARTS_MASTER PNM

Join PO_DETAIL POD ON POD.PNM_Auto_key = PNM.PNM_Auto_key

Join PO_HEADER POH ON POH.POH_Auto_key = POD.POH_Auto_key

Where POH.OPEN_FLAG=’T’

and POD.QTY_ORDERED>POD.QTY_REC

group By po_number

order by po_number