Actual hours in MSP

[Nat]

Hi,

We are trying to put weekly actual hours in Microsoft
Project from our financial system through an import macro
that we`ve created. However, we have the following
problem: our month end date does not match. Ie. the end
of the month in our financial system could be March 18th
and in MSP, the month end date is March 31st. Is there a
way to change this in MSP? (Also, our month end dates are
never the same from month to month). The results of this
problem is that our actuals at the end of the month never
match between MSP and our financial system.

Help?
Thanks!

Nat

 

[John]

Hi,

We are trying to put weekly actual hours in Microsoft
Project from our financial system through an import macro
that we`ve created. However, we have the following
problem: our month end date does not match. Ie. the end
of the month in our financial system could be March 18th
and in MSP, the month end date is March 31st. Is there a
way to change this in MSP? (Also, our month end dates are
never the same from month to month). The results of this
problem is that our actuals at the end of the month never
match between MSP and our financial system.

Help?
Thanks!

Nat

Nat,
You are working with a company financial calendar. The most common is
based on a 4-4-5 month sequence. Unfortunately no version of Project
supports custom financial calendars. The best you can do is to create a
macro to translate Project's standard calendar data into your company's
financial calendar. I have done that a couple of times.

Hope this helps.
John
Project MVP