topic Re: Return Order / Standard Order link in Application Development and Automation Discussions

Return Order / Standard Order link

Former Member — Tue, 16 Nov 2010 20:22:58 GMT

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.

Re: Return Order / Standard Order link

Former Member — Tue, 16 Nov 2010 20:29:39 GMT

Try:

VBFA - Sales Document Flow

Where VBTYP = 'H' (Returns).

Rob

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

Re: Return Order / Standard Order link

Former Member — Wed, 17 Nov 2010 14:47:14 GMT

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

Re: Return Order / Standard Order link

Former Member — Wed, 17 Nov 2010 15:41:05 GMT

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,

Re: Return Order / Standard Order link

Former Member — Wed, 17 Nov 2010 15:54:47 GMT

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.

Re: Return Order / Standard Order link

Former Member — Wed, 17 Nov 2010 16:00:05 GMT

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

Re: Return Order / Standard Order link

Former Member — Thu, 18 Nov 2010 18:15:38 GMT

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.

Re: Return Order / Standard Order link

Former Member — Thu, 18 Nov 2010 18:31:31 GMT

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.

Re: Return Order / Standard Order link

Former Member — Wed, 08 Feb 2012 15:01:31 GMT

solved