web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
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.

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    159 on at

    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

  • Suggested answer
    Lukasz Sadownik Profile Picture
    65 on at

    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.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,050 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,441 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,175 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans