How to obtain sales orders that have not been invoiced

[Former Member]

Dear Gurus and Experts,

Could you please provide me some info about the following scenario:

Scenario:  If there are 2 orders in the system with different delivery dates, user should not be able to invoice the one with later delivery date without first invoicing the order with earlier delivery date.

How can I obtain a list of all the sales orders in the system that have not been invoiced yet?

Once I get that, how can I obtain their delivery dates?  I am creating a custom report!

Thank you all in advance.

Regards,

Keerthi

[joseantonio_martinez · Accepted solution]

Dear Keerthi:

With VBUK or VBUP table you can obtain Billing status for the sales order VBUK-FKSAK /VBUP-FKSAA

And for the delivery date you can use  VBEP table with field VBEP-EDATU.

Please check it and revert

Regards

Jose Antonio

[Former Member · Accepted solution]

Dear Jose,

I will check this and revert back soon.

Regards,

Keerthi

[Former Member · Accepted solution]

Dear Jose, thanks for ur advice. It works!

[joseantonio_martinez · Accepted solution]

Thanks for the feedback