Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / DMF for Open Invoice t...
Finance forum
Suggested answer

DMF for Open Invoice transaction

editSubscribe (2) ShareShare
ReportReport
Posted on by 226
 Hello Team,
 
I would like to extract data via DMF all Open vendor PO Invoice and Non PO invoice. Is there a available data entity for this please?
 
thank you!
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 223,155 Super User on at
    DMF for Open Invoice transaction
    The data source of Open vendor invoices form is VendTrans and VendTransOpen. I don't see any data entity that would simply extract information from VendTransOpen table, but it's used in some data entities such as VendPaymentBIVendTransOpen or VendorPaymentJournalLineSettledInvoiceEntity. You can use references to find all such entities. If none of them meets your requirements, you'll have to create a custom entity.
     
    (Moved from Dynamics AX forum.)
  • D365 Newbie Profile Picture
    D365 Newbie 226 on at
    DMF for Open Invoice transaction
    Hello Martin, I'm using D365 FO. version 8.1.1.492
  • Martin Dráb Profile Picture
    Martin Dráb 223,155 Super User on at
    DMF for Open Invoice transaction
    Which version of Dynamics AX are you using?
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    DMF for Open Invoice transaction
    Hi,
    You can check if this thread helps:
    Pending vendor invoices via data entities (dynamics.com)
    Best Regards,
    Hana

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,361 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,155 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans