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
Project Activity - what files do I need to access for actual costs
-
- User
- Posts: 3
- Joined: 16 Jul 2013, 10:59
- Sage Version: v2011 17 UK/Europe/Africa
- brucedenney
- Site Admin
- Posts: 4633
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Project Activity - what files do I need to access for actual costs
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
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
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 2 guests