Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Payables Transactions

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

  • 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 10,996 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 10,996 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 10,996 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans