cancel
Showing results for 
Search instead for 
Did you mean: 

Auto update a UDF and Database

Former Member
0 Kudos

Hi, I am new to SAP Business One. I need to update automatically the value of a UDF. The value will be calculated using data from related tables. Calculation includes -summation, divide and minus etc. Could you provide guide.

For example a new UDF should contain the suggested quantity to order. this is calculated considering the running average sales quantity as of current time for this month and deduct the available quantity on hand and also deduct the quantity already ordered (arriving soon to be delivered to warehouse).

This means that the data in the SQL database must also be updated. I appreciate your input.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Continuation of this thread is in: