Skip to Content

SAP Business One formatted search query for AP Invoice and Budget

Feb 10, 2017 at 06:04 PM


avatar image

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 .




budget-value.png (56.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Agustin Marcos Cividanes Aug 29, 2017 at 07:38 AM


How many budgets are you using for the same year?

Kind regards

Agustín Marcos Cividanes

10 |10000 characters needed characters left characters exceeded