Open Forum

Expand all | Collapse all

Payables Control Batch Totals

  • 1.  Payables Control Batch Totals

    TOP CONTRIBUTOR
    Posted 16 days ago
    Hello,
    In the Payables Batch Entry screen there is a Control and Actual Transaction Count and Batch Totals. I'm looking for a report or SmartList I can use to pull this data. Does anyone know what fields I would need to bring in to see this? Thanks!



    ------------------------------
    Amber Schmoll
    Accounting Supervisor
    Milk Source LLC
    Kaukauna WI
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Payables Control Batch Totals

    GOLD CONTRIBUTOR
    Posted 14 days ago
    Hey Amber - I hope you are doing well!

    There isn't a SmartList out of the box in GP that pulls the batch information.  These fields are stored in the SY00500 table in the company database for all batches (all modules).  You can create a SmartList with Builder or Designer to pull this information.

    Hope that helps - take care!

    ------------------------------
    John Kirsch
    GP Product Lead
    Dynamic Consulting
    Green Bay WI
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Payables Control Batch Totals

    TOP CONTRIBUTOR
    Posted 14 days ago
    Thanks for the help John!

    ------------------------------
    Amber Schmoll
    Accounting Supervisor
    Milk Source LLC
    Kaukauna WI
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Payables Control Batch Totals

    GOLD CONTRIBUTOR
    Posted 14 days ago
    Amber,
    Just an additional note to this.  The batch record in the SY00500 typically gets deleted for non-recurring batches when the batch is posted complete.  So those batch control totals will not be available after it is posted.

    ------------------------------
    Andrew Kennedy
    Principal Consultant
    Velosio
    Seven Hills OH
    ------------------------------

    Academy - Online Interactive Learning from Experts


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