How can report MS project costs in financial periods instead of mo

[Tim Smith]

My company has finacial periods that go in weeks 4,4,5,4,4,5,4,4,5,4,4,5 etc.

How can I report proect costs in periods rather than months?

 

[Mike Glen]

Hi Tim,

Welcome to this Microsoft Project newsgroup

You can't - Project is only a work schedueller which tracks costs, not a
financial management program.

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on )

Mike Glen
MS Project MVP

 

[John]

My company has finacial periods that go in weeks 4,4,5,4,4,5,4,4,5,4,4,5 etc.

How can I report proect costs in periods rather than months?

Tim,
I take exception to Mike on this one. Your company is using a common
4-4-5 sequence. Although no version of Project supports financial
calendars, through VBA the normal Project calendar data can be converted
into 4-4-5, (or any other sequence), data. I've done it more than once.
If you would like more information, contact me direct.

Hope this helps.
John
Project MVP

 

[Mike Glen]

Hi John,

As you know, I'm not a vba expert so I tend to respond as such if, whatever,
can't be done in Project itself. Writing code is another ballgame and could
cost the poster a lot of money. Indeed, at a price, anything can be done
with anything by programming! I leave it to the likes of yourself to make
the contract If you do if for free, then why not pass me the code and
I'll publish it in the mvp vba pages for all to see and use, then we can
refer future posters to the web site


Mike Glen
Project MVP

 

[John]

Hi John,

As you know, I'm not a vba expert so I tend to respond as such if, whatever,
can't be done in Project itself. Writing code is another ballgame and could
cost the poster a lot of money. Indeed, at a price, anything can be done
with anything by programming! I leave it to the likes of yourself to make
the contract If you do if for free, then why not pass me the code and
I'll publish it in the mvp vba pages for all to see and use, then we can
refer future posters to the web site


Mike Glen
Project MVP

Mike,
That particular code is not done for free but on the other hand it need
not cost a lot of money. But then "a lot of money" is a relative thing.
What is a lot of money to me is just a drop in the bucket to a corporate
entity.

John

 

[John]

Hi John,

As you know, I'm not a vba expert so I tend to respond as such if, whatever,
can't be done in Project itself. Writing code is another ballgame and could
cost the poster a lot of money. Indeed, at a price, anything can be done
with anything by programming! I leave it to the likes of yourself to make
the contract If you do if for free, then why not pass me the code and
I'll publish it in the mvp vba pages for all to see and use, then we can
refer future posters to the web site


Mike Glen
Project MVP

Mike,
I should have provided a more definitive answer as to why I took
exception to your response. Since I think it is of general interest, I
am posting a new message on this newsgroup.

John

 

[Mike Glen]

No problem, John

Mike Glen
Project MVP

Mike,
I should have provided a more definitive answer as to why I took
exception to your response. Since I think it is of general interest, I
am posting a new message on this newsgroup.

John

 

[Tim Smith]

Thanks both of you! It is what I expected - not simple. However i find it
quite a shortfall of project as all our reporting here, progress the lot, is
based on period not month.

Thanks again.

 

[John]

Thanks both of you! It is what I expected - not simple. However i find it
quite a shortfall of project as all our reporting here, progress the lot, is
based on period not month.

Thanks again.

Tim,
"Not simple" is a relative term. Check out the discussion in this
newsgroup on the subject of "Project capabilities". I hit quite a cord.

I think the reason Project does not have the feature built-in is that
non-standard calendars are used by only a small segment of the business
world. Adding the built-in capability to Project isn't a highly
requested feature and therefore not cost effective for Microsoft. At
least that's my opinion.

John