Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

Can integration manager apply multiple cash receipts across customers to specific invoices?

  • 1.  Can integration manager apply multiple cash receipts across customers to specific invoices?

    Posted 11 days ago
    ​We use an integration manager to upload a cash receipt that is applied to multiple customers but it auto-applies to the oldest invoice first...  This causes us to have misapplied payments.  Has anyone used an integration manager to apply cash across multiple customers where the specific invoice is identified for the cash receipt to be applied to??

    ------------------------------
    Stephanie Shulman
    Optos INC
    Marlborough MA
    ------------------------------


  • 2.  RE: Can integration manager apply multiple cash receipts across customers to specific invoices?

    TOP CONTRIBUTOR
    Posted 10 days ago
    ​Hi Stephanie,

    You may want to look at the lock box feature to make this work. It has a lot of control over the process and more interactive.

    Lockbox Processing with Dynamics GP
    Dynamics remove preview
    Lockbox Processing with Dynamics GP
    Dynamics GP includes functionality to automatically create cash receipts transactions in GP based on...
    View this on Dynamics >


    ------------------------------
    Mark Wiley
    Senior Consultant
    DXC Technology
    Akron, OH
    ------------------------------



  • 3.  RE: Can integration manager apply multiple cash receipts across customers to specific invoices?

    TOP CONTRIBUTOR
    Posted 10 days ago
    ​I'm not really sure what you mean by "multiple customers".  There are options in the integration for Cash Applications that allow you to specify the document to apply the cash to.  This would mean that the information source would have to contain that data and have the payments broken out by document number.

    Cash Apply options in Cash Receipts Integration

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise ID
    ------------------------------



  • 4.  RE: Can integration manager apply multiple cash receipts across customers to specific invoices?

    TOP CONTRIBUTOR
    Posted 10 days ago
    Stephanie - we used an integration to process EFT cash receipts. I believe in the mapping, you can use a source field from your text file (or other source) to tell it which document to apply it to, if that is what you are getting at. See screen shots below. In the mapping, under the Cash Receipts folder, highlight the Cash Apply and you'll see the Apply-To Document number field - we've mapped a specific document from our text file to this GP field.

    ​​

    ------------------------------
    Tiffany Ziegler
    Vice President & Controller
    Velcor Leasing Corporation
    Madison WI
    ------------------------------