Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Jobs and timesheets with external resources

(0) ShareShare
ReportReport
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,159 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans