How to connect a Sales Return Order with a Sales Order

(0) Share

Report

Posted on by Christos Christou

511

Hi there,

We are importing Sales Orders from Hybris e-commerce platform as XML files. The customer now requests to import Sales Returns as well. When creating the Sales Return Order in Hybris, the customer will have to enter the Sales Order number so we can match those two documents.

What is the best way to connect those two documents? As I have noticed there is no field "Order No." in the Sales Header table 36. Actually, that's correct because what differentiates those two is the Document Type field.

Any ideas?

Thanks

*This post is locked for comments

All responses (7)

Answers (2)

Christos Christou 511 on at

Like (0)

Report

RE: How to connect a Sales Return Order with a Sales Order

Thanks Khoa
Verified answer

4BzSoftware 6,071 on at

Like (1)

Report

RE: How to connect a Sales Return Order with a Sales Order

Hi Christos,

You can use Applies-to Doc. Type and Applies-to Doc. No. fields in Invoicing FastTab. This link provides you more information msdn.microsoft.com/.../hh178599(v=nav.90).aspx
Suggested answer

Christos Christou 511 on at

Like (0)

Report

RE: How to connect a Sales Return Order with a Sales Order

Thanks
Suggested answer

Christos Christou 511 on at

Like (0)

Report

RE: How to connect a Sales Return Order with a Sales Order

Thanks Alexander
Verified answer

Alexander Ermakov 28,094 on at

Like (1)

Report

RE: How to connect a Sales Return Order with a Sales Order

If you want to have a link in NAV that would match your Sales return order with initial Sales Order, you can use some of the existing fields that might be not in use so far, e.g. "Shipping No." or "Posting No.", "Your reference" or a comment field. "External Document No." can also fit as Vishal mentioned, in case you do not need to keep specific return external number.
Christos Christou 511 on at

Like (0)

Report

RE: How to connect a Sales Return Order with a Sales Order

Thanks Vishal
Suggested answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: How to connect a Sales Return Order with a Sales Order

Hi,

You can use the "External Document No." field at Return Order to capture the "Sales Order No.".

This way you can generate the report later, if needed.

Hope this helps.

Best Regards,

Vishal Salot