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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / So Simple, but can'...
Microsoft Dynamics GP (Archived)

So Simple, but can't figure it out

(0) ShareShare
ReportReport
Posted on by n0j0ke1107 60

I need help with something simple.  I am trying to print out a list of accounts receivable.  I have the list using SmartList, but I need the total amount of all accounts to be at the bottom.  I've searched everywhere and cannot find the option to total the amounts.  I know it can be done exporting it to Excel, but I don't know how to do that without manually putting in the function.

TLDR, how to total all accounts on a print off using SmartList

*This post is locked for comments

I have the same question (0)
  • ArthurA Profile Picture
    ArthurA 4 on at

    office.microsoft.com/.../insert-subtotals-in-a-list-of-data-in-a-worksheet-HP010342620.aspx

    How to insert subtotals in Excel.

  • n0j0ke1107 Profile Picture
    n0j0ke1107 60 on at

    Not really what I am looking for.  Ok, in MS Dynamics GP, under SmartList, I want to create a report for the Stores department.  I have the Item Description, QTY on Hand, and Current Cost.  I need to find a way to add a column in SmartList that will multiply the Current Cost (Item Cost) and the QTY On Hand to create a Total Cost per item.  and them I need to display that on a doc with a subtotal at the end of the Total Cost to show the Total Costs of all items

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    The only way to do part of what you want is with SmartList Builder. You can create a calculated field to handle the Total cost per item, but to get a subtotal, you need to use Excel. To get both results, you can use an Export Solution with SmartList that will export to excel and automatically enter your calculated field results as well as the subtotal. You can create the Export Solution using just SmartList, without needing SmartList Builder.

    Kind regards,

    Leslie

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans