[Craig Golding]

Hey Matthew,

Thanks for the detailed feedback mate, that’s awesome.

Traceable To, Tag by and Tag date are critical fields for us too so it seems weird for an app that receives aviation parts into stock for repair or any other purpose to fail in this area.

Have you contacted Component Control about the module’s shortcomings? It would be good to know if they have the problems you mentioned in the pipeline for correction.

Cheers.

[Craig Golding]

Hey all,

We don’t use themes at all across the company, everything is default in that regard. I did have the user reset the windows to default setting and it seemed to resolved. Thanks all…really hoping these annoying errors are resolved in v12.x.x

[Craig Golding]

We are currently using it successfully for engineers to book out parts to WO/WP tasks. In the future we’ll be expanding use to the Shipping module.

[Craig Golding]

Thanks Erica – were they converted to Crystal Reports or a Report Builder form?

Ta.

[Craig Golding]

G’day Warren,

We use the latest free downloadable version of Acrobat Standard DC 64bit with no problems in Q v10.10.5. I haven’t had to change any settings as it seems to work ok straight out of the box so to speak.

Cheers.

[Craig Golding]

Thanks Henrik. Good info to know.

I did a search of the db and only found 3 triggers that mentioned QA_REQUIRED and only one of those for the WO_TASK table and new task, but it’s always good to put the question out there.

Cheers.

[Craig Golding]

We currently have this problem – the user was last logged in months ago and now his status is stuck at ‘Logging Out’

I’ve tried the suggestions above without any luck. When I search for his SID and Serial# his username is not listed. Our Quantum server has been restarted since his account was deleted (Inactive).

Any ideas how I can kill this session in order to re-activate the user?

[Craig Golding]

Thanks Mike.

We don’t use the Accounting module so reversing the cost side of the transaction isn’t so important.

I guess we could just raise another $0 PO for that one item and receive it in again correctly. I can’t see where that would muck things up further can you?

[Craig Golding]

Not as far as I’m aware Brian.

One option would be to template the original WP, close it and then start another with the number you require and apply the template.

Hope this helps.

[Craig Golding]

Hey guys,

Yeah – great query thanks Jason!

To solve the negative profit I think that because costs are technically a negative then the following line in the query might be better like below – just multiplying the costs by -1 then adding the invoice price. Does that work for you?

nvl(((parts_cost + labor_cost + misc_cost + osv_cost)*-1) +(

SELECT

inh2.total_price

FROM

invc_header inh2

WHERE

inh2.invc_number = invoice

),

0) profit

[Craig Golding]

Thanks Mike!

[Craig Golding]

Hey Mike, a screenshot of the code/calc window is below. I used sql developer to see the field data and copying that into notepad shows carriage returns – but in the correct spots ie: between para’s.

[Craig Golding]

No difference Mike.

[Craig Golding]

G’day Mike – The field is expanding vertically as required. Horizontally, the field is a fixed width. Thanks mate.

[Craig Golding]

Hi Anne-Marie, We are on Q v10.10.5 and MT v2.5 – I’m afraid I won’t be much help as I haven’t even seen those versions.

Might be best to get in contact with Component Control to see if they can sort it out…or…

Can anyone else help Anne-Marie out?

[Craig Golding]

Hi Anne-Marie,

What are the problems you are having? Can you explain the step and what versions of Quantum and MT you are using?

Thanks mate.

[Craig Golding]

I think DISTINCT … WHERE ROWNUM < 2 fixes it - give it a go but double check to be sure though ;-) (SELECT DISTINCT POH.PO_NUMBER FROM PO_HEADER POH, PO_DETAIL POD, PURCHASE_SALES PUS WHERE POH.POH_AUTO_KEY=POD.POH_AUTO_KEY AND SOD.SOD_AUTO_KEY =PUS.SOD_AUTO_KEY AND PUS.POD_AUTO_KEY =POD.POD_AUTO_KEY AND ROWNUM < 2 ) PO_NUMBER

[Craig Golding]

Fixed.

Turns out I missed a key work in Henrik’s post from 2012 – ‘Reset’ the user in security management. I tried everything else but…

Thanks all.

[Craig Golding]

G’day Mike – Yeah I saw that one and tried the suggestions to no avail. Thanks mate.

[Craig Golding]

So, does Component Control have anything to do with an OCDIA import? Is everyone else doing by themselves or is there files required from CC?

[Craig Golding]

G’day Jens,

Thanks heaps mate. I tried it out manually on our training dB and it worked really well – awesome!

[Craig Golding]

Thanks heaps Nadim. I’ll try to get in touch with Jens as the more automation the better I reckon. Cheers mate.

[Craig Golding]

Thanks Nadim. I sort of figured that it would be the best way to go. I’ve never used OCDIA before but will read up on it and test it on our training dB first.

[Craig Golding]

Hey Ryan and Nadim,

We have over 5000 stocklines in about 80 locations in the subject warehouse, so manually changing each stockline location would be unmanageable.

To complicate the situation, some location names will not change but the majority will, some stock in a current single location will be split up into other multiple locations (so you can’t just rename that old location to capture all of them).

I was thinking I could use SQL to do a record update on stocklines based on stm_auto_key from a whs/loc excel export but I’m unsure of the triggers/implications this may cause in the dB.

Thoughts?

[Craig Golding]

See pic

[Craig Golding]

Another good tip is to correctly size the logo before Adding it to your Document Images in Global settings. This can save a bit of mucking around with sizing (height, width) when designing forms down the track.

[Craig Golding]

Yep, agreed. Get the higher spec server hardware to do the heavy lifting.

[Craig Golding]

Yes, awesome thanks Nadim! I modified it to capture start times as well and also exclude archived users. I know you can do that in the CR but thought I’d weed them out up front.

Thanks mate!

WITH q

AS (SELECT woo.si_number,

wtl.sysur_auto_key,

SUM(wtl.hours) hours

FROM wo_task_labor wtl,

wo_task wot,

wo_operation woo

WHERE wtl.wot_auto_key = wot.wot_auto_key

AND woo.woo_auto_key = wot.woo_auto_key

AND wtl.start_time >= Trunc(SYSDATE) – 7

GROUP BY woo.si_number,

wtl.sysur_auto_key)

SELECT sysur.user_name,

(SELECT Nvl(SUM(hours), 0)

FROM q

WHERE sysur_auto_key = sysur.sysur_auto_key

AND si_number IN ( ‘WP001’, ‘WP002’, ‘WP003’, ‘WP004’ )) hrs_sum_a,

(SELECT Nvl(SUM(hours), 0)

FROM q

WHERE sysur_auto_key = sysur.sysur_auto_key

AND si_number NOT IN ( ‘WP001’, ‘WP002’, ‘WP003’, ‘WP004’ )) hrs_sum_b,

(SELECT Nvl(SUM(hours), 0)

FROM q

WHERE sysur_auto_key = sysur.sysur_auto_key) hrs_total

FROM sys_users sysur

WHERE sysur.wo_flag = ‘T’ and sysur.archived = ‘F’

ORDER BY sysur.user_name

[Craig Golding]

Hey Jason, that would be awesome, thanks heaps mate!

[Craig Golding]

Hi Jason, is that a Crystal report?

Sorry to butt in Carli.

[Craig Golding]

That’s great news Nadim. Do you know if part label scanning of a QR code with a mobile device using Mobile Technician works as well? Thanks mate.

[Craig Golding]

Hi Mike, I can’t seem to get that to work. I’m having trouble ‘summing’ the qty of parts with the same ctrl # and ctrl ID, then excluding them from printing if the sum = 0. Any ideas? Thanks.

[Craig Golding]

There’s a problem with my report and was hoping for a bit of help. If a part is issued to the BOM by mistake and then removed, my script still picks it up as there was an entry on the BOM that it existed historically with a qty > 0. The attached pics show the parts management and report output. My code is below but I’m having trouble excluding those parts where the qty issued eventually = 0. Any ideas?

