Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Job Invoicing from Costs
Small and medium business | Business Central, N...
Suggested answer

Job Invoicing from Costs

(0) ShareShare
ReportReport
Posted on by Andrew Cooper 105
If a purchase order is raised in a different currency to the job in one month, and this order is to be invoiced out to the customer
Then that is invoiced in a different period, thereby the exchange rate has changed.
If you then goto the job, you will find the cost amount is based upon the exchange rate when the invoice was posted, but the price has stayed based upon the original exchange rate when the order was created.
Has anyone else come across this? and if so, is there a way to avoid it? without dev.
Many thanks
  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Job Invoicing from Costs

    Andrew,

    I honestly would expect the Unit Price on the JPL to remain unchanged, even if I exposed something on the PO.  If I try to think through the business logic, I would want my Project Manager (or Salesperson) controlling the price of the Job, and would not want the purchasing department changing those values.

    If anything it brings into question how to handle Change Orders within a Job, which is either third-party functionality or a customization.

    Thanks,

    Steve

  • Andrew Cooper Profile Picture
    Andrew Cooper 105 on at
    RE: Job Invoicing from Costs

    You will find your cost and prices are different, so may be 2000 cost, and 1920 price.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Job Invoicing from Costs

    Andrew,

    I was testing your scenario but need more information. Please confirm the following:

    1. Create a Job to a Customer who has your Local Currency (i.e. USD)

    2. Setup a Task and Budget&Billable  planning line that is for an Item that you need to create a PO for. Set the cost and price

    3. Create a PO for the Job Item to a Vendor in another currency (i.e. EUR). Receive PO in 1 Month and Post Invoice in next Month

    4. Job Invoice Customer for the Job Item Line, LCY Currency and for the Unit Price set on the Planning Line.

    Please walk me through your example and what is resulting.

    Thanks,

    Steve

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans