Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

Jobs and timesheets with external resources

Posted on by 65

Domestic customer has two contracts:

    1. Fixed price prepaid (calculated based on estimated usage)

    2.Time&Material billed based on actual resource usage

There are two resources:

    1.Employee with fixed salary in same currency

    2.External contractor billing per hour in foreign currency

Each resource can allocate time to each contract. 

Expected outcome:

Contract 1: only one invoice to customer, any cost allocated based on reported usage to monitor contract performance.

Contract 2: reported usage billed to customer based on contract pricing.

Time reported by contractor should account for exchange rate changes when allocating costs.

Contractor is filling in the timesheet that can have work for multiple customers and sending one consolidated invoice per each timesheet monthly. Payments are made in base currency and exchange rate gain/loss is posted to P&L. 

I was hoping to use jobs and timesheets but I'm facing few issues:

    1. External resource cost in foreign currency

    2.Reflecting exchange rate gain/loss in contract cost allocation

    3.VAT rates applied (will work on that once I can resolve 1&2)

I'd appreciate any suggestions on how and if this can be achieved with jobs and timesheets.

  • Suggested answer
    Lukasz Sadownik Profile Picture
    Lukasz Sadownik 65 on at
    RE: Jobs and timesheets with external resources

    Thanks for the suggestion. I think the end result is what I'd expect but there is still gap between matching invoice to actual timesheet which, so I'll have to do bit more exploring on this to come up with best solution.

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,155 on at
    RE: Jobs and timesheets with external resources

    Given the extra considerations would it make more sense to process a purchase invoice instead? You can link the lines to the job and job task. Similar to timesheets you can transfer the created job ledger entries to job planning lines so you have a billable line. Resource records are blocked for this usage however. So it would be a case of using a resource record for planning only for externals.

    You will get an invoice regardless so makes sense in that regard. Invoices allow you to manipulate currency rates and VAT too

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans