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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Run AP Aging in Smartlist
Finance | Project Operations, Human Resources, ...
Suggested answer

Run AP Aging in Smartlist

(0) ShareShare
ReportReport
Posted on by accountinguser2018 151
Hello,
 
I am interested in running an A/P Aging in Smartlist, which ONLY shows transactions which are in the current A/P balance.
 
Under Payables Transactions, I see one can add columns for vendor, TRX Amount, etc. How can I run a report ONLY showing transactions CURRENTLY making up the A/P balance? I do not want any invoices which have been paid.
 
Are there certain columns to add which will provide helpful information?
 
Does 'Current Trx Amount' mean this item is in the open A/P balance?
 
If Current Trx amount = 0, and Document Amount shows the original invoice amount, it means the invoice was paid/voided?
 
Thank you.
Categories:
Microsoft Dynamics GP
I have the same question (0)
  • accountinguser2018 Profile Picture
    accountinguser2018 151 on at
    Run AP Aging in Smartlist
    Is there a column to add which shows status of invoice (paid/unpaid)?
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 874 Super User 2025 Season 2 on at
    Run AP Aging in Smartlist
    SmartList > Purchasing > Payables Transactions:  Search for Current Trx Amount <> 0 and Voided = No.
    You AP Aging should match the sum of Current Trx Amount after you adjust for Document Type Returns and Credits being negative amounts.  (SmartList will send all Current Trx Amounts to Excel as positive numbers.)
  • accountinguser2018 Profile Picture
    accountinguser2018 151 on at
    Run AP Aging in Smartlist
    “Document Type Returns and Credits”

    thanks Lisa. Does “document type” appear as a column? Will check tomorrow morning
    the doc types are invoice, payments, returns, credits?
     
    also, why Current Trx Amt <>0 if it will only return positives? 
    ​​​​​​​amt does not equal to zero = what you are saying?
  • accountinguser2018 Profile Picture
    accountinguser2018 151 on at
    Run AP Aging in Smartlist
    Lisa,
     
    Based on your experience, what are all the columns you suggest running in this report, that would be most beneficial for the user?
  • accountinguser2018 Profile Picture
    accountinguser2018 151 on at
    Run AP Aging in Smartlist
    Which column in Smartlist do you select to show entity # or company #?

    This is probably the last thing I need. Is there an entity #/company # column to be added, so I can only look at certain companies?
    Or is there a GL Distribution String which would contain the entity# in the string?

    Thank you so much.  Very helpful.
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 874 Super User 2025 Season 2 on at
    Run AP Aging in Smartlist
    Regarding common columns, starting with the Transaction by Vendor* default favorite is a good starting point and then adding/removing columns that are needed in your environment.  (For example, some clients want to see Vendor Class ID where others may want to see a user-defined field or Payment Priority.  Or all of them. 😊)

    Regarding Entity #, are you using MEM?  If so, you should see them as columns to select.  (If they are on a default SmartList and missing on a new favorite, there may be some SQL work required to get the data populated.)
  • accountinguser2018 Profile Picture
    accountinguser2018 151 on at
    Run AP Aging in Smartlist
    Lisa, Thanks for the information.

    It looks like we have MEM. Please could you guide on how to go about adding the Entity # column?
     
    Under Columns, what would be selected for Entity #? Not sure if SQL intervention is possible. Would the column show under Smartlist Builder?

    Is there a GL Distribution string I can add in case your option is not available? That should show entity # within string? That may work.
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 874 Super User 2025 Season 2 on at
    Run AP Aging in Smartlist
    the MEM columns should have been added during the MEM installation/activation.  If there has been a change to the MEM setup, there may be a SQL "fix" required to get the column visible on the favorites that don't show it.  If you don't have access to the MEM Portal login (binarystream.com), you should request it.  It is an excellent technical reference for MEM.  Both this Binary Stream (MEM) site and eOne (SmartList Builder) Sign In | eOne Solutions site have tips on MEM with SmartList Builder.

    https://learn.microsoft.com/en-us/troubleshoot/dynamics/gp has some troubleshooting tips for SmartList.  (Filter by the "SmartList" keyword to get a subset of articles.)
     
    SmartList Tips - search (jenkuntz.ca) is an excellent blog post by a GP MVP.
  • accountinguser2018 Profile Picture
    accountinguser2018 151 on at
    Run AP Aging in Smartlist
    Thank you.
     
    Could you please tell me exactly what the MEM columns needed are called that would show entity # or company #? Maybe they are in my interface. Any information is greatly appreciated
     
    Or is there a GL /Distribution String column that can be added in my current setup amongst the 200+ options that shows the expense distribution? This may be all that is needed.
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 874 Super User 2025 Season 2 on at
    Run AP Aging in Smartlist
    The EXACT name of the MEM fields are depending on your MEM setup.
     
    You aren't going to find GL distribution information in the Payables Transactions.  It is based on the document header-level information.  (The Account Transactions SmartList is the best source for GL distribution information.)
     
    Good luck with your SmartList setup ... It is a great tool for getting to your GP data and worth investing some time in familiarizing yourself with all the different components.  Send a Community message to me if you would like a link to a GP 2016 SmartList navigation eLearning video Microsoft released many years ago.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 636

#3
Martin Dráb Profile Picture

Martin Dráb 553 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans