SalesLine table export

(0) Share

Report

Posted on by AstridMalanka

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

All responses (10)

Answers (1)

AstridMalanka 449 on at

Like (0)

Report

RE: SalesLine table export

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

Like (0)

Report

RE: SalesLine table export

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

nmaenpaa 101,156 on at

Like (1)

Report

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 449 on at

Like (0)

Report

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 449 on at

Like (1)

Report

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 101,156 on at

Like (0)

Report

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 449 on at

Like (0)

Report

RE: SalesLine table export

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

nmaenpaa 101,156 on at

Like (0)

Report

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 449 on at

Like (0)

Report

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 101,156 on at

Like (0)

Report

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.