Importing Timesheets into Sage 200

We are trying to import timesheets into Sage 200 using "Post timesheets to Projects" in Project Accounting/Utilities/Import & Export.

Because of the nature of our projects, we wish to post the hours on a weekly basis so an employee might spend the whole or part of a week on a project; however, the standard Import "Post timesheets to Projects" only seems to allow a maximum of 24 hours (presumably because that's the number of hours in a day). If we try to post, say, the whole week ie 40 hours, it gets rejected.

I know we can do a work around and post two lines for the time eg 24 hours and 16 hours but it looks odd when running cost reports against that project.

Is there a solution out there to post more than 24 hours on a line?

Hope that's clear and thanks in anticipation of any feedback. 

  • 0

    Hi Steve,

    I've had a review of the post and for the importing of Timesheets like you've mentioned it isn't possible to import more than 24 hours per line, as it is designed around a 'per day' import. I think this would best considered as a 'request for change' to allow more flexibility in the importing of timesheets. 

    Thanks,
    Andrew