web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / BYOD Entity Export Mis...
Finance | Project Operations, Human Resources, ...
Suggested Answer

BYOD Entity Export Missing Rows

(0) ShareShare
ReportReport
Posted on by zachary.robinson@gt... 99

I am attempting to export the 'Customer invoice journal line' entity to our Azure SQL DB. The "header" entity for this entity (Customer invoice journal header) exported successfully, and I will add that the 'Customer invoice journal line' entity also exported "successfully". The issue I am having is that the 'Customer invoice journal line' entity only exported 2 rows as I can see in SQL Server Management studio. The 'Customer invoice journal header' entity has thousands of rows, which would indicate to me that there should be exponentially more rows listed in the 'Customer invoice journal line' than just 2 rows. 

pastedimage1614627288067v3.png

 I did not see anything indicated filtering taking place on export. I am not sure if this has anything to do with it, but in the mapping view for the staging and target tables of the 'Customer invoice journal line' entity, the 'Row Id' field of the staging table does not map to anything on the target table, but not sure how this would cause only 2 records to export successfully while the others do not. 

pastedimage1614627267414v2.png

Any idea what could be causing this?

Thank you in advance!

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,711 Super User 2026 Season 1 on at

    Hi Zach,

    Do you need to export details from Free text invoices or sales order invoices? If you need the lines from the sales order invoices, then try the entity 'Customer invoice lines'. The one you used now is having details from free-text invoice lines.

  • zachary.robinson@gtl.net Profile Picture
    zachary.robinson@gt... 99 on at

    Hi André,

    Thank you for your response. Unfortunately, on my end I do not see the prescribed entity listed in the entity list ('Customer invoice lines'). 

    pastedimage1614650524136v1.png

    Just to be clear, are the entities 'Customer invoice journal header' and 'Customer invoice journal line' in this list the free-text invoices? If so, how would these differentiate from the 'Customer free text invoice' entity listed here?

    I appreciate your time in responding, please let me know if I need to clarify anything further. 

  • Suggested answer
    Ajit Profile Picture
    Ajit 8,788 on at

    Did you try the full push? and also can check the company (DataAreaId) you are pushing for.

  • nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    In which legal entity did you create the export project?

    How many invoices do you have in that legal entity?

  • zachary.robinson@gtl.net Profile Picture
    zachary.robinson@gt... 99 on at

    Hey Ajit, yes we have selected 'Full push only' for the default refresh type, if that is what you are asking. Also, I am not quite sure if I am on the right page, is this what you are asking about in your second comment? 

    pastedimage1614696393562v1.png

    If I select 'Table' instead of 'All' for the 'Valid For' column, the data area provides a drop-down for our company and a 'DAT' data area. Selecting 'All' does not allow a data area selection

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    You could check what is the legal entity (field "Company accounts") for the batch job that you created for the data push.

  • zachary.robinson@gtl.net Profile Picture
    zachary.robinson@gt... 99 on at

    Hey Nikolaos,

    Under our job history, our Company is listed in the Company column. If I understand correctly, the other legal entity would be 'DAT' correct? If so, that is not listed here for this export job.

    Thank you both for helping out on this!

  • nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    Yes, then it seems to run in the correct company.

    If we forget BYODB for a while, what happens if you create a new data project and try to export all the invoice lines to a file?

  • zachary.robinson@gtl.net Profile Picture
    zachary.robinson@gt... 99 on at

    Thanks, Nikolaos.

    I did an export job to Excel for the 'Customer invoice journal line' entity, and even that returns just two rows. I also did an export for the 'Customer invoice journal header' entity, which I understand to be the journal headers pertaining to the 'Customer invoice journal line' data, and that exported about a 1000 rows, of which contained the journal number of the 2 transactions listed in the 'Customer invoice journal line' entity.

  • Suggested answer
    Ajit Profile Picture
    Ajit 8,788 on at

    looks like entity is returning two rows then. Verify the base table rows, you can check table browser 

    https://your environment URL/?mi=SysTableBrowser&TableName=LedgerJournalTrans&cmp=PUTYOURDATAREAIDHERE&limitednav=true&lng=en-us

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 608

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 591 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 430

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans