[Craig Golding]

G’day Krista,

We use the following SQL for the basis of a Crystal Report in Event Mgr. It grabs the stock with expiry dates occurring in the next 31 days but you can alter that pretty easily to suit. Also included is location and warehouse, stock line etc…Cheers mate.

select

st.PN,

st.DESCRIPTION,

(select loc.location_code from qctl.location loc where st.LOC_AUTO_KEY = loc.loc_auto_key) as “Location”,

(select whs.warehouse_code from qctl.warehouse whs where st.whs_AUTO_KEY = whs.whs_auto_key) as “Warehouse”,

st.QTY_RESERVED,

st.QTY_AVAILABLE,

st.REC_DATE,

st.EXP_DATE,

st.STOCK_LINE,

st.CTRL_NUMBER,

st.CTRL_ID,

st.RECEIVER_NUMBER

from

qctl.stock st

where

st.EXP_DATE IS NOT NULL and

st.QTY_OH != 0 and

st.EXP_DATE <= sysdate +31 order by st.exp_date

[Craig Golding]

We have Screen Editor, not Designer. For now I’ve just added a screenmsg reminder for users to check.

[Craig Golding]

Thanks Nadim, I modified as per below to suit. I should have said in my original post that the Inspector sign off field ‘seemed’ like a boolean field – I didn’t see the ‘S’ ! I haven’t seen the ‘GetData’ command before, do you have a link that explains the syntax and usage for it? Cheers.

var

sMecReq : string;

begin

sMecReq := GetData(‘WO_TASK’, ‘WOT_AUTO_KEY’, ‘MEC_REQ’, WO_TASK[‘WOT_AUTO_KEY’]);

IF (sMecReq = ‘T’) and (WO_TASK[‘QA_REQUIRED’] = ‘S’) then

regDupSig.visible := true

else

regDupSig.visible := false;

end;

[Craig Golding]

That’s interesting Jason. Do they count the max users connected at any time per day, unique users per day, users at a particular time or some other method? Cheers.

[Craig Golding]

Mike Carey wrote:

I am very interested in this as well. And how would you assign the correct cost on each part in the kit? I played around with using a Stock Issue and a BOM that defines the kit, but didn’t have enough time to spend working it out.

Same here Mike – Assigning costs to kit parts is a big one for us too.

[Craig Golding]

That would be a handy report Krista. I need a similar one that shows open SO’s and any related Invoices, PO’s etc

Would you happen to have something like that Jake or anyone else?

[Craig Golding]

Thanks John, It looks quite useful for the NSN side of parts searching and info. Thanks for the feedback mate.

[Craig Golding]

Thanks for that Mike. I think I’ll go the sql route as it will be quicker I reckon.

[Craig Golding]

Thanks Nadim, that would be great. As for our users, I’ve told them they can hover their mouseover the image and scroll out to zoom out. It’s not a permanent solution but works for that moment. Cheers.

[Craig Golding]

Thanks Frank. I got a good explanation from Nick at CC too. Cheers.

[Craig Golding]

Hey Mike, the forum isn’t letting me upload the file.

“Unable to upload file Job Cards_A4.rtm: File creation denied for the following reason: “InvalidExtension””

Can I email it to you? Thanks again for all your help.

[Craig Golding]

Ok, I still have a weird problem with this form. The form is picking up the correct details for the calibrated tools, but in AC Maintenance WP>GLOBAL>PRINT>PRINT JOB CARDS and selecting multiple cards to print, the tools are appearing on every job card, even those with no tool records. If I print a single job card, it all works fine.

[Craig Golding]

Ok, it’s working guys. What was happening was when previewing the form with the new code, the WO task it was using had tools checked out and back in but for some reason the details weren’t appearing in the SN and cal date fields. When I saved the form and used it on a different WO task, the correct data is presented.

Why it isn’t picking up the data for just that one task is strange and I’ll look further into it.

Thanks again for your time and help guys – it’s very much appreciated.

[Craig Golding]

No change guys, still nothing in the serial number or calibration date fields. I’ve compared the details section and memo field settings to other working ones and things seem ok there. Is there something basic I’m overlooking here?

[Craig Golding]

Hey Nadim and Mike, the tools were checked back in and the full code is below. What I find frustrating is that the original code I posted is used on other forms and it works just fine (using ‘WTT.WOT_AUTO_KEY = ‘+ WO_TASK[‘WOT_AUTO_KEY’];). Does this lead us to believe that the original problem lies elsewhere and not the select statement?

Latest code:

var

q : TOracleDataset;

begin

MemToolSN.lines.clear;

q := TOracleDataset.Create(nil);

q.SetSession;

q.Sql.text :=’Select STM.PN,STM.DESCRIPTION,STM.SERIAL_NUMBER,STM.INSPECT_DUE_DATE from STOCK STM, STOCK_RESERVATIONS STR, WO_TASK_TOOLS WTT where ‘+

‘STM.STM_AUTO_KEY = STR.STM_AUTO_KEY and ‘+

‘STR.WTT_AUTO_KEY = WTT.WTT_AUTO_KEY and ‘+

‘WTT.WOT_AUTO_KEY = ‘+ WO_TASK[‘WOT_AUTO_KEY’];

q.Open;

if (q.FieldByName[‘PN’].AsString <> ”) and (q.FieldByName[‘DESCRIPTION’].AsString <> Null)

Then

while not q.eof do begin

MemToolSN.lines.add(q.FieldByName[‘SERIAL_NUMBER’].AsString);

{MemoTools.lines.add(q.FieldByName[‘DESCRIPTION’].AsString);

MemoTools.lines.add(q.FieldByName[‘SERIAL_NUMBER’].AsString);

MemoTools.lines.add(q.FieldByName[‘INSPECT_DUE_DATE’].AsString);}

q.next;

MemToolSN.visible := True;

end

else

MemToolSN.visible := False;

q.Free;

end;

[Craig Golding]

Hey Mike, Yeah – below is a copy.

‘WTT.WTT_AUTO_KEY = ‘+ WO_TASK_TOOLS[‘WTT_AUTO_KEY’];

[Craig Golding]

Hey Nadim, thanks for your help, although now there is no data showing. The part # and description are still okay but there’s nothing for the serial number and cal date. Doesn’t the line you suggested equal itself as WTT = WO_Task_Tools earlier in the statement? Is that correct? Thanks mate.

[Craig Golding]

Hi Nadim,

I believe it’s based on the STD Work Order Traveller A4 form but it has been modified before my time to include the serial number with the tools. I’ve attached a couple of pics of the Form Designer screen and print preview of the the Tools section. I’ve tried various setting for the memo field (stretched and static height as you can see in the pics), and design section.

Thanks Nadim.

[Craig Golding]

Thanks Mike, that worked fine. Much appreciated mate.

[Craig Golding]

Hey Mike – Thanks for the reply. I tried unchecking the ‘visible’ box before posting, I should’ve mentioned that. When I do uncheck it, all the totals drop to zero. Any further ideas?

My CReports knowledge is still in its infancy but I’ll work on a SQL report based on that table and view.

[Craig Golding]

Hi Marineusa,

Thanks for the reply. The reason I asked is that we had the same problem in v10.9.27 and also now v10.10.5. Hopefully we can find a solution.

Craig

[Craig Golding]

Hi Marineusa, what Q version did you have before upgrading? Thanks.

[Craig Golding]

G’day John, thanks for the reply. I guess in the end it will end up as a combination coaching users to create their own events and some backroom work to fill in the gaps. We have a training dB to experiment with to get things right before rolling it out to the live one. The module is very expensive so going down the EM path is still not a given and I might end up doing it all in the backend…

Cheers mate.

[Craig Golding]

Thanks for the feedback guys. Most of the tasks I would automate revolve around stock levels, end of day labour reports, Work Pack task statuses and progress etc.

I see some of the included features will cover those but will create custom ones to retrieve data on a schedule and present it in a suitable format for the recipients.

We wouldn’t be using it to email customers at all, just internal personnel. I figure that if we go down the EM path, I’ll analyse how it works and go from there. I have a strong background in SQL so that will help a lot but some training wouldn’t go astray. I’m hoping to make it to the Quegroup conference this year and use the opportunity to talk with some experienced users.

Thanks again for your help. Advice from those in the know before purchasing saves a lot of heartache.

[Craig Golding]

Thanks for the honest feedback all, it’s very much appreciated!

[Craig Golding]

Thanks mate.

[Craig Golding]

Hi Jim,

We use a Canon MF8580Cdw with good results.

Cheers.

[Craig Golding]

Also, I’m pretty sure you’ll have to stick with 32-bit versions of Office apps if they need to interact with Quantum.

[Craig Golding]

Because our ‘List Price’ currency is usually different to our suppliers, we have to convert the supplier’s pricing to our home currency first, then import into the ‘List Price’ mapping. Eg: supplier provides a list in USD and we convert to AUD using MS Excel then import into ‘List Price’. Easier than using OCDIA I think.

I’ve suggested to CC that they add a ‘Home List Price’ field for mapping but haven’t seen it yet.

CG

[Craig Golding]

It’s great to see you are back Andre. The more the merrier!

[Craig Golding]

We upgraded from 10.9.27 to 10.10.5 a couple of weeks ago and haven’t encountered any major problems.

One thing we have noticed is that MobileTech sessions are not ending and you cannot kill them either, even with SYSDBA creds. We restarted the Q server on advice from CC but no change, they’re still there with the sessions timers ticking away. A few things were tried via screen share but were unsuccessful so I’m hoping the issue has been escalated (Ticket T11926).

[Craig Golding]

Hi Tara,

Thanks for the reply mate. We’ve checked the “Allow Tool Reservations for closed tasks” box and will see how that goes.

Cheers.

[Craig Golding]

Good Question Paul! Looking forward to hearing about other members experiences.

[Craig Golding]

Thanks mate…

[Craig Golding]

Thanks Nadim, that explains a lot. Cheers.

[Craig Golding]

Thanks David, I gathered from what I’ve read going through the forums that a combination of both is the best option, but it is good to hear first hand. Can I ask what version of CR you are using?

I’m pretty familiar with Oracle’s SQL Dev and agree, it’s a great tool for surfing the dB.

Thanks again David.

[Craig Golding]

Hi David,

Thanks for the reply. Do you create your Crystal Reports externally and then import them into Quantum or run them seperately? How does that work for you?

Cheers.

[Craig Golding]

That’s awsome Nadim, Thank you.

My SQL is pretty good but I lack references on the Quantum dB and what data sits where. I’ll pick it up over time.

Thanks again.

[Craig Golding]

Thanks for the replies everyone.

I exported [HKEY_CURRENT_USERSoftwareComponent Control USA, LLC.Quantum Control2k.0ToolBars] and compared it before and after modifying the Toolbar (Windows Bar specifically) using Notepad ++ with the Compare plugin (open source, very handy!)

It seems there are dozens of changes when you ad or remove even a single item so creating a backup to restore from is a great idea – maybe I should do that for every user before a Quantum upgrade.

I really hope CC can find a way to implement a bug fix for it. FYI, we are on 10.9.27.0

Cheers.

[Craig Golding]

G’day all,

Any word on a fix for this bug?

Tks.