Page 1 of 1
Project Activity - what files do I need to access for actual costs
Posted: 21 Feb 2023, 15:43
by KenStarnes
Feel free to move this question to the correct section.
I'm trying to accumulate actual material costs for a project to give me a one line actual v budget report .but cant fathom out where that data comes from when you look at the Project Activity screen. Any help gratefully received
Re: Project Activity - what files do I need to access for actual costs
Posted: 22 Feb 2023, 10:56
by brucedenney
There are a whole bunch of different tables that the data for projects is stored in.
Depending on how the cost was entered it can be in one of many different tables.
The PROJECT_TRAN table is the core table, all the other tables link to it
The joins to the other tables are
PROJECT_TRAN.AUDIT_TRAIL_ID => AUDIT_SPLIT.TRAN_NUMBER
PROJECT_TRAN.COST_CODE_ID => PROJECT_COST_CODE.COST_CODE_ID
PROJECT_TRAN.THIS_RECORD => POP_ITEM.POP_ITEM_ID
PROJECT_TRAN.PROJECT_TRAN_ID => PROJECT_ONLY_TRAN.PROJECT_TRAN_ID
PROJECT_TRAN.STOCK_ALLOCATION_ID => STOCK_ALLOCATION.STOCK_ALLOCATION_ID
PROJECT_TRAN.STOCK_TRAIL_ID => STOCK_TRAN.TRAN_NUMBER
PROJECT_TRAN.PROJECT_ID => PROJECT.PROJECT_ID
Materials will probably be Stock Transactions or Audit Trail, but they could also be Project Only