Open Forum

Expand all | Collapse all

Cash receipt paying 1000-5000 invoices

  • 1.  Cash receipt paying 1000-5000 invoices

    Posted Jan 29, 2020 10:06 AM
    Hi all.  We're on NAV 2015 and we a few customers that pay anywhere between 1000 and 5000 invoices with one ACH.  I've tried using copy-paste into a Cash Receipts Journal but that freezes up for about 10 minutes.  I've tried using Rapid Start but the Applies-to Doc number doesn't import from the rapid start spreadsheet to the cash receipts journal.  Any insight would be greatly appreciated.

    ------------------------------
    Bruce Ostrowsky
    World Emblem International
    Hollywood FL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Cash receipt paying 1000-5000 invoices

    TOP CONTRIBUTOR
    Posted Jan 30, 2020 07:30 AM
    First, I am not a developer so someone else will have to comment on the code.  Rapid start feels like the right solution.  Have you considered creating some logic that puts all of these invoices into their own batch in the journal where the Applies to Doc number defaults based on the batch?

    A second option, after you upgrade to BC, is Edit in Excel.  Lines can be added so with some mapping you could populate the cash receipts Edit in Excel doc then publish it back to BC with validation.  This may have been one of the reasons why Microsoft created the tool because of the challenges that you are facing.

    Please share what you implement to solve this one.  Thanks and good luck!

    ------------------------------
    Jason Nicolaou
    Engagement Manager
    Sikich, LLP
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Cash receipt paying 1000-5000 invoices

    GOLD CONTRIBUTOR
    Posted Jan 30, 2020 12:55 PM
    The application process temporary inputs data in the Applied Doc Type and Application ID fields on the Customer ledger table.   Can you create a Rapidstart table for the customer ledger table (T21) for these two fields (as well as the unique ID, Invoice No.)?    Technically inputting into the CLE table is not allowed, but those fields are editable manually when you open the table.   Once the data is in those fields, you should be able to use the standard application page to push post.
    applies to Doc Type = "payment"
    applies to Doc No. = the document no that you have assigned to the payment.

    Curious if this works.  Let me know if you try it, have questions, and what the results are.

    ------------------------------
    Jamie Constantine
    Columbus Global
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Cash receipt paying 1000-5000 invoices

    TOP CONTRIBUTOR
    Posted Jan 31, 2020 05:50 PM
    I'll throw one more option out there.  With so many invoices being paid at one time, do you need to apply payments to specific invoices?  If not, you could look into changing the Application Method on the customer card from "Manual" to "Apply to Oldest".  Then, you could just post the payment and allow the system to apply invoices starting at the oldest and continuing to apply to invoices until the full payment amount is applied.

    ------------------------------
    David Wiser
    Client Lead
    Tigunia
    2019-2020 Board of Advisors
    BCUG|NAVUG All-Star
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Cash receipt paying 1000-5000 invoices

    Posted Feb 01, 2020 03:58 PM
    Thanks everyone for your suggestions.  All that was needed was to add Field ID 1224, Applied Automatically to the Rapid Start template.  On the spreadsheet, mark the value to TRUE and I', now able to use the Rapid Start to import a Cash Receipts Journal and properly apply the payment to as many invoices as necessary.

    ------------------------------
    Bruce Ostrowsky
    World Emblem International
    Hollywood FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


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