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!!
Thanks for the replies, it took me a while to understand, but I followed your advice and added extensions.
thanks, i will look into all of it, and let you know.
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.
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
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!!
Which columns? Just add them to the standard entity with extension.
What do you mean by aggregate data? Can you give some example?
The problem is that I am missing a number of columns and the aggregated data
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.
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156