Schema / tables for checkbook to vendor and GL account

  • Schema / tables for checkbook to vendor and GL account

    Posted by DSC Communities on February 13, 2017 at 9:15 am
    • Tom Repetti

      Member

      February 13, 2017 at 9:15 AM

      I need to write a report that gives me the vendor information and GL distributions for certain checks.  I am having difficulty in finding the tables/fields that link these 3 sources together. 

      And if it matters, I will need to run this report for transactions spanning 3 years, so there might be more tables storing the data.

      Thanks

      ——————————
      Tom Repetti
      Comport
      Ramsey NJ
      ——————————

    • Kelly Hobart

      Member

      February 13, 2017 at 10:46 AM

      A good place to start is by visiting the screen with the bulk of the information you are looking for and then using table finder to determine the sql tables included.

      ——————————
      Kelly Hobart
      Business Data Analyst
      Mount Pleasant Waterworks
      Mount Pleasant SC
      ——————————
      ——————————————-

    • Victoria Yudin

      Member

      February 14, 2017 at 4:32 AM

      Hi Tom,

      I have SQL code on my blog to help with this. Here is the main page for Payables code:
      Payables SQL Views

      From what you wrote, I think you’re looking for Payment Apply Detail and GL distributions, but I wanted you to see the entire list.

      ——————————
      Victoria Yudin
      Microsoft Dynamics GP MVP 2005-2017
      Flexible Solutions, Inc.
      http://www.GPReportsViewer.com
      http://victoriayudin.com
      ——————————
      ——————————————-

    • Tom Repetti

      Member

      February 16, 2017 at 11:59 AM

      Thanks all and thanks Victoria.  The script worked for what I needed.

      ——————————
      Tom Repetti
      Comport
      Ramsey NJ
      ——————————
      ——————————————-

    • Leslie Vail

      Member

      February 27, 2017 at 8:04 PM

      Victoria is a Rock Star!

      ——————————
      Leslie Vail
      Accounting Systems Consulting, Inc.
      Dallas TX
      ——————————
      ——————————————-

    DSC Communities replied 7 years, 4 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Schema / tables for checkbook to vendor and GL account’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

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!