How do I set up an event so that the project connection is assigned automatically by using the work type field in the prepare for work order page? IE when the work type is a certain value then the project connection is the correlating value.
I am trying to add a project connection to this WO which gives me the following error message. i have tried rolling back the requisition, work tasks and un-issuing the material order. Have also tried deleting part lines and re-adding however still unable to add a project connection once the material order has been issued. there is also a similar issue where you are unable to change the project connection after which the WO has been progressed through the status. how do i add/change a project connection after the material order has been issued?
Trying to develop data sources for Lobby elements to use for day to day business management. I am trying to ascertain the next awaiting step in the approval process for a purchase requisition line so my data source so need the minimum step ID where the Signature field is null. See snapshot below; essentially my SQL will look like;SELECT COLUMNS, MIN(ROUTE)FROM &AO.PURCH_REQ_LINE_APPROVALWHERE SIGNATURE_ID IS NULLGROUP BY COLUMNS:as per the image above the aggregate function appears to not be working as there are multiple steps (Route column) still displayed, IE 10, 20 and 30. whereas there should only be the minimum route number displayed.what am i missing…...
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.