Return Order / Standard Order link

[Former Member]

Does anyone know how I can retrive the original standard order number for a given return order number with relying on the copy reference fields, XBLNR.

[Former Member]

Does anyone know how I can retrive the original standard order number for a given return order number with relying on the copy reference fields, XBLNR.

[Former Member]

Try:

VBFA - Sales Document Flow

Where VBTYP = 'H' (Returns).

Rob

Edited by: Rob Burbank on Nov 16, 2010 3:34 PM

[Former Member]

I have the return order and need the prior (original) sales order.

[Former Member]

Hi,

Try this way..

get the Returns Delivery number(VBELN ) by passing Returns order number and VBTYP_N = T from VBFA.

Then Fetch the Original Sales Order(VBELV) from VBFA by passing Returns delivery number to VBELN.

Regards,

KC

[Former Member]

This gives TO, goods movement, and credit memo of the return. Not the original order.Our process is:

SO-DEL-INV------Return Order-Return Del-CR Memo

It seems the return process is not linked at all the original sales process.

[Former Member]

if you know the invoice for which the item is returned, retrieve the original sales order from VBRP, looking at the order or prior document fields, like VBRP fields:

VBELV

POSNV

VGBEL

VGPOS

VGTYP

AUBEL <SO doc

AUPOS <SO Item

AUREF <SO was with reference

[Former Member]

all of these fields reference documents subsequent to the return order. I don't think there's a way to do this if the person doing the return doesn't use the original sales order/delivery/invoice as a reference.

[Former Member]

not true...If the original order has been invoiced and the return references an invoice number, the invoice referenced for the return points to the PREVIOUS documents, including the original order no.

[Former Member]

solved