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

[Jennifer Vanselow]

We are trying to build a cross company accounts receivable aging report and was advised these are the two tables to reference:

1. CustTransOpen
2.  CustSettlement

What data entities can be used to get this information?  Or in other words, what are the names of the data table entities?

——————————
Jennifer Vanselow
Augeo Affinity Marketing
St. Paul MN
——————————

[Alex Meyer]

Jennifer,

Does the CustAgedBalances Data Entity give you the data you need?

Looking at object references, the CustTransOpen table is a datasource to the CustomerPaymentJournalLineSettledInvoiceEntity and the CustSettlement table is not a direct data source to any data entities.

——————————
Alex Meyer
Director of Dynamics AX/365 for Finance & Operations Development
Fastpath
Des Moines, IA
——————————
——————————————-