UDF Valid Values & UDOs - Part#2 - SAP® Business One

SAP® Business One UDF management. How to pull valid value options into a dropdown. Also, my best practices for managing a UDF list of dropdown items using a UDO.
** Support me by visiting supportme.battl... **

[@chrisfisher9121]

Another great video. Very helpful.

[@mauriciotb6103]

Nice Mike.

[@juliannava546]

Thank you very much, it helped me a lot for a job that I was to do

[@mohamedsakr4960]

Hi Micky,
I added UDF to be used in return and AR credit memo, I want to show its description on the print out, i have tried your query but I always get an error
Pls note that:
UDF title: ReturnReason
Description: Return Reason
Field ID: 58
Can you support me on this pls

[@carlo607]

Hello Mike,
How do you create such dynamic reports like you have in the bottom of SAP screen? Daily sales, Financial Ratios, Messages and Alerts etc.? Greetings.

[@Ruytter]

Hey Mike.
I'm aware of this feature. What I don't understand is why this doesn't work when this UDF is added into a UDT that is a subtable in a UDO. The field is there, but it doesn't have the dropdown or any link to it's table.

[@BattleshipCobraSAP]

Hi Ruytter! Interesting, I got the same results in 9.3. Must be a bug. I guess in this case you can either use a formatted search as the select (something like: SELECT Code,Name FROM UDT) or you could just do a valid values list. Great question though!

[@jonathanrotstein7378]

Hi Mike, thank you … we are trying to find a way to writeback data from an excel list to SAP B1 Coresuite UDF, or do have data o SLACK available to post to SAP B1 UDF. thank you for any advise

[@prateekgupta2790]

Hi mike,
Nice video but U told us about static field . How to setup dynamic field like user need can enter and save values whenever it required. Can we do it by fms if yes than can u share a video for this

[@PradeepYadav1991]

Hi MIke can you upload a video on MRP? Restrict sales orders, production orders how lead time works on bom and its components we are implementing b1 at client side and each time i run Mrp i get results buts not clear to use so i request you to upload a detail tutorial on MRP :)

[@Tiestin]

Hola, Podrias hacer un ejemplo de ¿como hacer un reporte en crystal report desde un UDO ?

[@Tiestin]

yes, I want to create a report in CRYSTAL REPORT that shows data from my UDO and that they are launched from a button of my UDO

[@sin.37]

Hi Mike how do you manage to use SQL Server to access the data from SAP?

[@007mousie1]

Do you do private business to business consulting?

[@romelcatalogo8022]

Hi, Can you teach me how to auto active the rows in master data or document in UDO
Thanks

[@romelcatalogo8022]

@@BattleshipCobraSAP Hi sorry, I Mean auto active the rows rather than always adding line.
Thanks

[@romelcatalogo8022]

@@BattleshipCobraSAP Hi Sorry, I mean how can achieve the auto_active row line in UDO, because now what I did I always adding line.
Do you have any tutorial to make it auto?
Thanks

[@romelcatalogo8022]

@@BattleshipCobraSAP Im using UDO document and Master header/rows.

[@romelcatalogo8022]

@@BattleshipCobraSAP someone said it can achieve using addon (Itemevent). And I dont know what is that addon

[@TheAmoscokkie]

Why does one call sue, instead of susan and mike for michael ? Duh

[@romelcatalogo8022]

PLease create UDF uploading image