Skip to main content
Microsoft Dynamics GP forum
Suggested answer

Run AP Aging in Smartlist

editSubscribe (0) ShareShare
ReportReport
Posted on by 129
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:
Attachments
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,965 on at
  • accountinguser2018 Profile Picture
    accountinguser2018 129 on at
    Run AP Aging in Smartlist
    Thanks, Lisa.
     
    Below is my post created in another thread, but probably goes here instead. Would you have a quick solution for this? You've been a huge help.
     
    What would the reason be that an A/P Aging run in the Purchasing module wouldn't tie to a Smartlist A/P listing, where the same parameters are set?
    The Smartlist has several numbers to net out (as they all appear as positives), am aware of that.
     
    I'm looking for the quickest way to run an A/P Aging to excel, which is accurate. The one run in the purchasing module (and sent to CSV) is very clunky and outside of using a macro, is very cumbersome to deal with.
     
    Can a report run in Smartlist be used as an AP Aging? Want to sure it is 100% accurate. I can add the aging buckets later on.
  • Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,965 on at
    Run AP Aging in Smartlist
    @AccountingUser2018 - Good question about how to send a message ... I see messages in my profile but I don't know how to actually send one.  If you click on my name and open my profile, there is a link to my LinkedIn profile.  Try sending a message that way.  
  • accountinguser2018 Profile Picture
    accountinguser2018 129 on at
    Run AP Aging in Smartlist
    "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."
     
    How does one go about sending a community message? Very interested in this Smartlist navigation eLearning video.
  • Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,965 on at
    Run AP Aging in Smartlist
    SmartList > Financial > Account Transactions does not have the apply information you would need to back into open payables.  (Building that relationship would require SQL access/expertise.)
     
    Since you have SmartLIst Builder, reach out to eOne support.  They do a great job supporting their products and should be able to walk you through the templates KB you found on their site.
  • accountinguser2018 Profile Picture
    accountinguser2018 129 on at
    Run AP Aging in Smartlist
    Lisa,
     
    Could one use the The Account Transactions SmartList, filter by 'Purchasing', and then filter further to see if it has been paid? From that Smartlist, can you see what is Open A/P as of today?
     
    You have been very helpful. Thank you very much.
  • Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,965 on at
    Run AP Aging in Smartlist
    eOne, or someone more familiar with their SmartList Builder templates, will need to answer your question about their tech document/templates.
  • accountinguser2018 Profile Picture
    accountinguser2018 129 on at
    Run AP Aging in Smartlist
     
    Lisa,
     
    If using the above link for SmartList builder, where would these new columns appear afterward?
     
    Where can these be found or what would the columns be named?
     
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,965 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.
  • accountinguser2018 Profile Picture
    accountinguser2018 129 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.

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,166 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,703 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans