cancel
Showing results for 
Search instead for 
Did you mean: 

Invoice Doc Display for Ship to country

Former Member
0 Kudos

Hi,

I am trying to Display Invoice Doc's based on Ship-to-country.

I am Displaying Invoice amount, Payment amnt and With holding tax amnt.

I am getting Payment Doc's(cleared) and Invoice Doc's from BSAD.

Here the problem is I am able to get Ship-to-country for only Invoice Doc's.I am not getting for Payment Doc's.

For Ex:If there are multiple Invoices for 1 Payment Doc and the Invoices are for Different Ship-to, Only specified Ship-to Invoices will be captured.

Here the criteria is Total Invoice amnt should be equal to Sum of the Payment amnt and Withhold amnt.

Same situation will arise when multiple payment document's for multiple Invoices.

They way I am taking Ship-to-country is From Invoice doc>Sales doc>Ship-to.

Please help me if any thing I missed in the flow to get the correct result.

Thanks in Advance for your reply.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

hi,

is it available in VBRK table , check that if it so use that ship to

cheers,

sasi

Former Member
0 Kudos

Hi,

Thanks for your responce.

This may solve the problem but here for other than invoice doc's I am not getting Invoice numbers to search in VBRK

Thanks.

Former Member
0 Kudos

hi,

invoce number and invoice document number are same. you just give the same invoice document number here.

otherwith check with XBLNR ( reference document number )

cheers,

sasi

Former Member
0 Kudos

Hi,

yes, for doc type RV, XBLNR is invoice doc only but for DZ

AB CI.... like these docs, XBLNR is not invoice doc.

these are the payment docs

Thanks

former_member185931
Participant
0 Kudos

have you tried looking at the detail table for BSID, BSAD is the header, maybe this table has all the invoice No paid by 1 payment document.

Former Member
0 Kudos

Hi Jagraj,

I didnot get what you are trying to say.

If possible plzzz elaborate.

Already I am retreving data from BSAD.

So once Doc is cleared we dont see it in BSID.It will be in BSAD.

Thanks.

former_member185931
Participant
0 Kudos

I was wrong, BSID is the open items, I will see if I can find some more information and update this.