B1 Validation event - Paste from excel (per line)

Respondida

Adam Kolar

• 27 de noviembre de 2023 13:18
• Editado

Hello Boyum,

I would like to reopen this request if there is a possibility to add an event type - paste from excel - or maybe implement "key down" possibility "grid" if you paste from excel.

In some use-cases we need to use macro "Set" for column ItemCode. Macro recognizes the string that user entered (combination of UDFs from OITM) and then changes it to ItemCode from OITM. 
Such macro works only for Key down Event per line only, if you use it for standard SAP B1 fields that are connected to some object (OITM, OCRD...) - Validate (leaving the field) does not work here, because SAP validates the data before the leaving the field (Leaving the field does not happen).

To sum it up - we need to validate each system field that we paste (bulk) from excel sheet.
If there is a workaround, we didnt find it.

https://support.boyum-it.com/hc/en-us/community/posts/203174888-B1-Validation-Event-type-to-trigger-on-9-1-s-multi-Line-paste-i-e-paste-from-Excel-Event

Vote

0

• 

  SSP Automation

  • 27 de noviembre de 2023 13:30

  Thank you for your request. It has been scheduled for review by the development team that will get back to you should there be questions.
  (Please note that as we are user-driven we can't guarantee that your request will be met unless it gets many votes and/or fit the product vision)
  Read more about the Feature Request process here
  [Internal Id: 99213]
  

Iniciar sesión para dejar un comentario.