Open sale order aging report

[Former Member]

Need a report on open order aging. The open order means not delivered or partially delivered. Further with days range since its open or not fully delievered i.e. > 15 days or 15-30 days and so on.

The standard transactions Va05 and VL10c can provide the list but dont provide any aging info.

Kindly help in this.

thanks

anu

[Former Member · Accepted solution]

Use transaction SD01 , where you can get orders within specified time.

reward if useful

rajesh

[Former Member]

Honestly, you should write a z report which checks the open orders , and partial deliveries and not delivered.This can done with the VBUP tables and VBFA Tables.

reward if useful

rajesh

[former_member228783]

This message was moderated.

[jiteshmehta]

Dear Anu

1. First in VA05 you can use Variants and get the report as desired by you,create one variant and use Filter along with greater then, less then (all are in selection option icon)

This way you can create three variants.

But limitation is dates has to be manually changed in variants each time.

2. Try this Tcodes

S_ALR_87014387 Display Document Flow

S_ALR_87014392 Display Document Flow

This reports will give you document flow run report with ticking checkbox for sales order,delivery and goods isse then after getting the list expand all (Shift+F12)

you will get the quantities for sales order, and what is delivered and what is issued.

3. As such if you want exactly the report you can take help of ABAP to create the ALV

4. Report or create Queries in SQVI , or else create MCSI report

Regards

Jitesh

[Former Member]

Dear rajesh,

thanks for quick response but how to find out which orders are open means not delivered or partially delivered.

Kindly reply.