Open Forum

Expand all | Collapse all

Account payable Monthly Batch Total Actual amount VS Batch Total Control amount

  • 1.  Account payable Monthly Batch Total Actual amount VS Batch Total Control amount

    Posted 17 days ago
    Good morning Team!

    When batch total actual amount does not match the total control amount in a monthly batch. how to fix this problem. We can not post the monthly batch because the actual and control batch do not match.

    Thank You for you help

    ------------------------------
    Nelly Manrique-Eells
    Catholic Human Services
    Philadelphia PA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Account payable Monthly Batch Total Actual amount VS Batch Total Control amount

    GPUG ALL STAR
    Posted 17 days ago
    @Nelly Manrique-Eells

    The Control Amount should not be a locked field and you can just change it.

    Can you change the control amounts?  If not, then your IT department has locked that field and you'll have to get in touch with them.

    ​Also, did you check to make sure you entered the batch correctly? The reason to use the control fields is so that you total up what you are about to do to ensure that the amounts will match and be able to troubleshoot if they don't.

    ------------------------------
    Jo deRuiter
    🌟 GPUG AllStar 2019
    💫Granite Award Winner 2018,2019
    Atlanta Chapter Leader
    Credential Council Co-Chair
    Aisling Dynamics Consulting, LLC
    ERP Practice Manager
    jo.deruiter@aislingdynamics.com
    9518674366
    Alpharetta, GA
    aislingdynamics.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Account payable Monthly Batch Total Actual amount VS Batch Total Control amount

    Posted 16 days ago
    A couple of things to review:
    - Are there Credit Memos in your batch?  If so, your Control amount may have included these recognizing them as negatives (depending on how your came up with the total) whereby your Actual Batch Totals will ignore sign (for amounts).
    - What is your Posting setup for this Series and Origin set to?  You will want to review the checkboxes - Verify Number of Trx and Verify Batch Amounts.

    Hope this helps.

    Sharon Nolan
    Senior ERP Consultant
    Heartland Business Systems

    ------------------------------
    Sharon Nolan
    Heartland Business Systems
    Little Chute WI
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Account payable Monthly Batch Total Actual amount VS Batch Total Control amount

    Posted 15 days ago
    Thank you.

    ------------------------------
    Nelly Manrique-Eells
    Catholic Human Services
    Philadelphia PA
    ------------------------------

    Academy - Online Interactive Learning from Experts


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