Refresh formatted search on data load

Answered

Ramon Duunk

• April 26, 2019 16:44

I have created a field on the Item master data without any table connected to it but placed a formatted search on a edit tekst box. The problem is that when data is loaded the formatted search cannot be executed automaticaly, also when the item number changes, the formatted seach is not refreshed.

We use this quite common as some data like latest production dates, expiry date etc etc is hidden deeper in the SAP system.

SAP has this function but seem to be only running on the lines field inside a sales or purchase document

Vote

0

• Official comment

  

  Thomas

  • April 29, 2019 13:01

  Hi Ramon,

  In addition to Fernando's comment, we do not recommend using FMS anywhere in the system. Please check this video to understand why: https://www.youtube.com/watch?v=VXTx6ULH348

  Best regards,

  Thomas
• 

  SSP Automation

  • April 29, 2019 06:08

  Thank you for your request.
  The development team have now added it to our internal planning-system for evaluation.
  [Internal Id: 22973]
• 

  Fernando Pescuma Aleixo

  • April 29, 2019 13:04
  • Edited

  Hi Ramon, 

  Thanks for submitting your suggestion.

  You can have this outcome by using a macro, instead of a Formatted Search.

  And then run this macro from a Validation, triggering it from a Data Load event.

  It means the desired outcome can be achieved with the product's current feature set.

  Let me know If by any change I've misunderstood your request.

  Best Regards

   
• 

  Ramon Duunk

  • April 29, 2019 14:15

  Hi Fernando,
  
  That seems to be a solution !
  Just need to rewrite the query then as it failed converting the nvarchar value for some reason, but on the FMS it runs fine.
  
  Thnx for the tip.
  
  @thomas, your right, but in this case it is on the item master data, so no loop there that slows the entire process.

Please sign in to leave a comment.