By using this website, you agree to our Terms of Use (click here)
Can anyone know how to display Budget Amount in Item Request?
This's my Reports
And my reports look like this
The Budget Amount Value is from Requests Form
I want Display the Budget Amount to my Reports but the value is never show up, Can Anyone Help?
Thank you
This JOIN looks a little funny to me:
Is that BUDGET DETAILS tab in your screenshot just pulling from the regular General Ledger budget? If so, I'm not sure how OrderNbr could be involved in this JOIN.
yeah, the value of my budget it comes from GL Budget. i was try find a relationship Between GL Budget and RQBudget but i can't find the similar value.
if i put my RQBudget.ExpenseAcctID to my Reports, the value is show up.
i know RQBudget is Depend on RQRequestLineBudget and RQRequestLineBudget is Depend on RQRequestLine, so if BudgetAmt is not in RQRequestLine so the value is never exist. that's just my opinion if it's wrong just give you're opinions Please.
Thank You
Have you tried something like this?
i do the relations between RQRequestLine and RQBudget and still not working.
but i got the point and i make Relations between RQRequestLine and GLBudgetLineDetail and it's works.
Thank you
Awesome. Thanks for sharing the finished product.
Online Members
