SalesLine table export

(0) Share

Report

Posted on by AstridMalanka

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!!

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

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

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (1)

Report
Copy link

Link copied!

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!!

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,172 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No