Open Forum

Expand all | Collapse all


  • 1.  NOLAN ABR

    Posted Jun 12, 2019 09:25 AM
    I am hoping that someone has had this question before

    I have been tasked for month end bank recs for check books in ABR

    The checkbooks that use GP are fine --- the last reconciled amount and the last date reconciled are available in the CM00100 table

    We have many entities and many checkbooks - some use GP and some use ABR

    I am trying to create a view that I can use in a smartlist ---- no problem for the GP checkbooks

    I am trying to link in the ABR data ---- any help or guidance is greatly appreciated

    Douglas Hart
    Dynamics Administrator
    Forex Capital Markets
    New York City NY
    (646) 432-2703

  • 2.  RE: NOLAN ABR

    Posted Jun 12, 2019 12:20 PM
    Hi Douglas,

    You would probably want to start with determining the windows you're planning to get the information from... then you can make use of the information from @David Musgrave's article below... though I'm sure he has more recommendations as this article was written in 2008.

    Once you know the tables to reference, creating a SQL view would be an easy task.

    Finding Table and Field Information in Microsoft Dynamics GP

    Ryan Galang
    BTP Technologies LLC
    Chantilly VA


If you've found this thread useful, dive deeper into User Group community content by role