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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Add Invoice Amount Field to 'All Free Text Invoices'

(0) ShareShare
ReportReport
Posted on by

Hello, 

I would like to add a column for the total invoice amount to the 'All free text invoices' area in Dynamics 365 (Accounts Receivable -->Invoices-->All free text invoices). pastedimage1610899648250v7.png

The total invoice amount doesn't seem to be an option when adding a field to personalise it. I also can't seem to add the correct form in the + Create new field option.

pastedimage1610899324859v4.png

Is there a simple way to do this without additional development?

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    304,121 Super User 2026 Season 1 on at

    Hi Liz,

    The table doesn't contain a field for the total invoice amount. You can view the totals when you click on the button 'Totals'. The information o the Totals form is calculated at the time of opening the form.

    To achieve your requirement, it can only be done by a customization.

  • Suggested answer
    Sheela Ningappa Profile Picture
    Microsoft Employee on at

    Hi,

    As mentioned by Andre when there is filed called totals to verify the totals of all the lines, you do not find any total field on the personalization form.

    Thanks,

    Sheela

  • Suggested answer
    Gaurangkumar Jani Profile Picture
    4,556 User Group Leader on at

    Hi Liz L,

    What exactly you want after adding that column?

    Do you just need a list of Invoices with Invoice Id and other fields with Invoice Value?

    If Yes and you need an inquiry form, I would suggest use "Invoice Journal"(AR >Inqury & Reports >Invoices > Invoice Journal)

    You can customize the view if you need only Free text invoice by filtering "Sales Order" (Exactly="") or Filtering Invoice Number Sequence.

    pastedimage1611026681078v1.png

    Or if SSRS works for you, I would suggest "Customer  Invoice Journal report" (AR >Inqury & Reports >Invoices > Customer Invoice Journal Report).

    pastedimage1611027057916v2.png

    pastedimage1611027071256v3.png

    Let me know if this helps.

    Thanks

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 689

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 258 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans