Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Payables Transaction Inquiry

Posted on by 5

I need some help to figure out what is causing the sequence of the transactions to show-up backwards, the payments are showing above the invoice in our payables transaction inquiry window . This is causing confusion when looking up payment information. Does anyone know what would cause this issue to occur or how to fix it? Below is screenshot of the account Thank you for your help!

pastedimage1568400185437v1.png

*This post is locked for comments

  • sferreira Profile Picture
    sferreira 5 on at
    RE: Payables Transaction Inquiry

    Good morning! No, we have not made an updates to the system at this time but plan on doing so in January 2020 to the most recent version of GP. Thank you for your help, its a relief to know this is not impacting the data within the system.

  • JodeRuiter Profile Picture
    JodeRuiter 978 User Group Leader on at
    RE: Payables Transaction Inquiry

    Good Morning!

    Have you recently had any updates to GP installed on the machine?

    Either way, though, I don't think this is worth worrying over.  BUT, if you use the drop down and search by document date you will get the documents on the same date but in alphabetical or sequential order, if you just search by document ID you will get them in a different order.   It has no bearing, though, on the health of your GP data (generally speaking, and unless you are having other data-issue symptoms).

  • sferreira Profile Picture
    sferreira 5 on at
    RE: Payables Transaction Inquiry

    Sorry about that, I should have included the entire dialog box. It is the most odd error I have seen and cannot figure it out, sometimes the transaction will show in sequence of posting (Invoice then Payment) but for the most part it has recently started showing us the Payment then the Invoice.

    pastedimage1568644506972v1.png

  • JodeRuiter Profile Picture
    JodeRuiter 978 User Group Leader on at
    RE: Payables Transaction Inquiry

    The Payments and Invoices appear to be happening on the same date.  I cannot see how you may have this screen filtered, but it appears that the Document Numbers are in numerical order based on the date and doc number as opposed to document type.

    So your window is listed by Date and then Document Number.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans