[Jens-Uwe Suess]

Hi Leo,

you can find unassigned locations with this SQL:

select * from location loc

left join warehouse_locations wlc on loc.loc_auto_key = wlc.loc_auto_key

where wlc_auto_key is null

and historical = ‘F’

Kind Regards

Jens

[Jens-Uwe Suess]

Perfect. Thank you very much Vicky!

[Jens-Uwe Suess]

I guess this can be adjusted somewhere in Quantum. I took both screenshots on the same machine but logged in as different users.

[Jens-Uwe Suess]

Hi Craig,

At first we set up the process. We named an open status ‘APPROVED’ and made it as ‘block activity’.

Then we issued this status only to the users who quote to the customer.

Whenever a Job Card is accepted by the customer, the colleagues change the Status to ‘APPROVED’

In Event Manager we set up an Event to Execute a stored procedure. Interval is every 5 minutes. This is the simplified script:

____

Create or replace PROCEDURE SET_REQUISITION AS

BEGIN

FOR r in (select wob_auto_key from wo_bom

left join wo_task wot on wot.wot_auto_key=wo_bom.wot_auto_key

where wo_bom.requisition=’F’

and wot.wos_auto_key = *insert autokey from desired status*)

LOOP

BEGIN

UPDATE wo_bom wob

SET wob.REQUISITION = ‘T’

WHERE wob.wob_auto_key in r.wob_auto_key;

COMMIT;

END;

END LOOP;

END SET_REQUISITION;

______

Hope this helps. If you have any questions please let me know.

Cheers, Jens

[Jens-Uwe Suess]

Hi there,

Just for Information. We recently upgraded to Version 12 and Nadim – as an official Quantum partner – upgraded our legacy imaging integration as well to version 12. This included the free Imaging-API.

Kind Regards, Jens

[Jens-Uwe Suess]

Yes.

[Jens-Uwe Suess]

Hi Mark,

not sure if I got you right, but to delete a stockline you have to adjust the quantity to zero, right? This could bee seen in Stock Audit.

Kind Regards, Jens

[Jens-Uwe Suess]

Thank you Nadim!

[Jens-Uwe Suess]

Nadim,

I only see a ‘Need Date’ in WO/WP Header and this is not showing in PM.

[Jens-Uwe Suess]

Thanks a lot to both of you and kind regards!

[Jens-Uwe Suess]

Hello,

how can multiple part numbers be imported into a open sales order?

Kind regards

Jens

[Jens-Uwe Suess]

Hi,

This is the same issue we noticed in our system. We are currently on 10.8.9. Did you something to solve this?

Regards

Jens

[Jens-Uwe Suess]

Hi Lanita,

I would recommend you to contact Mr. Nadim Ghazzaoui. He is very skilled in in Forms Designer and any other Quantum topic as well.

nadim@forward.aero

Kind regards

Jens

[Jens-Uwe Suess]

Ah, now I see. Thank you very much David!

[Jens-Uwe Suess]

Hello Jason,

No, we do not have this module. My idea was a non-stock PO and a cost adjust on the stockline. Is there a better workaround?