Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Payables Transactions

(0) ShareShare
ReportReport
Posted on by 40

Hi.. Can you please help me with how to downloading payables transactions into Excel? Basically, I would like to run a report which shows all invoices posted to AP ledgers in a certain date range with their status.

Please see attached.Doc1.docx:320:240

Categories:
  • Tuba Olkun Profile Picture
    Tuba Olkun 40 on at
    RE: Payables Transactions

    Thank you!

  • Tuba Olkun Profile Picture
    Tuba Olkun 40 on at
    RE: Payables Transactions

    It worked. Thank you!

  • Tuba Olkun Profile Picture
    Tuba Olkun 40 on at
    RE: Payables Transactions

    It worked. Thank you!

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: Payables Transactions

    Tuba,

    As you mentioned it's pretty old version may be it wouldn't have filter available for History transactions.

    Please go to search window and try to check if History option is available for Document Type? Also change max records to 9999999999

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payables Transactions

    Hello Tuba,

    Document Status will have (UnPosted / Posted / History). As I see you have limited your Smartlist search to 1000 records. Request to higher number to fetch the records and you can see History status documents as well.

  • Tuba Olkun Profile Picture
    Tuba Olkun 40 on at
    RE: Payables Transactions

    Thanks Almas. I'm not sure if the one I use is a custom product but I know that it's an old version.

    Please see attached. When I click on SmartList then Payables Transactions the list appear with only two statuses of document; posted and unposted; in example it doesn't have "history" status which means paid.

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: Payables Transactions

    Tuba,

    The window in screen shots don't looks like GP window? Do you have any custom product ?

    You can however export payables transactions from smartlist. See below screenshot.

  • StefanieC Profile Picture
    StefanieC 432 on at
    RE: Payables Transactions

    Hi Tuba,

    Have you looked at SmartList.  Click the Microsoft Dynamics GP button and SmartList is under there.  You can expand the Purchasing section and then Payables transaction.  This tool lets you add/remove columns as well as put in some filters using the Search button.  Once you get what you want, you can simply click the Excel button.  It works for many uses but not all.

  • Tuba Olkun Profile Picture
    Tuba Olkun 40 on at
    RE: Payables Transactions

    That's correct, but I don't see an Excel box to click on to export in the screenshot I sent.

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: Payables Transactions

    You mean you want to export GP Posted Payables transactions to excel ?

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans