Open Forum

Expand all | Collapse all

Adding Field to Trial Balance Report

  • 1.  Adding Field to Trial Balance Report

    Posted May 16, 2019 12:57 PM
    Is there an easy way to add the Batch ID field to the Detail Trial Balance report in Report Writer?
    I can't find the field/table.
    We are using Dynamics GP 2016.

    Thank you in advance.

    Batch ID Field

    Trial Balance Report

    ------------------------------
    Lynne Navis
    Accounting Manager
    ACSESS
    Madison WI
    ------------------------------


  • 2.  RE: Adding Field to Trial Balance Report

    TOP CONTRIBUTOR
    Posted May 16, 2019 01:30 PM
    Hi Lynne,

    Based on my testing, you might be looking for the Originating Source field from the Year-to-Date Transaction Open table?
    (screenshots below)



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



  • 3.  RE: Adding Field to Trial Balance Report

    Posted May 17, 2019 11:42 AM
    Thank you! That worked.

    ------------------------------
    Lynne Navis
    Accounting Manager
    ACSESS
    Madison WI
    ------------------------------



  • 4.  RE: Adding Field to Trial Balance Report

    TOP CONTRIBUTOR
    Posted May 17, 2019 03:50 PM
    You're welcome, Lynne. :)

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



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