Open Forum

Expand all | Collapse all

Cash Application - RapidStart

  • 1.  Cash Application - RapidStart

    Posted Jul 29, 2019 11:55 AM
    Has anyone used RapidStart to post cash applications against open AR items? Trying to expedite the application of historical payments on our invoices. We are using NAV 2017. #BC/NAVPlus #NAV2017​​

    Lukas S

  • 2.  RE: Cash Application - RapidStart

    Posted Jul 29, 2019 02:35 PM
    Haven't done it before, but theoretically possible.  Assuming that you've already loaded the customer invoices, you would need to know the Customer Ledger Entry No. for the invoices you are going to apply payments to.  You would then need to add an entry to the Customer Ledger Entry for the payment amount.  Then, you would need to create entries to the Detailed Cust. Ledger Entry table to perform the application.  See the attached screenshot.  For the payment, you would need a line posting the Entry Type = "Initial Entry" of the total deposit amount.  The lines where Entry Type = "Application" which clears the deposit amount and posted the application to the open invoices.  You would probably need to do this in two steps as the application lines would need to reference the customer ledger entry numbers for both the original invoices and for the payment (which you would get until loading the payment.

    I haven't touched the bank account side.  You may not need to post anything there, but others may know more.  Obviously, this would be best tested in a Test environment first.  let us know how it works out.

    David Wiser
    Project Manager
    Seattle WA


  • 3.  RE: Cash Application - RapidStart

    Posted Aug 01, 2019 07:10 PM
    Actually, if you are importing payments into the cash receipts journal, you can populate the applies-to id as invoice, applies-to document number with the invoice number and you're good to go.  Assuming you identified the customer number, balanced the journal, etc.

    We even do this with a copy from excel and paste rows into NAV.  Using about 5-6 columns for many, many customers

    Kim Dallefeld
    Dallefeld Consulting, LLC
    Member of Dynamics Consulting Group
    Ft. Worth, TX
    2019 NAVUG Board of Advisors
    Past NAVUG Board Chairman
    NAVUG Programming Committee


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