Thank you very Much for the solution @SanjeewaJ
Hi @Lee Pinchbeck thank you for your reply During the RMA process we will perform a goods receipt against the RMA. this will put the stock into REPAIR stock. but we don’t use FSM for performing our repairs we use SAP. so we need to scrap all the stock after it comes into the Repair location. we do currently have a custom xml business rule that suppose to run on insert/update to the stock_serial_id table. this business rule runs successfully approx 80% of the time. But some times it does not remove the stock but by the time we notice that rule did not process the logs are gone. I have also not been able to reproduce the issue in our test environment. so i was looking into alternative solutions for scrapping the inventory.<perform_stock_adjustment> <parameters> <adjustment_reason>SCRAP</adjustment_reason> <bin_id_from></bin_id_from> <bin_id_to></bin_id_to> <location_from>@location</location_from> <location_to></lo
Hi @Saranga Amaraweera , Thank you for the reply. what i am try to do a message translation on the data that is in a fieldSo all the values in the “Field” Column (highlighted Yellow) i would like to maintain a Message translation for, or build my own message translation table for this data. Thanks
I managed to figure out what i had wrong in the business rule i needed to do 2 selects one to get the value from the request template and 1 to select the records to update. Updated XML below. <perform_batch> <hierarchy_select result_name="ReqTemplateQuery01" max_rows="1"> <primary_table>request</primary_table> <attrs> <attr>request_template.user_def8</attr> </attrs> <from> <table>request_template</table> </from> <where> <data_constraint> <constraint> <left_operand>request.eco_id</left_operand> <operator>eq</operator> <right_operand>@foreign_key_char1</right_operand> </constraint> </data_constraint> <join_constraint> <constraint> <left_operand>request_template.request_template_id</left_operand> <operator>eq
yes it is set as force_select Ok i will take a look at the Server logs
In this case there was only one Request that i was trying to creating with ECO Generation And yes the user_def8 should be F-01550 request_id eco_id user_def8 227368 767 NULL
Hi @Mike The FSM TechnoGeek thanks again for the information When i try to post this via the XML Poster it states that it updated a record but when i check the record it’s not update. trying to debug further i get this when i do the Hierarchy select <hierarchy_select result_name="ReqTemplateQuery01" max_rows="1"> <primary_table>request</primary_table> <attrs> <attr>request_template.user_def8</attr> </attrs> <from> <table>request_template</table> </from> <where> <data_constraint> <constraint> <left_operand>request.eco_id</left_operand> <operator>eq</operator> <right_operand>767</right_operand> </constraint> </data_constraint> <join_constraint> <constraint> <left_operand>request_template.request_template_id</left_operand> <operator>equi</operat
Thank you @Mike The FSM TechnoGeek , For this business rule if i am running it off of the METRIX Run_log I will only have the Foregin Key that has the ECO_ID in it. i can do a hierarchy_select against the REQUEST Table to get the Request Template and then provide back the REQUEST_TEMPLATE.USER_DEF8 field value but how would i update the all Requests now with that value. Would i do another Hierachy_select against the request table for the ECO and do an update to the REQUEST.USER_DEF8 field? i have not used a Mass update before so not sure how i would set that up. so if you could provide some guidence that would be helpful. if i try running the update statement manually in the XML Poster i get an error: “Attempt to update a record without providing all Primary Key information.” <perform_batch> <sequential_dependent> <hierarchy_select max_rows="1"> <primary_table>request_template</primary_table> <attrs> <attr>request_template.u
Thank you for the Reply @Lee Pinchbeck is there a standard business rule that runs off of the ECO Generation? if so which rule is it i didn’t see one? if not what type of Custom process would i create that would trigger off of the ECO Generation. I am looking to Copy request_template.user_def8 to request.user_def8 Thanks in advance Graeme
Thanks Clement, I managed to figure it out i used a perform message on the button and then used a custom_xml to update the line <perform_batch> <update_imax_rid_settlement> <imax_rid_settlement> <update is_initialized="false" /> <action>CLOSED</action> <seq_id>@seq_id</seq_id> </imax_rid_settlement> </update_imax_rid_settlement></perform_batch>
@Mike The FSM TechnoGeek Thanks if I want use the xpath value in the expression instead of the request.place_id how would I update it @expression["S-" + place.external_reference + "-M"]
@Mike The FSM TechnoGeek Thank you for your help previously. i have a new requirement to add to this. I now need to grab another field that is on the place table to use in the expression. say place.external reference. how would i go about adding that you the xml business rule i am assuming i need to do a hierarchy select against the place table but how would i add the result to the expression. Thanks again for your help. Graeme
you can hide the menu from users in the Role Screen → Menus tab select your menu and then select disable.
Thank you for your Help. that worked perfectly
Thank you very much that fixed my issue
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.
