No data entity for the two tables , CustTransOpen and VendTransOpen, for unsettled transactions. We need to use the data entities for these tables to display unsettled transactions in Power BI.

These tables are used in the following forms in D365FO.

(a) Table : CustTransOpen
Menu path : Account Receivables > All customers > COLLECT > Settle transactions

(b) Table : VendTransOpen
Menu path : Account Payables > All vendors > INVOICE > Settle transactions