Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Julia Udal]

?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
——————————

[Beth Villotti]

We use the Cash Applied report in NAV 2016.

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

[Julia Udal]

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
——————————
——————————————-

[Jamie Constantine]

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
——————————
——————————————-

[Leo Chen]

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
——————————
——————————————-

[Janice Taylor]

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
——————————
——————————————-