Open Forum

Expand all | Collapse all

NOLAN ABR

  • 1.  NOLAN ABR

    GOLD CONTRIBUTOR
    Posted 5 days ago
    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
    ------------------------------
    GPUG Summit - Post


  • 2.  RE: NOLAN ABR

    GOLD CONTRIBUTOR
    Posted 5 days ago
    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
    https://blogs.msdn.microsoft.com/developingfordynamicsgp/2008/10/04/finding-table-and-field-information-in-microsoft-dynamics-gp/


    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    Chantilly VA
    ------------------------------

    GPUG Summit - Post


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