B1 Budget - Add UDF with UDV to budget entry list

Not planned

Gerard Mengerink

• August 10, 2016 13:00

We would like to show the first orderdate per customer in the B1UP budget entry list: So a new column, that shows the result value of something like this: SELECT min(T0.[DocDate]) FROM ORDR T0 WHERE T0.[CardCode] = $[$BOY_14.U_BOY_DATA_KEY.0] How can we do this ?

Vote

0

• Official comment

  

  Naama Aharoni

  • August 14, 2016 15:29

  Hi Gerard,

  This seems to be the same question as in: https://support.boyum-it.com/hc/en-us/community/posts/213040568-Add-column-with-UDV-to-B1UP-budget-entry-list

  Is that correct?

  Thanks, Naama
• 

  Naama Aharoni

  • August 16, 2016 07:19

  Another updated from the partner: 

  Our customer wants to see what date the oldest order for a customer is. They make a difference between existing customers (orders before current year) and new customers (first order in current year). Both are in different budget definitions (the y have two budget definitions per year: existing customers with a full year budget and new customers for which they only can estimate roughly, for part of the year).

  But in general: how can we add a column (a UDF) to the budget entry list and set a UDV on it ?
• 

  Rasmus Jensen

  • November 13, 2017 15:06
  • Edited

  I'm afraid this is not planned as this have received no votes :-(

Please sign in to leave a comment.