Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Project Reports - Budget Fields
Project Reports - Budget Fields
Hi
Wondering if anyone knows the field names for the Budget amounts.
Its going to be helpful, say on the report Cost Code Summary that totals the cost codes and will also shows the budget figure to see if over budget for a particular cost code.
Thanks
Wondering if anyone knows the field names for the Budget amounts.
Its going to be helpful, say on the report Cost Code Summary that totals the cost codes and will also shows the budget figure to see if over budget for a particular cost code.
Thanks
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Project Reports - Budget Fields
Hi Bill
What type are you using ... Standard, Advanced, Advanced Dept Summary, Advanced Department
https://gb-kb.sage.com/portal/app/portl ... 7112205417
Or is this project costing?
What type are you using ... Standard, Advanced, Advanced Dept Summary, Advanced Department
https://gb-kb.sage.com/portal/app/portl ... 7112205417
Or is this project costing?
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.
Re: Project Reports - Budget Fields
Hi Bruce
Its the ' Projects ' module if that's what you mean of project costing
Its the ' Projects ' module if that's what you mean of project costing
Re: Project Reports - Budget Fields
These are the fields...
Login to access the files attached to this post.
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Project Reports - Budget Fields
The table you need is called PROJECT_BUDGET
It has 3 main fields, the Project ID, Cost Code ID, Budget Amount
It has 3 main fields, the Project ID, Cost Code ID, Budget Amount
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.
Re: Project Reports - Budget Fields
Thanks Bruce..
From your advice I need to add another table to the report ( report / joins) to be able to get the fields.
Every time I try that in the past never seem to be successful..lol
Anyways I tried adding and would you believe it I get the below error which I cant understand.
I am initially editing the Cost Code Summary per Project report.
From your advice I need to add another table to the report ( report / joins) to be able to get the fields.
Every time I try that in the past never seem to be successful..lol
Anyways I tried adding and would you believe it I get the below error which I cant understand.
I am initially editing the Cost Code Summary per Project report.
Login to access the files attached to this post.
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Project Reports - Budget Fields
What join where you adding?
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.
Re: Project Reports - Budget Fields
Hi Bruce
The one you mentioned PROJECT_BUDGET its the one to the right of the error message in the previous post.
Using Sage 28.1.404.0
The one you mentioned PROJECT_BUDGET its the one to the right of the error message in the previous post.
Using Sage 28.1.404.0
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Project Reports - Budget Fields
What field are you joining to which
Perhaps if you posted the layout and what you have done?
Perhaps if you posted the layout and what you have done?
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.
Re: Project Reports - Budget Fields
Hi Bruce
I dont get to join any fields, as soon as I drag in the budget table the error appears.
Im just using the default Cost Code Summary, joins, drag the project_budget table and error pops up.
What happens if you try the same in your sage...lol
p.s just tried it on another sage ( 28.1 ) at another location and same error.
I dont get to join any fields, as soon as I drag in the budget table the error appears.
Im just using the default Cost Code Summary, joins, drag the project_budget table and error pops up.
What happens if you try the same in your sage...lol
p.s just tried it on another sage ( 28.1 ) at another location and same error.
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Project Reports - Budget Fields
I see the issue, just hit continue and it works.
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.
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Project Reports - Budget Fields
Here is what I have done
Login to access the files attached to this post.
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.
Re: Project Reports - Budget Fields
Nice Bruce
Thank you very much, works wonderfully.
Bill
Thank you very much, works wonderfully.
Bill
Who is online
Users browsing this forum: No registered users and 2 guests