Multi-Batch Report with Fee Rows
================================
.. include:: MultiBatchSummary.rst

.. note::
    When configured, the report can be run by the Report option on the Caret (downward-facing
    arrow) drop down menu just to the left of the **Batch ID** column header.

    See :ref:`image below <MultiBatchReportLink>`.

.. glossary::

    Multi-Batch Report with Fee Rows

        This report provides the following information for the selected batches
       
        Header, showing the list of selected batches
            -  Batch ID
            -  Deposit Date
            -  Batch Type
            -  Estimated Amount
            -  Estimated Count
            -  Actual Amount
            -  Actual Count
            -  Bankcard Amount
            -  ACH Amount
            -  Cash Amount
            -  Check Amount

        Details of the contents of the selected batches
            -  Date
            -  Fund
            -  General Ledger
            -  Count
            -  Amount

        In the details, fund subtotals are given, grouped by date, subtotals for each date, 
        and a grand total at the bottom of the report. The fund subtotals include only the base amount (without fees) and fees are shown on a separate row for each day there were fees.

.. _MultiBatchReportLink:

.. figure:: https://i.tpsdb.com/2023-07-05_15-22-33.png
    :target: #

    Report Menu Option

.. figure:: https://i.tpsdb.com/MultiBatchReportF.png
    :target: #

    Sample Report

Create the Multi-Batch Report
-----------------------------

Step 1
    Go to `Administration > Setup > Special Content > Python Scripts`.

Step 2
    Click the green `+ New Python Script File`, enter the file name ``MultiBatchReportF``
    and click `Submit`.

Step 3
    :ref:`Copy all the Python code below<MultiBatchReportFCode>` and paste it into the new file.

    Click `Save Script`.

Step 4
    Go to `Administration > Setup > Special Content > SQL Scripts`.

Step 5
    Click the green `+ New SQL Script File`, enter the file name ``MultiBatchReportFsql``
    and click `Submit`.

Step 6
    :ref:`Copy all the SQL code below<MultiBatchReportFsqlCode>` and paste it into the new file.

    Click `Save Script`.

Step 7
    -  Find the Setting ``Custom Batch Report`` at `Administration > Setup > Settings` on the Finance tab and in the Batches category
    -  Paste this as the value - ``/PyScript/MultiBatchReportF?p1={batchids}``

.. note::
    Each database can have only one Multi-Batch Report. So, the Setting is just named
    **Custom Multi Batch Report** and the Value determines which is used.

Generate the Multi-Batch Report
-------------------------------
To generate the report, select the desired batches to include in the report, then select
the Report option from the Caret (downward-facing arrow) drop down menu just to the left of 
the **Batch ID** column header.

Use the print feature of your browser to print the report. Click the `Export to Excel`
button to export.


Python Code
-----------

.. _MultiBatchReportFCode:

.. literalinclude:: Files/MultiBatchReportF.py
    :linenos:

SQL Code
--------

.. _MultiBatchReportFsqlCode:

.. literalinclude:: Files/MultiBatchReportFsql.sql
    :linenos:


|
|

+--------------------+------------------+
| **Latest Update**  | **10/06/2023**   |
+--------------------+------------------+

Added this article