@Tj12 There are challenges in the way you are achieving this. But I am struggling to understand why you are doing it. Is it because you want to store info on the current sales manager when the order was released? Hi Hans Yes and Business want to populate manager automatically. They are too lazy to select and enter it.
I agree with Paul - make sure the custom event is firing. If it is, I wonder if you can directly run an update statement to a DB table from inside a custom event. If that’s the problem, you need to use the standard modify statement. Something like objid_ := := '&NEW:ROWKEY'; Client_SYS.Clear_Attr(attr_cf_); Client_SYS.Clear_Attr(attr_); Client_SYS.Add_To_Attr('CF$_S_MANAGER', SalesM_, attr_cf_); Customer_Order_Cfp.Cf_Modify__(info_, objid_, attr_cf_, attr_, 'DO'); Sample variable declaration info_ VARCHAR2(2000); objid_ VARCHAR2(2000); attr_ VARCHAR2(32000); attr_cf_ VARCHAR2(32000); Hi J Thanks for commenting As i replied to paul Event is firing. but unable to update the field.
ok, you will need to take it apart to see where the problem is... If the select statement was not finding any data, you would be seeing a “no data found” error there. Aside: I would recommend using an explicit cursor here instead- the “no data found” error is not good for users to see. Next i would remove the IF condition and see if it then works; that would imply that the IF condition is not being met. Finally, you need to confirm whether the event action as a whole is running. My recommendation would be to drop this line into the script and see if the error appears at that point -if the error shows up, it means the event action ran and reached that point. Error_SYS.Record_General('PurchasePart','You are here'); (If you don’t see the error, this tells you the event/action is not being triggered). Hi Paul, Excellent guidance, Now i know my event is firing when i release the order. But yet I am unable to update the field and I am getting below error below is the code i us
If still an issue - we would need to know whether it is a reference-type field or just a text field. That affects whether you need to use CF$_SALES_MANAGER or CF$_SALES_MANAGER_DB Hi Paul, Thanks for commenting, I removed the space but still the same issue. Both custom fields are text fields.
Have you tried using Availability Control ID in inventory part in stock? Hello Hans, Yes. As at now, I have put Control ID in order to block those stock but yet it still shows as Available stock
Yes you can do it as a Configuration. Right-click on the page in the whitespace near the form fields you wish to change, then select Properties. In the Properties window, select the Layout tab. Select the Use Customised Screen Layout checkbox. Select/Unselect the fields you wish to show/hide. You can also change their position on-page. Click OK to save the layout. If you’d like to apply this layout to your whole organisation, you’ll need to edit the Base Profile first, then make the above changes, then save the Base Profile. This is what I want. Thanks a lot Garak.
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.