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

[Katie Pieczynski]

I have tried searching and could not find anything but I was wondering if anyone had  view for “current Receivables Aging by line item?
I have one for the header that I had combined with the RM Customer Master that gives me the ID/Name/Docnum/and the aging buckets, but I would like it to include each item number on that invoice as well so I can match up returns.

Basically we have a “loan account” that has many invoices on it that may or may not have partial returns.  I need to see what all has been returned on that invoice and what is still left open.  So if anyone has a good report for that or what tables I would need to build it, I would really appreciate it!

Thank you,

——————————
Katie Pieczynski
Accounts Receivable Manager
DANSR
Champaign IL
——————————

[Cecile Dinh]

Hi Katie,

You might want to check on this by Victoria Yudin.
https://victoriayudin.com/2013/05/01/sql-view-for-current-receivables-aging-detail-in-dynamics-gp/

——————————
Cecile Dinh
GP Admin at ARC (Airlines Reporting Corp.)
GPUG Chapter Leader – Washington, D. C.
——————————
——————————————-

[Aref Karam]

Hi Katie,

GP doesn’t apply payments to the individual line items on an invoice, but if you just want the line items to show on the report provided, you can link that to the SalesLineItems SQL view.
?

——————————
Aref Karam
Data Consultant
LTI Information Technology
Ann Arbor MI
——————————
——————————————-