Reply To: Customer Transaction report

  • Jo deRuiter

    Member
    March 14, 2024 at 10:24 am
    Up
    0
    Down
    ::

    Hi @stephaniemyers

    @david-morinellotruckpro-com is accurate, there are no out of the box SmartLists for seeing what check or credit memo applied to what invoice or vice versa.

    Victoria Yudin produced several SQL Views that can help create that SmartList. There are steps to getting this done.

    1) Create the SQL view in SQL (you may need your IT or Partner to help you with this)

    2) Grant Security to the view to Dyngrp

    3) Use SmartList either with SmartList Builder or SmartList Designer – whichever you guys have – and link to that view

    Then you will have the needed SmartList.

    This is the page on Victoria Yudin you would use for the SmartList you are looking for.

    https://victoriayudin.com/2010/02/15/sql-view-with-ar-apply-detail/

    Granted, you may want more fields than she has here and that’s where you can ask your IT, partner, or trusted consultant to build a more thorough report for you!

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!