Skip to main content

Notifications

Dynamics 365 Community / Forums / Field Service forum / Work Order Products/Se...
Field Service forum

Work Order Products/Services Invoice Notes - how can I show them on the Invoice?

Posted on by 24

Hi

We have a custom field against each product or service on the Work Order that holds an Invoice Note.

I want to concatenate all of these notes together and hold them on the Invoice that is created when the Work Order is Posted.

Is it possible to amend the job that creates the Invoice record to hold this data as well?

Sorry for the rookie question!

Emma

  • E Linton Profile Picture
    E Linton 24 on at
    RE: Work Order Products/Services Invoice Notes - how can I show them on the Invoice?

    Thanks both!

    I'll try out the append first and see if that works and let you know

  • Verified answer
    Thomas David Dayman Profile Picture
    Thomas David Dayman 11,323 on at
    RE: Work Order Products/Services Invoice Notes - how can I show them on the Invoice?

    You have to add the 'append with' function so it doesn't overwrite the previous value - community.dynamics.com/.../how-do-i-add-data-to-a-memo-field-via-workflow-without-overwriting-it

    I think this could work.

  • Suggested answer
    antc Profile Picture
    antc 2,909 on at
    RE: Work Order Products/Services Invoice Notes - how can I show them on the Invoice?

    Can definitely do with flow.

    Get the content from the work order then use a component like convert text to pdf or some other format and save to annotation or some other location.

    Sorry missed the invoice part, you should be able to trigger a flow on invoice and add text concatenated to a field on invoice.

  • E Linton Profile Picture
    E Linton 24 on at
    RE: Work Order Products/Services Invoice Notes - how can I show them on the Invoice?

    Hi - I tried that but it only seems to put one of the notes there at once.  Is this something that I need to use Flow for instead?  Each work order could have multiple products and multiple services, each with different notes on them.

  • Thomas David Dayman Profile Picture
    Thomas David Dayman 11,323 on at
    RE: Work Order Products/Services Invoice Notes - how can I show them on the Invoice?

    There should be a link to the Work Order Product and Service on the Invoice Line?

    You could create a workflow on create of Invoice Line which appends the notes from the Work Order Product and Service to a text field on the Invoice?

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans