Dispatch Report only for Invoiced Deliveries

[Former Member]

Dear Gurus,

I am developing a Dispatch Report, where all the deliveries are included but the business User wants only Invoiced Deliveries rather than all Deliveries... could anyone help me from which table I can get that data and what is the Field name...

Ur Help is valued.

[Lakshmipathi]

You have to consider table VBFA where field POSNN should not be blank

thanks

G. Lakshmipathi

[Former Member]

Hi LakshmiGanapathi,

Thanks for quick reply...

wat exactly i need is The report should only contains Invoiced Deliveries, so is there any Field directly avaiable in R3 or is there any Logic to make it done.

sorry for being basic....

Edited by: Harsha on Feb 1, 2011 12:26 PM

[Former Member]

Hi Harsha,

From VBFA table take field VBTYP_N =M (m=invoice) then pickup delivery no J=delivery.

check VBFA table where you will get all data then you can develop report as per your logic.

Hope will help you.

Thanks

Trupti