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
    Academy - Online Interactive Learning from Experts

  • 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

    Academy - Online Interactive Learning from Experts

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