Open Forum

AR Invoice and related Check Numbers and Dates

  • 1.  AR Invoice and related Check Numbers and Dates

    Posted Jun 19, 2019 04:33 PM
    Is there a query (or report) for AR that will show Customer, AR Invoice Number, Invoice Date, as well as payment check number and date? Or any other report that would let us know what AR Invoices include subcontractor invoices with breakdowns of those said Subcontractor invoices and Invoice Date?

    Thank you!


    ------------------------------
    Janet Melena
    Kier & Wright Civil Engineers & Surveyors, Inc
    Livermore CA
    ------------------------------


  • 2.  RE: AR Invoice and related Check Numbers and Dates

    GOLD CONTRIBUTOR
    Posted Jun 19, 2019 04:52 PM
    I think the closest you'll come without customizing is the Detail format of the AR Payment Applications report.

    ------------------------------
    Jonathan Van Houtte
    Architect
    XLstatements, LLC
    Clifton Park NY
    ------------------------------



  • 3.  RE: AR Invoice and related Check Numbers and Dates

    Posted Jun 20, 2019 06:24 PM
    I normally use AR Payment Applications to get the details for batches that I post. Unfortunately it doesn't have all of the information that I was looking for. I may try a custom QQ, but thank you so much for your help!

    ------------------------------
    Janet Melena
    Kier & Wright Civil Engineers & Surveyors, Inc
    Livermore CA
    ------------------------------



  • 4.  RE: AR Invoice and related Check Numbers and Dates

    BRONZE CONTRIBUTOR
    Posted Jun 20, 2019 09:14 AM
    Janet,
    There is a quick query call AR Payment Applications out of the box that will give you what you need.

    ------------------------------
    Jenny Dinh
    CFO
    Noble Resources Corp
    Tampa FL
    ------------------------------



  • 5.  RE: AR Invoice and related Check Numbers and Dates

    SILVER CONTRIBUTOR
    Posted 9 days ago

    Hi Jenny,
    We are using Dynamics 2015, and I don't see the QQ AR Payment Applications.  Am I just missing it, or are you running 2018 and it is included in 2018?
    Thanks!

    Cathy



    ------------------------------
    Cathy McCarter
    Financial Analyst
    Innovative Wireless Technologies
    Lynchburg VA
    ------------------------------



  • 6.  RE: AR Invoice and related Check Numbers and Dates

    BRONZE CONTRIBUTOR
    Posted Jun 20, 2019 10:46 AM

    Check with Synergy Business Solutions, they have written a custom Quick Query for AR Apply and AP Apply.

     

    Cindy Smith cindy@synergybusiness.com 

     

    Thad Vesely

    Controller  |  T 425.455.9720  |  D 425.214.5075  |  C 206.771.0262  |  F 425.455.9732  |  tvesely@kbacm.com
    KBA, Inc.  Construction Management Specialists  |  www.kbacm.com

     






  • 7.  RE: AR Invoice and related Check Numbers and Dates

    Posted Jun 20, 2019 06:26 PM
    Thanks, Thad! I did reach out to Cindy to see if her QQ would work. Fingers crossed! Thanks again.

    ------------------------------
    Janet Melena
    Kier & Wright Civil Engineers & Surveyors, Inc
    Livermore CA
    ------------------------------



  • 8.  RE: AR Invoice and related Check Numbers and Dates

    Posted 9 days ago
    I am looking for something similar to this but need to be apply to filter by project.  Are you aware of any options for that?  Thanks, Gina Hammock

    ------------------------------
    Gina Hammock
    Controller
    Cleveland Group, Inc.
    ------------------------------



  • 9.  RE: AR Invoice and related Check Numbers and Dates

    BRONZE CONTRIBUTOR
    Posted 6 days ago

    Not in QQ.  We have SSRS reports to filter by project. 

     

    Thad Vesely

    Controller  |  T 425.455.9720  |  D 425.214.5075  |  C 206.771.0262  |  F 425.455.9732  |  tvesely@kbacm.com
    KBA, Inc.  Construction Management Specialists  |  www.kbacm.com