SAP Business One formatted search query for AP Invoice and Budget
Feb 10, 2017 at 06:04 PM|65 Views | Last edit Aug 28, 2017 at 10:39 AM 2 rev.
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.
Add comment