Which keys tie projects to fixed_assets
Currently trying to tie projects to fixed_assets.
We have capital projects that populate to assets, but I can't seem to figure out how to join these two modules in the backend for reporting.
Anyone have any suggestions? When I try through project_number and task_id, the FA tables have a particular task_id or set of task_id's for a project_id, and the projects tables have a different task_id or set of task_id's for the same project_id.
If these are not the same, is there a common denominator between the project and assets tables I can use to join them?