Skip to Content

SAP Business One formatted search query for AP Invoice and Budget

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

budget-value.png (56.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 29, 2017 at 07:38 AM

    Hi

    How many budgets are you using for the same year?

    Kind regards

    Agustín Marcos Cividanes

    Add comment
    10|10000 characters needed characters exceeded