var

q : TOracleDataset;

begin

memoPN.Lines.Clear;

memoQty.Lines.Clear;

memoDesc.Lines.Clear;

memoSN.Lines.Clear;

memoCtrl.Lines.Clear;

memoctrlID.Lines.Clear;

q := TOracleDataset.Create(nil);

q.SetSession;

q.sql.Text := ‘SELECT STM.PN, STM.DESCRIPTION, STM.SERIAL_NUMBER, DECODE (STI.TI_TYPE, ‘ + ”’I”’ + ‘, STI.QTY, 0) QTY_ISSUED, ‘ +

‘DECODE (STI.TI_TYPE, ‘ + ”’T”’ + ‘, STI.QTY, 0) QTY_TURN, STM.CTRL_ID, STM.CTRL_NUMBER ‘ +

‘FROM STOCK_TI STI, STOCK STM ‘ +

‘WHERE STI.WOB_AUTO_KEY = ‘ + WO_BOM[‘WOB_AUTO_KEY’] + ‘ and STM.STM_AUTO_KEY = STI.STM_AUTO_KEY’ ;

q.Open;

while not q.eof AND (q.FieldByName[‘QTY_ISSUED’].AsString <> ‘0’ do

begin

memoPN.Lines.Add (q.FieldByName[‘PN’].AsString);

memoQty.Lines.Add (q.FieldByName[‘QTY_ISSUED’].AsString);

memoDesc.Lines.Add (q.FieldByName[‘DESCRIPTION’].AsString);

memoSN.Lines.Add (q.FieldByName[‘SERIAL_NUMBER’].AsString);

memoCtrl.Lines.Add (q.FieldByName[‘CTRL_NUMBER’].AsString);

memoctrlID.Lines.Add (q.FieldByName[‘CTRL_ID’].AsString);

q.next;

end;

q.Close;

q.Free;

end;

[Craig Golding]

10.10.5 Mike.

[Craig Golding]

There’s an option on the print page to sort by sequence.

[Craig Golding]

I’ll give it a shot – thanks Mike!

[Craig Golding]

Ha ha! Thanks Mike! It’s the little things that can be the most frustrating. It’s working well now. Just one more thing if I can bother you – I have put the fields into a group based on the WO_BOM.SEQUENCE data field – do you know how to sort the group contents based on this data field?

[Craig Golding]

Thanks Mike and Nadim. The following code mostly works except that it only picks up the first stock line for each part displayed. As multiple stock lines (with different CTRL#/ID’s) can be issued for a single part, how can I make it show all of the stock lines? Thanks for your help guys.

var

q : TOracleDataset;

begin

memoPN.Lines.Clear;

memoQty.Lines.Clear;

memoDesc.Lines.Clear;

memoSN.Lines.Clear;

memoCtrl.Lines.Clear;

memoctrlID.Lines.Clear;

q := TOracleDataset.Create(nil);

q.SetSession;

q.sql.Text := ‘SELECT STM.PN, STM.DESCRIPTION, STM.SERIAL_NUMBER, DECODE (STI.TI_TYPE, ‘ + ”’I”’ + ‘, STI.QTY, 0) QTY_ISSUED, ‘ +

‘DECODE (STI.TI_TYPE, ‘ + ”’T”’ + ‘, STI.QTY, 0) QTY_TURN, STM.CTRL_ID, STM.CTRL_NUMBER ‘ +

‘FROM STOCK_TI STI, STOCK STM ‘ +

‘WHERE STI.WOB_AUTO_KEY = ‘ + WO_BOM[‘WOB_AUTO_KEY’] + ‘ and STM.STM_AUTO_KEY = STI.STM_AUTO_KEY ‘;

q.Open;

while not q.eof do

begin

memoPN.Lines.Add (q.FieldByName[‘PN’].AsString);

memoQty.Lines.Add (q.FieldByName[‘QTY_ISSUED’].AsString);

memoDesc.Lines.Add (q.FieldByName[‘DESCRIPTION’].AsString);

memoSN.Lines.Add (q.FieldByName[‘SERIAL_NUMBER’].AsString);

memoCtrl.Lines.Add (q.FieldByName[‘CTRL_NUMBER’].AsString);

memoctrlID.Lines.Add (q.FieldByName[‘CTRL_ID’].AsString);

q.next;

end;

q.Close;

q.Free;

end;

[Craig Golding]

Does anyone know if this was idea was resolved? If not – does anyone know of way to quote an existing Sub-WO ? Thanks.

[Craig Golding]

Sorry to jump in here with a question – so the employee scans their unique barcode and this starts the job timer – is that right? Then they have to scan again to stop? Just like in Mobile Tech (Start/Stop timer)?

[Craig Golding]

So…that last sentence has come back to bite me. We now have a requirement to quote on a Sub-WO. I’ve seen some chatter in other parts of the forum on the same topic but no solution. Has anyone found a beginner level solution? Cheers.

[Craig Golding]

Hey all – ticket CCTS-642 has been submitted for development review. Thanks all for your help.

[Craig Golding]

Thanks Guys,

@Mike, I think Nadim’s explanation identifies the problem but yeah, it had the problem regardless of the print job destination. It is weird about the form version difference though – is CC supposed to update the STD form when Q versions upgrades are carried out? Perhaps when the old schema is copied to the later Q version it copies the older forms over the top of the later ones?

@Nadim – that’s awesome mate. Thanks for the breakdown. I’ll log a job with CC and update this thread as it progresses. Thanks again for your help. Cheers.

[Craig Golding]

Hey Mike. I’ve attached 4 pics below. The print parameters, task selection and then the two pages it wants to print. As you will see, the form used is the STD Work Order Traveler A4 which has not been modified since 18 Apr 2001.

[Craig Golding]

With further testing I’ve discovered that it happens in all WO’s.

However, if I print ‘Selected Tasks’ and only select the last task in the list it prints normally – no extra page.

If I select any other Task or multiples (but not the last task) then it prints the extra page at the end (with just the Header/Footer).

If I print all tasks (which includes the last one) then it prints fine – no extra page.

Thanks for your offer Mike – can you try the STD Work Order Traveler A4~ form for me? PS – We’re on v10.10.5

[Craig Golding]

Thanks Thiago, I couldn’t see any ‘New page’ boxes ticked but found the following code in the Groups[0] BeforeGroupBreak calc, which I’ll try figure out. I did notice that if I delete this code, then the report will print all tasks regardless of the settings, but not a blank one at the end??:

begin

Detail.Visible:= (Parameters[‘PRINT_TASKS’]=0) or

((Parameters[‘PRINT_TASKS’]=1) and (WO_TASK[‘PRINT_TRAVELER_FLAG’]=’T’)) or

((Parameters[‘PRINT_TASKS’]=2) and (WO_TASK[‘PRINT_TRAVELER_FLAG’]=’T’));

if (Parameters[‘NEW_PAGE’]=True) and (Detail.Visible=True) then

Report.Groups[0].NewPage:=True

else

Report.Groups[0].NewPage:=False;

end;

[Craig Golding]

Thanks Kristen, that’s a neat way around your situation. Fortunately for us the probability of having to invoice/quote on a sub-WO separately is pretty slim.

[Craig Golding]

Thanks Nadim, seems we have the broken version. We are currently testing v12.1 so not too much longer with this problem. Cheers.

[Craig Golding]

Ahh. Great, thanks Mike.

[Craig Golding]

Thanks guys, that pretty well sums it up. I had another thought – can you receive two items of the same part number into a single WO? I’ve tried to do this but when I enter the ‘Total to Receive’ as anything higher than 1 it reverts back to 1 when I move to the next field. Is there a setting I’ve missed in Control somewhere? See pic.