Grants, does anyone have a rule for the interface invoices to AR for one award, two projects
Hi All,
Does anyone have a sample sql for the GMSTAR GMS: interface invoices to AR, where there is one award and two projects, where project_id is the parameter. I know that project_id will pick up the award_project_id, but customer is using select segmrnt1 from pa_projects_all where project_id = (&award_project_id) -- the award number.
The problem is that it is returning error:
"Accounting flexfield could not be validated "
Thanks,