Open Forum

Expand all | Collapse all

GP2013 to GP2018 Building a payment batch

  • 1.  GP2013 to GP2018 Building a payment batch

    Posted May 10, 2019 12:16 PM
    What is the difference in building a batch for payments in GP2018?  I am now doing it in Edit Payment Batch and choosing multiple vendors, but I need to Build a Payment Batch so it doesn't auto-apply any credits for that vendor and was told that was the only location to do that.  However, when I Build a Payment Batch, it chooses all vendors even if they have a zero balance.  At that point I have deselect and is not efficient.  What am I doing wrong here?  Thank you,

    ------------------------------
    Kellie Bennett
    Senior Accounts Payable Specialist
    AWL
    Mission KS
    ------------------------------


  • 2.  RE: GP2013 to GP2018 Building a payment batch

    TOP CONTRIBUTOR
    Posted May 14, 2019 09:51 AM
    Hi Kellie,

    Have you tried unmarking the "Print Previously Applied" checkbox (in addition to unmarking the "Automatically Apply Existing Unapplied")?

    Testing Details:
    Data:
    V01: $100 invoice, $100 manual payment (applied to invoice upon posting)
    V02: $200 invoice, $200 manual payment (unapplied)
    V03: $300 invoice only

    Test 1 - Build Payment Batch, unmarked "Automatically Apply Existing Unapplied":
    • Generated the Computer Check Edit List - there were 3 checks generated, one of them is a zero dollar check.

    Test 2 - Build Payment Batch, unmarked "Automatically Apply Existing Unapplied" + unmarked "Print Previously Applied":
    • Generated the Computer Check Edit List - there were only 2 checks generated.
    ​​

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



  • 3.  RE: GP2013 to GP2018 Building a payment batch

    Posted May 14, 2019 03:13 PM
    I will consider looking at that.  I don't want it to auto-select my vendors either.What are you clicking on to build it?  Build Batch, Edit Payment Batch or Edit Vendor Payments?

    ------------------------------
    Kellie Bennett
    Senior Accounts Payable Specialist
    AWL
    Mission KS
    ------------------------------



  • 4.  RE: GP2013 to GP2018 Building a payment batch

    TOP CONTRIBUTOR
    Posted May 14, 2019 03:34 PM
    Hi Kellie,

    I used the "Build Batch" button in my testing.

    At any rate, I would recommend setting up a test company with a copy of the live database so it would be easier to simulate this on your end. You might need to collaborate with your IT department for this though.

    Here's the KB link just in case:
    KB - Set up a test company that has a copy of live company data for Microsoft Dynamics GP by using Microsoft SQL Server


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



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