PS Query & SQL

 View Only

Following deposit payments through their lifecycle

  • 1.  Following deposit payments through their lifecycle

    Posted 07-14-2025 10:51 AM

    Hello,

    I'm curious if anyone has a good sql for the best way to follow the actions taken on payments for deposits in the FIN AR module. I've had to work with our general accounting team a few times when things pop up in GL reconciliation relating to these items, and it tends to get convoluted, quickly.

    Does anyone have a sql that helps easily identify what has actually happened to the payments (unpostings, moving to different items/customers, etc...)?

    Any help would be greatly appreciated!

    Thanks,



    ------------------------------
    Andy Roberts
    Business Analyst
    State of Minnesota
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------
    Alliance 2026 Registration is Open!