Hi all,

I will be glad if someone can share with me a formatted search query that will pick the DebLTotal value from the BGT1 table unto the AP Invoice form.

The Budget is scheduled for quarterly interval eg value 1,value2 and value 3 = quarter1 budget, value 4,value 5 and value 6 = quarter 2.

Also we have created a UDF on AP invoice that we will like to pick the quarterly value when the month is within (1,2,3). eg from the image from 0,1,2 the value is 10,000 as in the first quarter. so if the UDF Called "U_Month" is within (1,2 and 3) it should choose the value 10,000. in UDF created called "U_BudgetValue" on AP Invoice.

I will be glad if this can be done and shared .

Regards

Justice

budget-value.png