Skip to main content

Notifications

Announcements

No record found.

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

SalesLine table export

(0) ShareShare
ReportReport
Posted on by 449

Hi,

I am trying to export the salesline table, so I created an entity that is called Order Line.

I am trying to export it to the database, or even to excel but it comes up empty, when I go to the database the data is on the table.

Why am I not able to export data using that entity?

Thanks!!

  • AstridMalanka Profile Picture
    AstridMalanka 449 on at
    RE: SalesLine table export

    Thanks for the replies, it took me a while to understand, but I followed your advice and added extensions. 

  • AstridMalanka Profile Picture
    AstridMalanka 449 on at
    RE: SalesLine table export

    thanks, i will look into all of it, and let you know.

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: SalesLine table export

    You can add delivery remainder to the standard entity via extension.

    About the extra line, I would try to understand what it is, instead of developing a new entity to get rid of it. Most likely your new entity would also show similar record.

    First you need to use table browser, as well as look directly in the database, perhaps already that helps you understand what that line is.

    If you think developing a new entity is the best approach, try removing dimension related data sources and see if your entity now returns something. I've seen issues many times with the (financial) dimension data sources generated by the entity wizard.

  • AstridMalanka Profile Picture
    AstridMalanka 449 on at
    RE: SalesLine table export

    Hi,

    I did some more digging, and here is what I found.

    We need all the orders including the returns, and we need all the fields from the form salesline opened order.

    the issue we are having with sales_order_line_v2 is we are missing a delivery remainder and also in come cases we get an extra line that sums the ordersalesquanty.

    And there is no indication that the 238 is a sum of the other 3. (we are not sure why that happens.

    LINEAMOUNT  ORDEREDSALESQUANTITY

    83457.000000  99.000000

    33720.000000  40.000000

    83457.000000  99.000000

    .000000          238.000000

  • AstridMalanka Profile Picture
    AstridMalanka 449 on at
    RE: SalesLine table export

    I am not sure, that is what I was told, I will do some digging myself and give you samples in case I find it.

    thanks!!

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: SalesLine table export

    Which columns? Just add them to the standard entity with extension.

    What do you mean by aggregate data? Can you give some example?

  • AstridMalanka Profile Picture
    AstridMalanka 449 on at
    RE: SalesLine table export

    The problem is that I am missing a number of columns and the aggregated data

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: SalesLine table export

    I really recommend you checking the standard entity and seeing if it fulfills your business requirement.

    You can fix the relationships. It's just potentially a lot of work that is not needed because there is already an entity that most likely suits your business requirement.

  • AstridMalanka Profile Picture
    AstridMalanka 449 on at
    RE: SalesLine table export

    Thanks for your reply, I am very new to this.

    From what I was told, the standard order lines v2 summarize data and also are missing a number of columns.

    Is there a way I can try to understand the issues on the relationships? Can I even fix it?

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: SalesLine table export

    I suggest you use the standard Sales order lines V2 entity so you don't need to use any time & money for development.

    Why your entity returns nothing? Most likely it's because of some relations in the child data sources of your entity, that are generated by the wizard.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans