sales order status

[Former Member]

Hi,

My requirement is to show sales order by its status against billed amount.

i.e.

if the net value and billed amount of the sales order is same then it's full order...

Header 1	Header 2	Header 3	Header 4
Sales order	Net value	Billed amount	Status
123456	100.00	100.00	Full
456789	100.00	50.00	Partial
789012	100.00	0	Open

How do I achieve this status? At the moment, i export data to exel and doing Vlookup against COPA datasource billed amount data to achieve these statuses but I want to find out the status of sales orders in bex query.

I am using following data sources

2LIS_11_VAHDR

2LIS_11_VAITM

Shall I be using difference datasource to achive this in bex query itself rather then doing vlookup?

Thank you

Darsh

[Former Member]

Hi Darsh,

you can extract billing details from 2LIS_13_VDITM and merge order and billing details in DSO and then do reporting on top of this flow.

but this would require design change.

Regards,

Sakthi.

[Former Member]

Hi Sakthi,

Thank you for your reply. I will work on your suggestion and will let you know.

Regards,

Darsh