Open Forum

Expand all | Collapse all

Customer payment application history

  • 1.  Customer payment application history

    Posted Oct 11, 2019 01:00 PM
    ​Hello,

    We're in NAV 2013R2 and are looking for an easy way to get a history of how a customer's payments were applied (i.e. which invoices were cleared from AR by the payments made).  Haven't been able to find anything that shows that detail.  Please, point me in the right direction.

    Thank you!

    ------------------------------
    Julia Udal
    Havis Inc.
    Warminster PA
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Customer payment application history

    Posted Oct 14, 2019 08:53 AM
    We use the Cash Applied report in NAV 2016.

    ------------------------------
    Beth Villotti
    Controller
    Reaxis Inc.
    McDonald PA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Customer payment application history

    Posted Oct 15, 2019 11:09 AM
    Thanks, Beth.  That's the report I tried using and have noticed that any invoices that migrated in from our legacy system aren't showing up with "Applied To Doc No." information on the report.  Our development team is looking into the issue to see why that's going on.​​

    ------------------------------
    Julia Udal
    Havis Inc.
    Plymouth MI
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: Customer payment application history

    SILVER CONTRIBUTOR
    Posted Oct 14, 2019 09:55 AM
    Are you explicitly looking for a report, or just a way to analyze the data?
    I find the absolute best way is to review the Detailed Customer Ledger Entry table.    You could build a report off the Customer and Detailed Customer ledger entry tables.

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

    Conference-BCNAVUG_200x200


  • 5.  RE: Customer payment application history

    Posted Oct 15, 2019 12:58 AM
    Hi Julia - do you have access to Object Designer or using Jet Report?

    There are fields in Cust. Ledger Entrty (Table 21) that tell you how Invoices payment applied, or if invoice is still open, partially paid, etc.





    ------------------------------
    Leo Chen
    Systems Analyst
    Summit Fertilizers
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: Customer payment application history

    Posted Oct 16, 2019 01:11 PM
      |   view attached
    Hi Julia,

    Following up on Leo's idea, you could use a Jet Report for this. I've attached one for you. It will likely need tweaking.

    You have to be a Jet Reports customer for this to work. (It does not work for the Jet Basic product.)


    ------------------------------
    Janice Taylor
    Managing Director
    Reports Your Way Ltd.
    Toronto Canada
    ------------------------------

    Attachment(s)

    Conference-BCNAVUG_200x200


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