Open Sales Orders

[Former Member]

I need to create a report to list Open Sales Orders.What is the logic behind determining is a Sales Order is open or not?If a Sales Order has an associated Invoice and its Delivery status is completed it shouldn't be considered under Open orders right?

[Former Member]

I need to create a report to list Open Sales Orders.What is the logic behind determining is a Sales Order is open or not?If a Sales Order has an associated Invoice and its Delivery status is completed it shouldn't be considered under Open orders right?

[Former Member]

Hi ,

Check table VBUK and VBUP for delivery status "LFSTK" and billing status "FKSTK".

Lanka

Message was edited by: Lanka Murthy

[Former Member]

Hi,

You can get the logic from VA05 Transaction.

check the check box and run the trxn.

regards

vijay

[Former Member]

Hi Akhila,

First check for the field VBAP-KZTLF for Open orders.VBAK-AUTLF for complete delivery.

[Former Member]

Hi all,

Thanks a lot for your answers.I will use these options and try to create a report.I think if my report output matches the output of VA05,then I have got it right.

[Former Member]

Yes exactly, your report output and VA05 Open order should match.

regards

vijay