Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Free Text Invoice - missing entity?

Posted on by 436

I used to be able to download entities for Free Text Invoice Headers and separately for Free Text Invoice Lines - and join them in PowerBI to be able to see all the descriptions on the invoice lines themselves. On our 10.0.12 Dynamics System, I can see FreeTextnvoiceStaging and that's complete. However, the only entity that now appears to contain FreeText Invoice lines is "Free text invoice line transaction tax information", which contains zero records.

Any ideas where the populated table of free text invoice lines exists these days?

Ian W.

  • Suggested answer
    Ian Waring Profile Picture
    Ian Waring 436 on at
    RE: Free Text Invoice - missing entity?

    Got it. Thank you. I can see them through th eODATA connection in PowerBI.

  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,300 Most Valuable Professional on at
    RE: Free Text Invoice - missing entity?

    Hi,

    I doubt on this.

    Can you tell me what was the data entity name it is missing in 10.0.12?

    I have both version now, I can compare.

  • Verified answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,089 on at
    RE: Free Text Invoice - missing entity?

    Hi Ian,

    There are 3 entities for free text invoices, but only 1 of them available for data management.

    FreeTextInvoiceEntity - visible in data entity list, header + lines are combined (data management is available)

    FreeTextInvoiceHeaderEntity - not visible in data entity list (data management is not available)

    FreeTextInvoiceLineEntity - not visible in data entity list (data management is not available)

    Are you sure you saw them in the list before?

    Also, you can download data to PowerBI through oData entities directly.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Free Text Invoice - missing entity?

    Hi Ian,

    From the data entities screen, can you try adding manually (using the new button) and see if you can see the entity in the drop down list?

  • Ian Waring Profile Picture
    Ian Waring 436 on at
    RE: Free Text Invoice - missing entity?

    All refreshed (thank you for the advice) but still no Free Text Invoice Lines Entity:

    CDS customer free text invoice headers
    CDS customer free text invoice lines
    Customer free text invoice
    Free text invoice form printing configurations
    Free text invoice line transaction tax information

    are the only entities containing "free text" in the entity list.

    Any other ideas?

    Ian W.

  • Suggested answer
    Junaid Idrees Profile Picture
    Junaid Idrees 12,746 on at
    RE: Free Text Invoice - missing entity?

    Hi Ian Waring,

    It seems, free text invoice data entity is missing in your DMF.

    Please check the following site to refresh data entity list.

    community.dynamics.com/.../how-to-refresh-data-entity-list-in-dynamics-365

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Free Text Invoice - missing entity?

    Hi Ian,

    Go to Workspaces > Data management > Framework parameters > Entity settings > Refresh entity list.

    Workspaces > Data management > Data entities.  You can check if you can find the entities in this list now. 

  • Ian Waring Profile Picture
    Ian Waring 436 on at
    RE: Free Text Invoice - missing entity?

    Hiya,

    I can see:

    Customer free text invoice (staging table is FreeTextInvoiceStaging) - 29,705 records
    Free text invoice form printing configurations (staging table is CustFormletterCustomerFreeTextInvoiceFormPrintingConfigurationStaging)
    Free text invoice line transaction tax information (staging table is TaxFreeTextInvoiceLineTransTaxInformationStaging) - 0 records

    There is no FreeTextInvoiceLineEntity in the Entity List in Data Managerment.

    We're running Dynamics Finance 10.0.12 (10.0.507.10054)

    A couple of CDS related ones are present:

    CDS customer free text invoice headers (20,079 records)
    CDS customer free text invoice lines (0 records)

    So, unsure which way to go from here.

    Ian W.

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,647 Moderator on at
    RE: Free Text Invoice - missing entity?

    Hi Ian ,

    Which version you are using ? I can still both header and line entity in my environment.

  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,300 Most Valuable Professional on at
    RE: Free Text Invoice - missing entity?

    Hi,

    You can check from data entities tiles from DIXF.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans