PBI 4917 - Filtering of Choose from List for UDFs linked to system tables.

Completed

Scott McClure

• November 08, 2016 16:03

B1 now supports linking UDFs to system tables. Wonderful, however, there will be many cases where an unfiltered table will cause problems. For instance, I may want to line to AP Invoices but only Open ones. Currently I'd like to add a document-default vendor to the Purchase Request but the pick table presents all customers, leads and vendors where only vendors are appropriate to the function. I see you have a Sort Column choice. Could a Filter Column be created? I don't believe there Is currently a way to do this.

Vote

0

• Official comment

  

  Naama Aharoni

  • May 21, 2017 12:23
  • Edited

  Hi Scott,

  This feature was added in version B1UP 2017.01

  Thanks, Naama
• 

  Naama Aharoni

  • May 21, 2017 12:23
  • Edited

  Hi Scott,

  I will post this as a development request however, lease note the is a workaround for that with using a validation and an SQL Report UF: http://screencast.com/t/icYnb67MwGCa (screenshot in this link).

  Thanks, Naama

  
  
  
• 

  Scott McClure

  • November 16, 2016 17:03

  Super Naama, I will give that a try!  Thanks much.

  Scott

Please sign in to leave a comment.