Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Smart List Builder - ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Smart List Builder - Link Unposted Payment Batch to GL distribution

(0) ShareShare
ReportReport
Posted on by WL_ 5

Hi all, 

Quite new to smart list builder especially the table behind it 

One of the tasks that we perform weekly is to check all the coding AP post, however the painful side is they're already posted so there is no way you can correct it apart from do a journal posting 

Does anyone knows if there is a way we can run a smart list before the batch gets posted ? 

I can filter Document Status "unposted" under "Payable Transactions" to find those all of those yet to post batches

However I'm not sure which table can give me the account code that's used for each invoice?   

And if possible would I be able to pull out AA code as well? 

Version: Our GP is the on the very recent version 18.3

Thanks in advance

  • WL_ Profile Picture
    WL_ 5 on at
    RE: Smart List Builder - Link Unposted Payment Batch to GL distribution

    Hi Vctoria

    That is a very resourceful link

    I have been playing with each table you mentioned to see the contents of each

    Can I ask if I wish to incorporate Analytical Accounting code which table/tables should I be using?

    Regards,

    Wendy

  • WL_ Profile Picture
    WL_ 5 on at
    RE: Smart List Builder - Link Unposted Payment Batch to GL distribution

    Thanks Gavin 

    I have pulled out the transactions and they are exactly what I was looking for 

    Will start fine tune the content to get the rest of the info needed 

    Regards,

    Wendy

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: Smart List Builder - Link Unposted Payment Batch to GL distribution

    HI WL, 

    Another option would be to create a SQL view first, then use it in SmartList Builder. My blog has code for getting all GL distributions for payables transactions here: | SQL view for Payables GL distributions in Dynamics GPVictoria Yudin

    You could leave it as is, or change it to only pull in unposted transactions. Then just set it up as a new SmartList in SmartList Builder.

    Victoria

  • Gavin Profile Picture
    Gavin 2,339 on at
    RE: Smart List Builder - Link Unposted Payment Batch to GL distribution

    Hi,

    If you are using eOne smartlist builder then one you can import one of their smartlist templates directly from their web site.

    Below are templates that would include PM distributions and this is the link that explains how to do it. www.eonesolutions.com/.../toc377551035.php

    pastedimage1617714066374v1.png

    If you were to build your own smartlist object the SQL table name for unposted payables distributions is PM10100 (its name in smartlst builder would be PM Distribution WORK OPEN)

    I hope this helps

    Thanks

    Gavin

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans