GL Account Override Lookup Example
If you allow users to code to expense in the AP Invoice, Expense, and PO modules, you may want to restrict the list of available GL Accounts by creating a GL Lookup.
Viewpoint Field Management
list_alt
If you allow users to code to expense in the AP Invoice, Expense, and PO modules, you may want to restrict the list of available GL Accounts by creating a GL Lookup.
Select cast(KeyID as varchar(10)) as ChoiceShortName, GLAcct + ' - ' + Description as ChoiceLongName
from kGLAC
INNER JOIN GetEmplInfo(null,null,@AuthToken) a on kGLAC.GLCo = a.PRCo
WHERE kGLAC.udExpenseYN = 'Y'
Lookup Detail:
Select cast(kGLAC.KeyID as varchar(10)) as ChoiceShortName, GLAcct + ' - ' + kGLAC.Description + '- Employee ' + cast(kPREH.Employee as varchar(200)) as ChoiceLongName
from kGLAC
INNER JOIN kPRDP on kGLAC.GLCo = kPRDP.PRCo and kGLAC.udPRDept = kPRDP.PRDept
INNER JOIN kPREH on kPRDP.PRCo = kPREH.PRCo and kPRDP.PRDept = kPREH.PRDept
WHERE kPREH.PRCo = @PRCo and kPREH.Employee = @Employee