You’re offline. This is a read only version of the page.
436
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?
Share
Report
All responses (
Answers (
