Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Unanswered

How to hide invoice line item using word template.

Posted on by 71
Hello Everyone,
 
We are using word template to create invoice with Export to PDF
 
We want to hide few invoice line item and do not want to show all the invoice details, but want to show the correct final subtotal.
 
Ex When invoice is created say 3 invoice item are added and each line item unit price is $1000 & qty 1 for each. So the subtotal is $3000. If we use OOB XML mapping on word template and create invoice then all line item will appear on the invoice.
Description Qty Unit price Extended Amount
Product 1 1 1000 1000
Product 2 1 1000 1000
Product 3 1 1000 1000
    Subtotal 3000
 
But in our case we will like to only show 1 or 2 line item, with correct subtotal 
Description Qty Extended Amount
Product 1 1 3000
Product 2 1
     
  Subtotal 3000
 
We want to have only one word template.
 
Looking forward to get some feasible/easy solution.
 
Thank you in advance.
 
 
 
  • Suggested answer
    Daivat Profile Picture
    Daivat 822 on at
    How to hide invoice line item using word template.
    Hello ekmode8483,
     
    There is not an OOTB way to generate the Word/PDF document that will allow to hide the rows.
     
    You can define the word template in SharePoint/OneDrive and using Power Automate, populate the values into pre-defined template. This way you will have more control on data and values.
     
    Refer below links on how to configure it.
    How to Generate a PDF from a Word Document Using Power Automate https://www.linkedin.com/pulse/how-generate-pdf-from-word-document-using-power-automate-ng%C3%B4-quang-a3agc/
    Create Dynamic PDFs with Tabular Data using Power Automate Create Dynamic PDFs with Tabular Data using Power Automate
     
    If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
    If you have further questions, please feel free to contact me.
     
    Best Regards,
    Daivat Vartak

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

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,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,302 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans