PowerBI: VendInvoiceRegisterLines Entity and D365FO Invoice Pool

(0) Share

Report

Posted on by Ian Waring

442

I'm doing a Power BI model to spot Vendor invoices arriving before folks have goods receipted their purchase orders - then to nudge them to get the receipts done, so we can initiate three way matching successfully.

I've got an analogue of the Vendor Invoice Pool by listing out the VendInvoiceRegisterLines entity. However, that contains the total history of all vendor invoices on our D365FO system, whereas I only want to list the small subset of these that are currently in the invoice pool. I'm looking at the SQL used to generate the SSRS view of the Invoice Pool but still can't work out how it omits invoices (or their PO lines) that have been processed and that no longer exist in the pool listing.

Amy ideas what field the system uses to decide that an invoice no longer belongs in the invoice pool?

I have the same question (0)