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

Notifications

Announcements

No record found.

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
    300,911 Super User 2025 Season 2 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
    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,534 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans