How to find out Outstanding Sales Order (Order amount has not yet issued billing to customer)

[iberischeong]

Hi

I tried to run VA05N but they found that both down payment document
and cancellation SO document are included in the report even though they choose
“Open Sales Order”.

Is there a a way to run report so that to exclude above documents to get entire Open Sales Order?

I tried some other transactions, VF04 or FBL5N, its not useful. FBL5N provides “Open item of Customer Invoice” (already Bill to customer but has not yet issued Incoming Payment). But what we wanted was a report that provides Outstanding Sales Order (Order amount has not yet issued billing to customer).

[jignesh_mehta3]

Hello Iberis,

While using VA085N, you can select the required Doucment Types or remove the non-required Doucment from the Selection Creteria.

Hit the Multiple selection Button (button with Right side arrow) against the Order Type & list the Order type that you wish you include in the report output.

Alternatively as suggetsed by Siva above you can create a Query or cretae a Z-Report as a permanent solution.

Thanks,

Jignesh Mehta

[bsivasankarreddy_reddy]

hi

you can use QUERY  then you attach the table, then you find the you requirement

vbak, vbap fields you use,

you can zreport depending on query ,

SQ01, SQ02, SQ03, SQVI use this t codes