Need help for a suggested way of overwriting the default PRICE_LIST_NO value on the Postings Tab.Thought I could do it by using an event, but not sure exactly how that code would be written to function as intended.Function needed:When new posting lines is added to a Work Order in the “Postings” tab, each line pulls the Preferred Pricelist from the connected Customer, using that Customer’s Price List value. Problem is that the same Customer can have more than one Service Contract (and more than one Object / site), but with different service types depending on the Contract. Therefore we need to be able to pull different Price List No values on the same Customer, why the Price List or Customer Agreement is not fully enough to create proper sales price invoicing. So what I’m looking for is a way where the standard Price List No value can be overwritten to another one, using an Event, if fx the Service Contract Type connected to the Work Order has a certain value, and then overwrite the Pri
I’m trying to create a new custom event for Work Order Status Change, that fires an error message if the status is changed from ‘PREPARED’ to “WORKDONE’, that warns the user that they have to first set the status to ‘STARTED’ before changing status to ‘WORKDONE’. Can someone help me out with the SQL code I need to write? The below doesn’t work for me. -- DECLARECURSOR get IS SELECT '&OLD:WO_STATUS_ID'FROM ACTIVE_SEPARATE_CFTWHERE '&OLD:WO_STATUS_ID' = 'PREPARED'BEGIN IF '&NEW:WO_STATUS_ID' = 'WORKDONE' THEN Error_SYS.Appl_General('ERROR!', 'You must set WO status as STARTED before you can select WORK DONE'); END IF;END;
Already have an account? Login
No account yet? Create an account
Enter your 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.