How to link Vendor Invoice to Customer Invoice in Third Party Sales Custom Report

[Former Member]

I have a requirement wherein I want the Invoice to have as many line items as MIRO have if partial delivery happens... invoices (one for each MIRO)..

We are currently using the Third Party with Shhipping notification...

I have tried using VF04 for billing but only one line item is coming for Billing in Invoice...

I mean how to link the RSEG - partial vendor Invoice line items to Invoice...

Ex: Third Party Order 20 qty

Partial delivery 12 & 8... I can see 2 MIRO line item values in the table RSEG...

  If i do invoice in VF04..i can only see 1 line item for total billing....

  Can anybody help me how to solve this??? How can i link

  Vendor Invoice to the Customer Invoice....

  I have to solve this for a Third Party report???

  Thanks in Advance...

[Former Member]

Hi,

   Check VBRP[Billing Item] table for fetching line items.

Regards,

Senthil Venugopal

[Former Member]

Hi Senthil,

I have seen the table VBRP..but it is showing only 1 line item 20 against 2 invoices 12 & 8...

My requirement is that VBRP should show 2 line items of Vendor invoices 12 & 8...

[Former Member]

Hi Venkat,

              Let me know what you are passing in VBRP.

Regards,

Senthil Venugopal

[Former Member]

Hi Senthil,

I am passing the Billing Doc no in VBRP.....i could see only 1 line item if the full qty ( not the partial Qty)...

[Former Member]

Hi Venkat,

              Can you elaborate the steps you follow.

Regards,

Senthil Venugopal